Question 1

What is a database? Why is it a better system of information organization compared to a file processing system?

Accepted Answer

A database is an integrated collection o...

Question 2

Making changes to an integrated database is considered a challenge because ________.

Accepted Answer

A)  it requires extensive changes to the source code
B)  it renders data obsolete
C)  it takes less time from IT but more from the end users
D)  it exposes the database to external threats

Question 3

Julian, a database administrator, prepares data to be loaded to a data warehouse. He checks the zip code field against a reference database of zip codes to ensure that it conforms to standards. The zip codes that aren't in the standard format are reformatted. This process is called ________.

Accepted Answer

A)  extraction
B)  transformation
C)  loading
D)  normalization

Question 4

Trekking blindly into terabytes of data to sniff out meaningless relationships that occur just by accident is called ________.

Accepted Answer

A)  data mining
B)  data drudging
C)  data modeling
D)  normalizing

Question 5

Database developers should use meaningful information for primary keys.

Accepted Answer

A) True 
 B)False

Question 6

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 7

What does functional dependence mean? Illustrate with an example.

Accepted Answer

Functional dependence means that for eac...

Question 8

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 9

An approach that attempts to achieve consistent and uniform definitions for entities and their attributes across all business units is called ________.

Accepted Answer

A)  normalization
B)  master data management
C)  data modeling
D)  database mirroring

Question 10

SQL links tables together by ________.

Accepted Answer

A)  using primary keys and foreign keys
B)  using data stored in cloud computers
C)  assigning incremental numbers to records
D)  assigning XML tags to the tables

Question 11

Which of the following database architectures relies on a cooperating collection of existing databases?

Accepted Answer

A)  data mining
B)  data cubes
C)  virtual federated warehouse
D)  data warehouse appliance

Question 12

Which of the following is a characteristic of structured information?

Accepted Answer

A)  It cannot be linked together to enable searching and sorting.
B)  It can be broken down into component parts and organized in hierarchies.
C)  It is contained in physical data storage such as printouts.
D)  It only includes homogenous data types in one set of information.

Question 13

Which of the following is a function of normalization?

Accepted Answer

A)  assigning primary keys
B)  assigning incremental numbers to records
C)  minimizing duplication of information
D)  decreasing the functional dependency of data

Question 14

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 15

Structured information can be defined as data ________.

Accepted Answer

A)  that can be organized into hierarchies
B)  that cannot be linked together
C)  about data that clarifies the nature of the information
D)  that is difficult to break down

Question 16

White and Brown, a legal firm, stores details of each case in physical files and folders. The firm has a back room stacked with boxes containing hundreds of files. White and Brown's storage structure resembles ________.

Accepted Answer

A)  semi-structured information
B)  unstructured information
C)  meta data
D)  relational data

Question 17

Which of the following uses databases without boundaries?

Accepted Answer

A)  a government website offering information to visitors
B)  a social networking website
C)  a bank website
D)  a management information system

Question 18

During mergers, integration of multiple databases becomes a major challenge.

Accepted Answer

A) True 
 B)False

Question 19

In a relational database, information is organized into tables in which each row represents a(n) ________.

Accepted Answer

A)  record
B)  field
C)  attribute
D)  primary key

Question 20

A drawback of the hierarchical database was that ________.

Accepted Answer

A)  it was ineffective at handling many-to-many relationships
B)  it did not mimic every detail of an organizational chart
C)  it worked only for one-to-one relationships
D)  it failed to reduce redundancies introduced by file systems

Exam 4: Databases and Datawarehouses

SQL links tables together by ________.

Correct AnswerverifiedShow Answer

Which of the following is a function of normalization?

Correct AnswerverifiedShow Answer

Structured information can be defined as data ________.

Correct AnswerverifiedShow Answer

What is a database? Why is it a better system of information organization compared to a file processing system?

Correct AnswerverifiedA database is an integrated collection o...View AnswerShow Answer

A database schema is used to ________.

Correct AnswerverifiedShow Answer

During mergers, integration of multiple databases becomes a major challenge.

Correct AnswerverifiedShow Answer

Trekking blindly into terabytes of data to sniff out meaningless relationships that occur just by accident is called ________.

Correct AnswerverifiedShow Answer

Which of the following database architectures relies on a cooperating collection of existing databases?

Correct AnswerverifiedShow Answer

White and Brown, a legal firm, stores details of each case in physical files and folders. The firm has a back room stacked with boxes containing hundreds of files. White and Brown's storage structure resembles ________.

Correct AnswerverifiedShow Answer

Julian, a database administrator, prepares data to be loaded to a data warehouse. He checks the zip code field against a reference database of zip codes to ensure that it conforms to standards. The zip codes that aren't in the standard format are reformatted. This process is called ________.

Correct AnswerverifiedShow Answer

An approach that attempts to achieve consistent and uniform definitions for entities and their attributes across all business units is called ________.

Correct AnswerverifiedShow Answer

Database developers should use meaningful information for primary keys.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following is a characteristic of structured information?

Correct AnswerverifiedShow Answer

Which of the following uses databases without boundaries?

Correct AnswerverifiedShow Answer

In a relational database, information is organized into tables in which each row represents a(n) ________.

Correct AnswerverifiedShow Answer

What does functional dependence mean? Illustrate with an example.

Correct AnswerverifiedFunctional dependence means that for eac...View AnswerShow Answer

A drawback of the hierarchical database was that ________.

Correct AnswerverifiedShow Answer

Retrieval is very fast through data cubes because ________.

Correct AnswerverifiedShow Answer

Making changes to an integrated database is considered a challenge because ________.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A database is an integrated collection o...
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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Functional dependence means that for eac...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified