Question 1

Transaction files:

Accepted Answer

A) are large files, containing all main information about an entity. 
B) are used to update master files and produce reports. 
C) cannot contain several record types. 
D) are always stored using indexed-sequential organization. 
A) are large files, containing all main information about an entity. 
B) are used to update master files and produce reports. 
C) cannot contain several record types. 
D) are always stored using indexed-sequential organization.

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Presentation of the data abstracted from the database must take one of two forms: graphs and tabular forms.

Accepted Answer

A) True 
 B)False

Question 4

Data have a better chance of being available in a conventional file system than in a database.

Accepted Answer

A) True 
 B)False

Question 5

What is a collection of data items that have something in common with the entity?

Accepted Answer

A) a record 
B) an attribute 
C) a data item 
D) an entity 
A) a record 
B) an attribute 
C) a data item 
D) an entity

Question 6

What is the difference between a primary key and a secondary key?

Accepted Answer

A primary key is a key that uniquely ide

Question 7

An update anomaly occurs when the same data are stored in more than one place in the database.

Accepted Answer

A) True 
 B)False

Question 8

Which doesn't DBMS allow?

Accepted Answer

A) creation of database 
B) classification of database 
C) modification of database 
D) updating the database 
E) retrieval of data 
A) creation of database 
B) classification of database 
C) modification of database 
D) updating the database 
E) retrieval of data

Question 9

Text analytics can help organizational decision makers realize valuable insights into what customers are thinking about the organization, the values and actions of the company, as well as customer or vendor motivations for beginning, maintaining, improving, or discontinuing a relationship.

Accepted Answer

A) True 
 B)False

Question 10

An entity subtype is an entity that is used to represent a many-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 11

A primary key is one of the data items in a record that uniquely identifies a record.

Accepted Answer

A) True 
 B)False

Question 12

Secondary keys can be used to select a group of records that belong to a set.

Accepted Answer

A) True 
 B)False

Question 13

A(n)________ represents additional attributes of an entity that may not be present on every record of the entity.

Accepted Answer

A) entity subtype 
B) entity type 
C) primary entity 
D) secondary entity 
A) entity subtype 
B) entity type 
C) primary entity 
D) secondary entity

Question 14

Which of the following is true when implementing a one-to-many relationship?

Accepted Answer

A) The file on the one end has a foreign key consisting of the primary key of the many end. 
B) The file on the one end has a concatenated key of its primary key and the many end key. 
C) The file on the many end has a foreign key consisting of the primary key on the one end. 
D) The file on the many end has a concatenated key of its primary key and the one end key. 
A) The file on the one end has a foreign key consisting of the primary key of the many end. 
B) The file on the one end has a concatenated key of its primary key and the many end key. 
C) The file on the many end has a foreign key consisting of the primary key on the one end. 
D) The file on the many end has a concatenated key of its primary key and the one end key.

Question 15

Table files are used to update master files.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Business intelligence systems are built around the idea of processing small amounts of data.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

Data mining is used to verify or validate patterns that humans are able to make themselves.

Accepted Answer

A) True 
 B)False

Transaction files:

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

Presentation of the data abstracted from the database must take one of two forms: graphs and tabular forms.

Data have a better chance of being available in a conventional file system than in a database.

What is a collection of data items that have something in common with the entity?

What is the difference between a primary key and a secondary key?

An update anomaly occurs when the same data are stored in more than one place in the database.

Which doesn't DBMS allow?

Text analytics can help organizational decision makers realize valuable insights into what customers are thinking about the organization, the values and actions of the company, as well as customer or vendor motivations for beginning, maintaining, improving, or discontinuing a relationship.

An entity subtype is an entity that is used to represent a many-to-many relationship.

A primary key is one of the data items in a record that uniquely identifies a record.

Secondary keys can be used to select a group of records that belong to a set.

A(n)________ represents additional attributes of an entity that may not be present on every record of the entity.

Which of the following is true when implementing a one-to-many relationship?

Table files are used to update master files.

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

Business intelligence systems are built around the idea of processing small amounts of data.

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

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

Data mining is used to verify or validate patterns that humans are able to make themselves.

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:

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

Presentation of the data abstracted from the database must take one of two forms: graphs and tabular forms.

Data have a better chance of being available in a conventional file system than in a database.

What is a collection of data items that have something in common with the entity?

What is the difference between a primary key and a secondary key?

An update anomaly occurs when the same data are stored in more than one place in the database.

Which doesn't DBMS allow?

Text analytics can help organizational decision makers realize valuable insights into what customers are thinking about the organization, the values and actions of the company, as well as customer or vendor motivations for beginning, maintaining, improving, or discontinuing a relationship.

An entity subtype is an entity that is used to represent a many-to-many relationship.

A primary key is one of the data items in a record that uniquely identifies a record.

Secondary keys can be used to select a group of records that belong to a set.

A(n)________ represents additional attributes of an entity that may not be present on every record of the entity.

Which of the following is true when implementing a one-to-many relationship?

Table files are used to update master files.

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

Business intelligence systems are built around the idea of processing small amounts of data.

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

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

Data mining is used to verify or validate patterns that humans are able to make themselves.

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