Week 3

Student Exam 1/16/12 9:14 AM Week 3 : Managing Assets and Resources in the Digital Firm – Homework Save Answers Submit for Grading 1. A characteristic or quality describing an entity is called a(n) (Points : 1) field. tuple. key field. attribute.

2. The confusion created by _____ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources. (Points : 1) batch processing data redundancy data independence online processing

3. Duplicate data in multiple data files is called (Points : 1) data redundancy. ata multiplication. data independence. data backups.

4. A DBMS (Points : 1) makes the physical database available for different logical views. makes the logical database available for different analytical views. makes the physical database available for different analytical views. makes the relational database available for different analytical views.

5. The logical view (Points : 1) shows how data are organized and structured on the storage media. presents an entry screen to the user. allows the creation of supplementary reports. presents data as they would be perceived by end users.

6.The type of logical database model that treats data as if they were stored in two-dimensional tables is the (Points : 1) OODBMS. pre-digital DBMS. relational DBMS. hierarchical DBMS.

7. A field identified in a table as holding the unique identifier of the table’s records is called the (Points : 1) primary key. key field. http://takeexam. next. ecollege. com/(NEXT(f83986aacf))/Main/CourseM…703=rDEJX%252foi1wqaW6CBxURnSNa8tZLcim9DauNr3z3CFpI%253d& Page 1 of 3 Student Exam 1/16/12 9:14 AM primary field. unique ID.

8. The data dictionary serves as an important data management tool by (Points : 1) ssigning attributes to the data. creating an inventory of data contained in the database. presenting data as end users or business specialists would perceive them. maintaining data in updated form.

9. An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the (Points : 1) data dictionary. data definition diagram. entity-relationship diagram. relationship dictionary.

10. Which is the type of database management approach that can handle a large number of pages or documents? Points : 1) Hierarchical DBMS Relational DBMS Network DBMS NoSQL

11. Which is the most prominent data manipulation language today? (Points : 1) Access DB2 SQL Crystal Reports

12. DBMSs typically include report-generating tools in order to (Points : 1) retrieve and display data. display data in an easier-to-read format. display data in graphs. perform predictive analysis.

13. A schematic of the entire database that describes the relationships in a database is called (Points : 1) the data dictionary. the intersection relationship diagram. the entity-relationship diagram. the data definition diagram.

14. What is the process of streamlining data to minimize redundancy and awkward many-to-many relationships? (Points : 1) Normalization Data scrubbing Data cleansing Data defining http://takeexam. next. ecollege. com/(NEXT(f83986aacf))/Main/CourseM…703=rDEJX%252foi1wqaW6CBxURnSNa8tZLcim9DauNr3z3CFpI%253d& Page 2 of 3 Student Exam 1/16/12 9:14 AM

15. Cloud computing offers (Points : 1) no database functions. some database functions. products only from Amazon and Microsoft. None of the above

16. A data warehouse is composed of (Points : 1) historical data from legacy systems. current data. internal and external data sources. istoric and current internal data.

17. A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because (Points : 1) a data mart typically focuses on a single subject area or line of business. all the information is historical. a data mart requires a Web interface. all of the information belongs to a single company.

18. Data mining is a tool that allows users to (Points : 1) quickly compare transaction data gathered over many years. find hidden relationships in data. obtain online answers to ad hoc questions in a rapid amount of time. summarize massive amounts of data into much smaller, traditional reports.

19. What is the tool that enables users to view the same data in different ways using multiple dimensions? (Points : 1) Predictive analysis SQL OLAP Data mining 20. OLAP is a tool that enables (Points : 1) users to obtain online answers to ad hoc questions in a short amount of time. users to view both logical and physical views of data. programmers to quickly diagram data relationships. programmers to normalize data. Save Answers Submit for Grading http://takeexam. next. ecollege. com/(NEXT(f83986aacf))/Main/CourseM…703=rDEJX%252foi1wqaW6CBxURnSNa8tZLcim9DauNr3z3CFpI%253d& Page 3 of 3