Question 1

In a university database, the student table, with student ID as a primary key, is linked to the university department table through its primary key-department ID. In the student table, department ID is a ________.

Accepted Answer

A)   foreign key
B)   primary key
C)   complex key
D)   functional key

Question 2

While using a word processor to create a project report, Ashley includes the subject, title, and the author's name in the report's properties. What type of information is Ashley adding to her report?

Accepted Answer

A)   metadata
B)   count data
C)   boolean data
D)   binary data

Question 3

What are the characteristics of high-quality information?

Accepted Answer

High-quality information is accurate, pr...

Question 4

In enterprise information management, data ownership issues arise because ________.

Accepted Answer

A)   data is often taken from external sources
B)   the quality of data varies across departments
C)   data is often stored in databases on external servers
D)   data is shared by all the stakeholders in the organization

Question 5

Which of the following is a disadvantage of using shadow systems?

Accepted Answer

A)   longer time to retrieve information
B)   lack of stability and security
C)   requirement of tools that are not easily available
D)   lack of documentation and support

Question 6

What is the main drawback of using unstructured information?

Accepted Answer

A)   It hinders creativity.
B)   It is expensive to maintain.
C)   It cannot be used to store numerical information.
D)   It makes retrieving information very difficult.

Question 7

Which of the following is a good master data management strategy?

Accepted Answer

A)   upgrading technology
B)   creating shadow systems
C)   creating a database schema
D)   focusing on key areas

Question 8

Kris, an IT manager at Park Infosystems, is handling four projects simultaneously. Each project has loaned and shared resources from other teams. The relationship between Kris and the project that he is working on represents a ________.

Accepted Answer

A)   one-to-many relationship
B)   many-to-one relationship
C)   many-to-many relationship
D)   one-to-one relationship

Question 9

Which of the following do database developers use to avoid anomalies that result when users try to insert, edit, or delete data?

Accepted Answer

A)   autonumbering
B)   accuracy checks
C)   normalization
D)   referential integrity

Question 10

Retrieval is very fast through data cubes because ________.

Accepted Answer

A)   data cubes use a separate server which is tuned for fast retrieval and reporting
B)   data cubes group data in logical dimensions, such as sales by product, city, region, and country
C)   data cubes represent information in the form of objects, using object-oriented programming languages to access them
D)   data cubes organize data by attaching XML tags to them

Question 11

Roman Jade, an interior decorations company, stores employee details in its employee information system. The birth date of each employee is stored along with other details, including employee names. The relationship between the employee names and employee birth dates is a ________.

Accepted Answer

A)   one-to-many relationship
B)   many-to-one relationship
C)   many-to-many relationship
D)   one-to-one relationship

Question 12

Which of the following is an early database approach that allowed flexible links to support many-to-many relationships?

Accepted Answer

A)   hierarchical database
B)   stratified database
C)   lean database
D)   network database

Question 13

Which of the following technologies is better equipped than relational databases to handle big data?

Accepted Answer

A)   MySQL
B)   Hadoop
C)   ETL
D)   SQL Server

Question 14

Which of the following databases resembles an organizational chart?

Accepted Answer

A)   network database
B)   hierarchical database
C)   stratified database
D)   cluster database

Question 15

Define relational database. Why are relational databases a standard in most organizations?

Accepted Answer

Relational database is the most widely u...

Question 16

Master data management has more to do with technology than people, processes, and governance.

Accepted Answer

A) True 
 B)False

Question 17

Documentation that contains the details of each field in every table, including user-friendly descriptions of the field's meaning, is known as ________.

Accepted Answer

A)   database schema
B)   data dictionary
C)   data model
D)   data definition

Question 18

What is the drawback of using Social Security Numbers (SSN)  as the primary key for tables of employees, hospital patients, students, or cable TV customers?

Accepted Answer

A)   Typing the nine digit SSN numbers is laborious and time consuming.
B)   Non-U.S. citizens may not have an SSN.
C)   It is not a confidential identification number.
D)   It is not a unique identification number.

Question 19

A database schema is used to ________.

Accepted Answer

A)   graphically document a data model
B)   record details of the fields in a table
C)   create a backup of a database
D)   identify redundant information in a database

Question 20

________ refers to collections of data that are so enormous in size, so varied in content, and so fast to accumulate that they are difficult to store and analyze using traditional approaches.

Accepted Answer

A)   Big data
B)   Data cube
C)   Meta data
D)   Shard

Exam 4: Databases and DataWarehouses

What is the drawback of using Social Security Numbers (SSN) as the primary key for tables of employees, hospital patients, students, or cable TV customers?

Correct AnswerverifiedShow Answer

Roman Jade, an interior decorations company, stores employee details in its employee information system. The birth date of each employee is stored along with other details, including employee names. The relationship between the employee names and employee birth dates is a ________.

Correct AnswerverifiedShow Answer

Which of the following is an early database approach that allowed flexible links to support many-to-many relationships?

Correct AnswerverifiedShow Answer

While using a word processor to create a project report, Ashley includes the subject, title, and the author's name in the report's properties. What type of information is Ashley adding to her report?

Correct AnswerverifiedShow Answer

Define relational database. Why are relational databases a standard in most organizations?

Correct AnswerverifiedRelational database is the most widely u...View AnswerShow Answer

Documentation that contains the details of each field in every table, including user-friendly descriptions of the field's meaning, is known as ________.

Correct AnswerverifiedShow Answer

Which of the following is a disadvantage of using shadow systems?

Correct AnswerverifiedShow Answer

Which of the following databases resembles an organizational chart?

Correct AnswerverifiedShow Answer

What is the main drawback of using unstructured information?

Correct AnswerverifiedShow Answer

What are the characteristics of high-quality information?

Correct AnswerverifiedHigh-quality information is accurate, pr...View AnswerShow Answer

Which of the following do database developers use to avoid anomalies that result when users try to insert, edit, or delete data?

Correct AnswerverifiedShow Answer

In enterprise information management, data ownership issues arise because ________.

Correct AnswerverifiedShow Answer

________ refers to collections of data that are so enormous in size, so varied in content, and so fast to accumulate that they are difficult to store and analyze using traditional approaches.

Correct AnswerverifiedShow Answer

Kris, an IT manager at Park Infosystems, is handling four projects simultaneously. Each project has loaned and shared resources from other teams. The relationship between Kris and the project that he is working on represents a ________.

Correct AnswerverifiedShow Answer

A database schema is used to ________.

Correct AnswerverifiedShow Answer

Which of the following is a good master data management strategy?

Correct AnswerverifiedShow Answer

Master data management has more to do with technology than people, processes, and governance.

Correct AnswerverifiedShow Answer

Retrieval is very fast through data cubes because ________.

Correct AnswerverifiedShow Answer

Which of the following technologies is better equipped than relational databases to handle big data?

Correct AnswerverifiedShow Answer

In a university database, the student table, with student ID as a primary key, is linked to the university department table through its primary key-department ID. In the student table, department ID is a ________.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Relational database is the most widely u...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
High-quality information is accurate, pr...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified