Question 1

Which of the following is not a difference between a data warehouse and a traditional database?

Accepted Answer

A)  Data in a data warehouse are organized around major subjects rather than transactions. 
B)  Data in a data warehouse cover a much longer time frame that transaction data. 
C)  Data in a data warehouse are organized for rapid updating. 
D)  Data in a data warehouse are organized for fast queries. 
E)  Data in a data warehouse usually include data from outside sources. 
A)  Data in a data warehouse are organized around major subjects rather than transactions. 
B)  Data in a data warehouse cover a much longer time frame that transaction data. 
C)  Data in a data warehouse are organized for rapid updating. 
D)  Data in a data warehouse are organized for fast queries. 
E)  Data in a data warehouse usually include data from outside sources. C

Question 2

Each master table should have programs to:

Accepted Answer

A)  add new records. 
B)  update master file records. 
C)  delete master file records. 
D)  read and process records from the master file. 
E)  All of the above. 
A)  add new records. 
B)  update master file records. 
C)  delete master file records. 
D)  read and process records from the master file. 
E)  All of the above. E

Question 3

What type of entity is used to represent repeating groups?

Accepted Answer

A)  fundamental entity 
B)  associative entity 
C)  attributive entity 
D)  iterative entity 
A)  fundamental entity 
B)  associative entity 
C)  attributive entity 
D)  iterative entity C

Question 4

Which order is correct in the retrieval and presentation of data?
I. Select rows from the relation.
II. Derive new attributes.
III. Join two relations together.
IV. Present data.
V. Choose a relation from the database.
VI. Project columns from the relation.
VII. Calculate totals and performance measures.
VIII. Index or sort rows.

Accepted Answer

A)  V - III - II - I - VIII - IV - VI - VII 
B)  V - III - VI - I - II - VIII - VII - IV 
C)  III - V - VI - I - II - VIII - VII - IV 
D)  V - III - II - I - VI - IV - VII - VIII 
E)  III - V - II - I - VI - VII - VIII - IV 
A)  V - III - II - I - VIII - IV - VI - VII 
B)  V - III - VI - I - II - VIII - VII - IV 
C)  III - V - VI - I - II - VIII - VII - IV 
D)  V - III - II - I - VI - IV - VII - VIII 
E)  III - V - II - I - VI - VII - VIII - IV

Question 5

Which file is used when it is necessary to run a program, but no printer is available?

Accepted Answer

A)  a master file 
B)  a table file 
C)  a report file 
D)  a work file 
E)  a transaction file 
A)  a master file 
B)  a table file 
C)  a report file 
D)  a work file 
E)  a transaction file

Question 6

List and describe the four anomalies that may occur when creating database tables.

Accepted Answer

1. Data redundancy occurs when the same

Question 7

Metadata describes the name given and the length assigned each record.

Accepted Answer

A) True 
 B)False

Question 8

Which is an advantage of the database approach?

Accepted Answer

A)  All of the data are stored in one place. 
B)  Data are more vulnerable to catastrophes. 
C)  It comes about when attempting to keep the cost of storing the data to a reasonable amount. 
D)  It allows users their own view of the data. 
A)  All of the data are stored in one place. 
B)  Data are more vulnerable to catastrophes. 
C)  It comes about when attempting to keep the cost of storing the data to a reasonable amount. 
D)  It allows users their own view of the data.

Question 9

A process of applying algorithms for extracting patterns from data stored in data warehouses that are typically not apparent to human decision makers is called:

Accepted Answer

A)  data mining. 
B)  data warehousing. 
C)  data denormalization. 
D)  databasing. 
A)  data mining. 
B)  data warehousing. 
C)  data denormalization. 
D)  databasing.

Question 10

The sharing of the data means that data need to be stored only once.

Accepted Answer

A) True 
 B)False

Question 11

Referential integrity means that all foreign keys in the many table must have a matching record in the parent table.

Accepted Answer

A) True 
 B)False

Question 12

A one-to-many relationship may be implemented using a drop-down list.

Accepted Answer

A) True 
 B)False

Question 13

The symbol used to represent additional attributes of another entity that may not be present on every record of the first entity is called an:

Accepted Answer

A)  associative entity. 
B)  attributive entity. 
C)  entity subtype. 
D)  self-join. 
E)  ordinal entity. 
A)  associative entity. 
B)  attributive entity. 
C)  entity subtype. 
D)  self-join. 
E)  ordinal entity.

