Question 1

The process of taking a logical data model and transforming it into a physical model that is efficient for the most often used tasks is called:

Accepted Answer

A) referential integrity. 
B) normalization. 
C) denormalization. 
D) data warehousing. 
E) online analytic processing. 
A) referential integrity. 
B) normalization. 
C) denormalization. 
D) data warehousing. 
E) online analytic processing.

Question 2

Which word is used interchangeably with the term data item?

Accepted Answer

A) attribute 
B) record 
C) key 
D) tuple 
A) attribute 
B) record 
C) key 
D) tuple

Question 3

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 4

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 5

What is normalization?

Accepted Answer

Normalization is the transform

Question 6

The process of taking the logical data model and transforming it into a physical model that is efficient for the most often needed tasks is called normalization.

Accepted Answer

A) True 
 B)False

Question 7

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 8

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 9

Which is not an effectiveness objective of the database?

Accepted Answer

A) ensuring that data can be shared among users for a variety of applications 
B) ensuring all data required for current and future applications will be readily available 
C) allowing the database to evolve and the needs of the users to grow 
D) allowing users to construct their personal view of the data without concern for the way the data are physically stored 
E) maintaining data that are both accurate and inconsistent 
A) ensuring that data can be shared among users for a variety of applications 
B) ensuring all data required for current and future applications will be readily available 
C) allowing the database to evolve and the needs of the users to grow 
D) allowing users to construct their personal view of the data without concern for the way the data are physically stored 
E) maintaining data that are both accurate and inconsistent

Question 10

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 11

Which type of file contains all the attributes for an entity as well as a primary key and several secondary keys?

Accepted Answer

A) a transaction file 
B) a relational file 
C) a master file 
D) a keyed index file 
A) a transaction file 
B) a relational file 
C) a master file 
D) a keyed index file

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Master files are large and contain all the information about an entity.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

A deletion anomaly occurs when the entire primary key is not known and the database cannot delete a record.

Accepted Answer

A) True 
 B)False

Question 16

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 17

Data mining can identify patterns that a human is unable to detect.

Accepted Answer

A) True 
 B)False

Question 18

Give two examples of primary keys that can be used to identify a person or thing.

Accepted Answer

Students may have a wide range of exampl

Question 19

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 20

Many data items can be packed into a field; the field can be read and converted to a number of data items.

Accepted Answer

A) True 
 B)False

The process of taking a logical data model and transforming it into a physical model that is efficient for the most often used tasks is called:

Which word is used interchangeably with the term data item?

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:

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:

What is normalization?

The process of taking the logical data model and transforming it into a physical model that is efficient for the most often needed tasks is called normalization.

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

Which is not related to conventional files?

Which is not an effectiveness objective of the database?

Which is an advantage of the database approach?

Which type of file contains all the attributes for an entity as well as a primary key and several secondary keys?

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

Master files are large and contain all the information about an entity.

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

A deletion anomaly occurs when the entire primary key is not known and the database cannot delete a record.

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

Data mining can identify patterns that a human is unable to detect.

Give two examples of primary keys that can be used to identify a person or thing.

What type of entity is used to represent repeating groups?

Many data items can be packed into a field; the field can be read and converted to a number of data items.

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

The process of taking a logical data model and transforming it into a physical model that is efficient for the most often used tasks is called:

Which word is used interchangeably with the term data item?

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:

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:

What is normalization?

The process of taking the logical data model and transforming it into a physical model that is efficient for the most often needed tasks is called normalization.

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

Which is not related to conventional files?

Which is not an effectiveness objective of the database?

Which is an advantage of the database approach?

Which type of file contains all the attributes for an entity as well as a primary key and several secondary keys?

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

Master files are large and contain all the information about an entity.

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

A deletion anomaly occurs when the entire primary key is not known and the database cannot delete a record.

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

Data mining can identify patterns that a human is unable to detect.

Give two examples of primary keys that can be used to identify a person or thing.

What type of entity is used to represent repeating groups?

Many data items can be packed into a field; the field can be read and converted to a number of data items.

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