Question 1

Which of the following statements is true of a flat file system?

Accepted Answer

A)  Same data can be stored in more than one file. 
B)  Programs and data are independent. 
C)  Complex requests can be handled easily. 
D)  It requires very less storage space.

Question 2

The _____ stores data types for fields, default values for fields, and validation rules for data in each field.

Accepted Answer

A)  data dictionary 
B)  data mine 
C)  data warehouse 
D)  data mart

Question 3

A__________is the structure and organization of data, which involves fields, records, and files.

Accepted Answer

A)  data hierarchy 
B)  data mart 
C)  data warehouse 
D)  data mine 
E)  Select

Question 4

In large organizations, database design and management is handled by a__________.

Accepted Answer

A)  database administrator 
B)  database evaluator 
C)  database synchronizer 
D)  database developer 
E)  Select

Question 5

A _____ is usually a smaller version of a data warehouse, used by a single department or function.

Accepted Answer

A)  data domain 
B)  data mine 
C)  data dictionary 
D)  data mart

Question 6

In a relational database model, the rows are called _____.

Accepted Answer

A)  tuples 
B)  attributes 
C)  branches 
D)  roots

Question 7

In object-oriented databases, grouping objects along with their attributes and methods into a class is called__________.

Accepted Answer

A)  encapsulation 
B)  fragmentation 
C)  allocation 
D)  optimization 
E)  Select

Question 8

Consolidating information from different departments or functional areas is easier in data marts than in data warehouses.

Accepted Answer

A) True 
 B)False

Question 9

A__________is software for creating, storing, maintaining, and accessing database files.

Accepted Answer

A)  database management system 
B)  data hierarchical system 
C)  database modelling tool 
D)  data warehousing tool 
E)  Select

Question 10

In data warehouses, _____ is information about data-its content, quality, condition, origin, and other characteristics.

Accepted Answer

A)  metadata 
B)  big data 
C)  summary data 
D)  raw data

Question 11

Which of the following types of databases is not limited by the data's physical location?

Accepted Answer

A)  A distributed database 
B)  A relational database 
C)  A multi-structured database 
D)  A semi-structured database

Question 12

Database marketing works by using multivariate analysis, data segmentation, and automated tools to transform marketing from a proactive to a reactive process.

Accepted Answer

A) True 
 B)False

Question 13

In a relational database model, a _____ is a field in a relational table that matches the primary key column of another table.

Accepted Answer

A)  secondary key 
B)  foreign key 
C)  serial key 
D)  domain key

Question 14

_____ is a component of a data model that defines the boundaries of a database, such as maximum and minimum values allowed for a field, constraints, and access methods.

Accepted Answer

A)  Data structure 
B)  Schema diagrams 
C)  Integrity rules 
D)  File procedure

Question 15

In a(n)__________, records can be accessed in any order, regardless of their physical locations in storage media.

Accepted Answer

A)  sequential access file structure 
B)  random access file structure 
C)  indexed access file structure 
D)  direct access file structure 
E)  Select

Question 16

Business analytics uses _____ to gain insight into data and provide decision makers with information they can act on.

Accepted Answer

A)  predictive modeling 
B)  dashboards 
C)  query reports 
D)  application generators

Question 17

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

Accepted Answer

A) True 
 B)False

Question 18

In a(n) _____, each record can have multiple parent and child records.

Accepted Answer

A)  network model 
B)  hierarchical model 
C)  object-oriented model 
D)  relational model

Question 19

Which of the following statements is true of database marketing?

Accepted Answer

A)  It works by using univariate analysis to transform marketing from a proactive to a reactive process. 
B)  It works by utilizing information that can be found outside the organizational database. 
C)  It makes an organization responsive to the needs of its customers. 
D)  It allows an organization to resist changes in the marketplace.

Question 20

In a relational database model, the columns are called _____.

Accepted Answer

A)  attributes 
B)  tuples 
C)  branches 
D)  roots

Exam 3: Database Systems, Data Warehouses, and Data Marts

Which of the following statements is true of a flat file system?

The _____ stores data types for fields, default values for fields, and validation rules for data in each field.

A__________is the structure and organization of data, which involves fields, records, and files.

In large organizations, database design and management is handled by a__________.

A _____ is usually a smaller version of a data warehouse, used by a single department or function.

In a relational database model, the rows are called _____.

In object-oriented databases, grouping objects along with their attributes and methods into a class is called__________.

Consolidating information from different departments or functional areas is easier in data marts than in data warehouses.

A__________is software for creating, storing, maintaining, and accessing database files.

In data warehouses, _____ is information about data-its content, quality, condition, origin, and other characteristics.

Which of the following types of databases is not limited by the data's physical location?

Database marketing works by using multivariate analysis, data segmentation, and automated tools to transform marketing from a proactive to a reactive process.

In a relational database model, a _____ is a field in a relational table that matches the primary key column of another table.

_____ is a component of a data model that defines the boundaries of a database, such as maximum and minimum values allowed for a field, constraints, and access methods.

In a(n) __________, records can be accessed in any order, regardless of their physical locations in storage media.

Business analytics uses _____ to gain insight into data and provide decision makers with information they can act on.

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

In a(n) _____, each record can have multiple parent and child records.

Which of the following statements is true of database marketing?

In a relational database model, the columns are called _____.