Question 14

What is defined as any data item in a record that is used to identify the record?

Accepted Answer

A)  an attribute 
B)  a key 
C)  a primary key 
D)  an entity 
A)  an attribute 
B)  a key 
C)  a primary key 
D)  an entity

Question 15

Within the realm of metadata, there are record definitions and data item definitions.

Accepted Answer

A) True 
 B)False

Question 16

An object identifier (OID) is a unique key for each record in the database, not just in a table.

Accepted Answer

A) True 
 B)False

Question 17

What is normalization?

Accepted Answer

Normalization is the transform

Question 18

Referential integrity governs the nature of records in a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 19

In database literature, the views are referred to as schema.

Accepted Answer

A) True 
 B)False

Question 20

The information that describes data is referred to as :

Accepted Answer

A)  metadata. 
B)  gammadata. 
C)  moredata. 
D)  alphadata. 
A)  metadata. 
B)  gammadata. 
C)  moredata. 
D)  alphadata.

Which of the following is not a difference between a data warehouse and a traditional database?

Each master table should have programs to:

What type of entity is used to represent repeating groups?

Which file is used when it is necessary to run a program, but no printer is available?

List and describe the four anomalies that may occur when creating database tables.

Metadata describes the name given and the length assigned each record.

Which is an advantage of the database approach?

A process of applying algorithms for extracting patterns from data stored in data warehouses that are typically not apparent to human decision makers is called:

The sharing of the data means that data need to be stored only once.

Referential integrity means that all foreign keys in the many table must have a matching record in the parent table.

A one-to-many relationship may be implemented using a drop-down list.

The symbol used to represent additional attributes of another entity that may not be present on every record of the first entity is called an:

What is defined as any data item in a record that is used to identify the record?

Within the realm of metadata, there are record definitions and data item definitions.

An object identifier (OID) is a unique key for each record in the database, not just in a table.

What is normalization?

Referential integrity governs the nature of records in a one-to-many relationship.

In database literature, the views are referred to as schema.

The information that describes data is referred to as :

Systems, Roles, and Development Methodologies

Understanding and Modeling Organizational Systems

Project Management

Information Gathering: Interactive Methods

Information Gathering: Unobtrusive Methods

Agile Modeling, Prototyping, and Scrum

Using Data Flow Diagrams

Analyzing Systems Using Data Dictionaries

Process Specifications and Structured Decisions

Object-Oriented Systems Analysis and Design Using Uml

Designing Effective Output

Designing Effective Input

Human-Computer Interaction and Ux Design

Designing Accurate Data Entry Procedures

Quality Assurance and Implementation

Filters

Exam 13: Designing Databases

Which of the following is not a difference between a data warehouse and a traditional database?

Each master table should have programs to:

What type of entity is used to represent repeating groups?

Which file is used when it is necessary to run a program, but no printer is available?

List and describe the four anomalies that may occur when creating database tables.

Metadata describes the name given and the length assigned each record.

Which is an advantage of the database approach?

A process of applying algorithms for extracting patterns from data stored in data warehouses that are typically not apparent to human decision makers is called:

The sharing of the data means that data need to be stored only once.

Referential integrity means that all foreign keys in the many table must have a matching record in the parent table.

A one-to-many relationship may be implemented using a drop-down list.

The symbol used to represent additional attributes of another entity that may not be present on every record of the first entity is called an:

What is defined as any data item in a record that is used to identify the record?

Within the realm of metadata, there are record definitions and data item definitions.

An object identifier (OID) is a unique key for each record in the database, not just in a table.

What is normalization?

Referential integrity governs the nature of records in a one-to-many relationship.

In database literature, the views are referred to as schema.

The information that describes data is referred to as :

Systems, Roles, and Development Methodologies

Understanding and Modeling Organizational Systems

Project Management

Information Gathering: Interactive Methods

Information Gathering: Unobtrusive Methods

Agile Modeling, Prototyping, and Scrum

Using Data Flow Diagrams

Analyzing Systems Using Data Dictionaries

Process Specifications and Structured Decisions

Object-Oriented Systems Analysis and Design Using Uml

Designing Effective Output

Designing Effective Input

Human-Computer Interaction and Ux Design

Designing Accurate Data Entry Procedures

Quality Assurance and Implementation

Filters