Question 1

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

Accepted Answer

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

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

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 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 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 6

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 7

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 8

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 9

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 10

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 11

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 12

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 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 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

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 17

_____ 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 18

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 19

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

Accepted Answer

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

Question 20

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

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

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

_____ 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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following statements is true of database marketing?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow 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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified