Question 1

________ is a process to eliminate repeating groups found in variable-length records.

Accepted Answer

A) Alpha row selection 
B) First row selection 
C) Normalization 
D) Denormalization 
A) Alpha row selection 
B) First row selection 
C) Normalization 
D) Denormalization

Question 2

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

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Which is not related to conventional files?

Accepted Answer

A) Files will remain a practical way to store data for some applications. 
B) A file can be designed and built quite rapidly. 
C) Files are a central source of data meant to be shared by many users for a variety of applications. 
D) The concerns for data availability and security are minimized. 
A) Files will remain a practical way to store data for some applications. 
B) A file can be designed and built quite rapidly. 
C) Files are a central source of data meant to be shared by many users for a variety of applications. 
D) The concerns for data availability and security are minimized.

Question 7

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.

Question 8

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.

Question 9

One of the primary advantages of the relational structure is that ad hoc queries are efficiently handled.

Accepted Answer

A) True 
 B)False

Question 10

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 11

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 12

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 13

When an entity has a relationship connecting it to itself,it is called a(n):

Accepted Answer

A) unitary relationship. 
B) inverse relationship. 
C) extensible join. 
D) self-join. 
A) unitary relationship. 
B) inverse relationship. 
C) extensible join. 
D) self-join.

Question 14

What is normalization?

Accepted Answer

Normalization is the transform

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Entity integrity constraints are rules that govern the composition of primary keys.

Accepted Answer

A) True 
 B)False

Question 17

The integrity constraint that ensures that every many record in a one-to-many relationship has a matching record in the one file is called:

Accepted Answer

A) entity integrity. 
B) referential integrity. 
C) domain integrity. 
D) ordinal integrity. 
E) cardinal integrity. 
A) entity integrity. 
B) referential integrity. 
C) domain integrity. 
D) ordinal integrity. 
E) cardinal integrity.

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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.

Question 20

________ is the transformation of complex user views and data stores to a set of smaller,stable data structures.

Accepted Answer

A) Categorization 
B) Capitalization 
C) Alphabetization 
D) Normalization 
A) Categorization 
B) Capitalization 
C) Alphabetization 
D) Normalization

________ is a process to eliminate repeating groups found in variable-length records.

What type of entity is used to represent repeating groups?

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

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

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

Which is not related to conventional files?

Each master table should have programs to:

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

One of the primary advantages of the relational structure is that ad hoc queries are efficiently handled.

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

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

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

When an entity has a relationship connecting it to itself,it is called a(n):

What is normalization?

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

Entity integrity constraints are rules that govern the composition of primary keys.

The integrity constraint that ensures that every many record in a one-to-many relationship has a matching record in the one file is called:

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

The information that describes data is referred to as :

________ is the transformation of complex user views and data stores to a set of smaller,stable data structures.

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

________ is a process to eliminate repeating groups found in variable-length records.

What type of entity is used to represent repeating groups?

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

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

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

Which is not related to conventional files?

Each master table should have programs to:

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

One of the primary advantages of the relational structure is that ad hoc queries are efficiently handled.

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

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

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

When an entity has a relationship connecting it to itself,it is called a(n):

What is normalization?

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

Entity integrity constraints are rules that govern the composition of primary keys.

The integrity constraint that ensures that every many record in a one-to-many relationship has a matching record in the one file is called:

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

The information that describes data is referred to as :

________ is the transformation of complex user views and data stores to a set of smaller,stable data structures.

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