Question 1

In set theory,a two-dimensional collection of information is called a relation.

Accepted Answer

A) True 
 B)False

Question 2

A(n)______________________________ depicts the fields comprising a record.

Accepted Answer

The answer of A(n)______________________________ depicts the fields comprising a record....

Question 3

A data model depicts the requirements for data as specified by the:

Accepted Answer

A)  database 
B)  enterprise 
C)  user 
D)  database administrator

Question 4

Of the following options,a database that is in ____ form has the best design.

Accepted Answer

A)  unnormalized 
B)  first normal (1NF) 
C)  second normal (2NF) 
D)  third normal (3NF)

Question 5

A(n)______________________________ allows non-technical users to bypass the programmer and to access the database directly.

Accepted Answer

The answer of A(n)______________________________ allows non-technical users to bypass the...

Question 6

In a hierarchical database model,all record relationships are 3:N.

Accepted Answer

A) True 
 B)False

Question 7

The normalization process involves the application of various rules (called normal forms)that yields relational tables that are free of anomalies.

Accepted Answer

A) True 
 B)False

Question 8

For the following diagram,which item is the entity?

Accepted Answer

A)  Students 
B)  Name 
C)  Address 
D)  Street

Question 9

In a(n)____ database model,records are organized in a pyramid structure.

Accepted Answer

A)  hierarchical 
B)  relational 
C)  network 
D)  object-oriented

Question 10

Maximum cardinality is used to specify the minimum level of participation that one entity can have with another entity.

Accepted Answer

A) True 
 B)False

Question 11

Because it uses alphabetic characters,a(n)______________________________ coding system makes it easier for human beings to remember the codes.

Accepted Answer

The answer of Because it uses alphabetic characters,a(n)______________________________ coding system...

Question 12

In set theory,a two-dimensional collection of information is called a(n)______________________________.

Accepted Answer

The answer of In set theory,a two-dimensional collection of information...

Question 13

Which of the following is not a database model discussed in Chapter 5:

Accepted Answer

A)  Relational 
B)  Hierarchical 
C)  Network 
D)  Physical

Question 14

Data redundancy:

Accepted Answer

A)  occurs when data is stored in multiple locations 
B)  is eliminated by using the applications approach 
C)  reduces labor and storage costs 
D)  improves consistency between applications

Question 15

Assigning numbers to objects in chronological sequence is known as:

Accepted Answer

A)  block coding 
B)  mnemonic coding 
C)  sequential coding 
D)  check digit coding

Question 16

The exploration,aggregation,and analysis of large quantities of varied data from across the organization is known as:

Accepted Answer

A)  data independence 
B)  data mining 
C)  data redundancy 
D)  data warehousing

Question 17

The computer-based system of hardware and software that mimics the human brain's ability to recognize patterns or predict outcomes using less-than-complete information is referred to as:

Accepted Answer

A)  group support systems 
B)  executive information system 
C)  decision support system 
D)  neural networks

Question 18

In a relational database model,data are logically organized into two-dimensional tables.

Accepted Answer

A) True 
 B)False

Question 19

The ____ concentrates on the process being performed with data playing a secondary or supporting role.

Accepted Answer

A)  database management approach 
B)  hierarchical data management approach 
C)  transaction processing approach 
D)  applications approach

Question 20

In a(n)______________________________ database model,data are logically organized into two-dimensional tables.

Accepted Answer

The answer of In a(n)______________________________ database model,data are logically organized...

Exam 5: Database Management Systems

In set theory,a two-dimensional collection of information is called a relation.

A(n)______________________________ depicts the fields comprising a record.

A data model depicts the requirements for data as specified by the:

Of the following options,a database that is in ____ form has the best design.

A(n)______________________________ allows non-technical users to bypass the programmer and to access the database directly.

In a hierarchical database model,all record relationships are 3:N.

The normalization process involves the application of various rules (called normal forms)that yields relational tables that are free of anomalies.

For the following diagram,which item is the entity?

In a(n) ____ database model,records are organized in a pyramid structure.

Maximum cardinality is used to specify the minimum level of participation that one entity can have with another entity.

Because it uses alphabetic characters,a(n)______________________________ coding system makes it easier for human beings to remember the codes.

In set theory,a two-dimensional collection of information is called a(n)______________________________.

Which of the following is not a database model discussed in Chapter 5:

Data redundancy:

Assigning numbers to objects in chronological sequence is known as:

The exploration,aggregation,and analysis of large quantities of varied data from across the organization is known as:

The computer-based system of hardware and software that mimics the human brain's ability to recognize patterns or predict outcomes using less-than-complete information is referred to as:

In a relational database model,data are logically organized into two-dimensional tables.

The ____ concentrates on the process being performed with data playing a secondary or supporting role.

In a(n)______________________________ database model,data are logically organized into two-dimensional tables.