Question 1

The "integrity rules" component of a data model defines the boundaries of a database,constraints,and access methods.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is true of a flat file system?

Accepted Answer

A) Data redundancy is eliminated or minimized. 
B) Data management is improved. 
C) More sophisticated security measures cannot be used. 
D) A variety of relationships among data can be easily maintained.

Question 3

What type of files might a college database have?

Accepted Answer

The answer of What type of files might a college...

Question 4

The term CRUD stands for copy,revise,undo,and define.

Accepted Answer

A) True 
 B)False

Question 5

What is a random access file structure?

Accepted Answer

The answer of What is a random access file structure?...

Question 6

In a(n)____________________ model,the relationships among records form a treelike structure.

Accepted Answer

The answer of In a(n)____________________ model,the relationships among records form...

Question 7

The ____ approach to setting up a distributed DBMS combines fragmentation and replication.

Accepted Answer

A) optimization 
B) allocation 
C) encapsulation 
D) normalization

Question 8

The data ____ component is used to add,delete,modify,and retrieve records from a database.

Accepted Answer

A) manipulation 
B) application 
C) definition 
D) administration

Question 9

In a(n)____________________ access file structure,records can be accessed in any order,regardless of their physical location in storage media.

Accepted Answer

The answer of In a(n)____________________ access file structure,records can be...

Question 10

What tasks are performed when normalizing a database in the 1NF stage?

Accepted Answer

The answer of What tasks are performed when normalizing a...

Question 11

Which of the following is a source of external data?

Accepted Answer

A) Tax records 
B) Sales records 
C) Transaction records 
D) Personnel records

Question 12

Describe the loading process of ETL.

Accepted Answer

The answer of Describe the loading process of ETL....

Question 13

____________________ is used to facilitate and manage transaction-oriented applications,such as point-of-sale,data entry,and retrieval transaction processing.

Accepted Answer

The answer of ____________________ is used to facilitate and manage...

Question 14

The use of OR operator means that only one of the conditions must be met.

Accepted Answer

A) True 
 B)False

Question 15

The ____ view involves how information appears to users and how it can be organized and retrieved.

Accepted Answer

A) physical 
B) logical 
C) rational 
D) analytical

Question 16

With the indexed sequential access method (ISAM),records cannot be accessed randomly.

Accepted Answer

A) True 
 B)False

Question 17

In a relational database,every record must be uniquely identified by a(n)____________________ key.

Accepted Answer

The answer of In a relational database,every record must be...

Question 18

Any changes to a database's structure,such as adding a field,deleting a field,changing a field's size,or changing the data type stored in a field,are made with the data manipulation component.

Accepted Answer

A) True 
 B)False

Question 19

In a relational model,the rows are called attributes and the columns are called tuples.

Accepted Answer

A) True 
 B)False

Question 20

In the ____ model,each record can have multiple parent and child records.

Accepted Answer

A) network 
B) hierarchical 
C) operations 
D) relational

Exam 3: Database Systems,data Warehouses,and Data Marts

The "integrity rules" component of a data model defines the boundaries of a database,constraints,and access methods.

Which of the following is true of a flat file system?

What type of files might a college database have?

The term CRUD stands for copy,revise,undo,and define.

What is a random access file structure?

In a(n)____________________ model,the relationships among records form a treelike structure.

The ____ approach to setting up a distributed DBMS combines fragmentation and replication.

The data ____ component is used to add,delete,modify,and retrieve records from a database.

In a(n)____________________ access file structure,records can be accessed in any order,regardless of their physical location in storage media.

What tasks are performed when normalizing a database in the 1NF stage?

Which of the following is a source of external data?

Describe the loading process of ETL.

____________________ is used to facilitate and manage transaction-oriented applications,such as point-of-sale,data entry,and retrieval transaction processing.

The use of OR operator means that only one of the conditions must be met.

The ____ view involves how information appears to users and how it can be organized and retrieved.

With the indexed sequential access method (ISAM),records cannot be accessed randomly.

In a relational database,every record must be uniquely identified by a(n)____________________ key.

Any changes to a database's structure,such as adding a field,deleting a field,changing a field's size,or changing the data type stored in a field,are made with the data manipulation component.

In a relational model,the rows are called attributes and the columns are called tuples.

In the ____ model,each record can have multiple parent and child records.