Question 1

Transaction files contain information necessary to produce reports but are not able to update master files.

Accepted Answer

A) True 
 B)False

Question 2

An insert anomaly results when a change to one attribute value either causes the database to contain inconsistent data or causes multiple records to need changing.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

What can be constructed by choosing two or more data items and combining them?

Accepted Answer

A) a primary key 
B) an attribute 
C) a secondary key 
D) an entity 
E) a concatenated key 
A) a primary key 
B) an attribute 
C) a secondary key 
D) an entity 
E) a concatenated key

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

A many-to-many relationship may be implemented using three tables.

Accepted Answer

A) True 
 B)False

Question 7

What is business intelligence?

Accepted Answer

Business intelligence is infor

Question 8

An attribute is some characteristic of a(n)________.

Accepted Answer

A) entity 
B) relationship 
C) reality 
D) record definition 
A) entity 
B) relationship 
C) reality 
D) record definition

Question 9

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 10

A ________ is a central source of data meant to be shared by many users for a variety of applications.

Accepted Answer

A) database 
B) data dictionary 
C) data warehouse 
D) data model 
A) database 
B) data dictionary 
C) data warehouse 
D) data model

Question 11

A data warehouse is used to organize information for quick and effective queries.

Accepted Answer

A) True 
 B)False

Question 12

A well-designed ________ can be more flexible than separate files.

Accepted Answer

A) data dictionary 
B) data warehouse 
C) data model 
D) database 
A) data dictionary 
B) data warehouse 
C) data model 
D) database

Question 13

A ________ represents more than one of the other entity.

Accepted Answer

A) crow's foot 
B) single line 
C) double line 
D) dotted line 
A) crow's foot 
B) single line 
C) double line 
D) dotted line

Question 14

Each master file 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.

Question 15

An update anomaly occurs when the entire primary key is not known and the database cannot insert a new record.

Accepted Answer

A) True 
 B)False

Question 16

Each distinct data entity may be stored on several master database tables.

Accepted Answer

A) True 
 B)False

Question 17

Within the realm of ________, there are entities and attributes.

Accepted Answer

A) reality 
B) metadata 
C) relationships 
D) databases 
A) reality 
B) metadata 
C) relationships 
D) databases

Question 18

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

Accepted Answer

1.Data redundancy occurs when the same d

Question 19

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

Transaction files contain information necessary to produce reports but are not able to update master files.

An insert anomaly results when a change to one attribute value either causes the database to contain inconsistent data or causes multiple records to need changing.

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

What can be constructed by choosing two or more data items and combining them?

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

A many-to-many relationship may be implemented using three tables.

What is business intelligence?

An attribute is some characteristic of a(n)________.

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

A ________ is a central source of data meant to be shared by many users for a variety of applications.

A data warehouse is used to organize information for quick and effective queries.

A well-designed ________ can be more flexible than separate files.

A ________ represents more than one of the other entity.

Each master file should have programs to:

An update anomaly occurs when the entire primary key is not known and the database cannot insert a new record.

Each distinct data entity may be stored on several master database tables.

Within the realm of ________, there are entities and attributes.

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

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

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

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

Designing Accurate Data Entry

Quality Assurance and Implementation

Filters

Exam 13: Designing Databases

Transaction files contain information necessary to produce reports but are not able to update master files.

An insert anomaly results when a change to one attribute value either causes the database to contain inconsistent data or causes multiple records to need changing.

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

What can be constructed by choosing two or more data items and combining them?

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

A many-to-many relationship may be implemented using three tables.

What is business intelligence?

An attribute is some characteristic of a(n)________.

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

A ________ is a central source of data meant to be shared by many users for a variety of applications.

A data warehouse is used to organize information for quick and effective queries.

A well-designed ________ can be more flexible than separate files.

A ________ represents more than one of the other entity.

Each master file should have programs to:

An update anomaly occurs when the entire primary key is not known and the database cannot insert a new record.

Each distinct data entity may be stored on several master database tables.

Within the realm of ________, there are entities and attributes.

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

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

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

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

Designing Accurate Data Entry

Quality Assurance and Implementation

Filters