Question 1

A ____ key is a field in a relational database table whose value must be unique for each row.

Accepted Answer

A) foreign 
B) primary 
C) secondary 
D) link

Question 2

Redundant data is a big problem because it can become inconsistent.

Accepted Answer

A) True 
 B)False

Question 3

A table is in 2NF if it fulfills these two conditions: it is in 1NF,and it has ____ dependencies.

Accepted Answer

A) no partial 
B) no total 
C) all partial 
D) all total

Question 4

Which normal form is the highest level usually achieved by database designers?

Accepted Answer

A) unnormalized 
B) first normal form 
C) second normal form 
D) third normal form

Question 5

In a data file,fields are also called ____.

Accepted Answer

A) columns 
B) records 
C) rows 
D) entities

Question 6

In a relational database which of the following allows a user to interact with the database?

Accepted Answer

A) database applications 
B) dba 
C) database server process 
D) database server

Question 7

Personal databases are preferred for database applications that retrieve and manipulate small amounts of data from databases containing large numbers of records.

Accepted Answer

A) True 
 B)False

Question 8

In a data file,a(n)____________________ is a collection of related fields that contain related information.

Accepted Answer

The answer of In a data file,a(n)____________________ is a collection...

Question 9

In Oracle,you can use a(n)____ to automatically generate surrogate keys.

Accepted Answer

A) algorithm 
B) generating key 
C) link 
D) sequence

Question 10

As a general rule,database developers should use a personal database only for applications that are not mission critical.What are some of the reasons for this?

Accepted Answer

The answer of As a general rule,database developers should use...

Question 11

Most modern databases are ____ databases.

Accepted Answer

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

Question 12

It is best to use ____________________ values for primary keys rather than text values.

Accepted Answer

The answer of It is best to use ____________________ values...

Question 13

A shorthand method of identifying a table and its contents is to give the name of the table followed by a list of the column names and data types,separated by commas,within a set of square brackets.

Accepted Answer

A) True 
 B)False

Question 14

____ relationships are rare in a relational database;usually you work with ____ relationships.

Accepted Answer

A) One-to-many,one-to-one 
B) One-to-one,one-to-many 
C) One-to-one,many-to-one 
D) Many-to-one,many-to-many

Question 15

Which data type do surrogate keys have?

Accepted Answer

A) numeric 
B) boolean 
C) character 
D) text

Question 16

During the normalization process,it is common to decrease the number of tables in the database design.

Accepted Answer

A) True 
 B)False

Question 17

Oracle can automatically generate surrogate keys.

Accepted Answer

A) True 
 B)False

Question 18

If no candidate keys exist in a table,which of the following is used?

Accepted Answer

A) surrogate key 
B) dummy key 
C) primary key 
D) index key

Question 19

A student can take many different classes in the same term,and each class can be composed of many different students;this is an example of a many-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 20

A ____ key is a unique key that you create by combining two or more columns.

Accepted Answer

A) composite 
B) primary 
C) foreign 
D) secondary

Exam 1: Clientserver Databases and the Oracle10g Relational Database

A ____ key is a field in a relational database table whose value must be unique for each row.

Redundant data is a big problem because it can become inconsistent.

A table is in 2NF if it fulfills these two conditions: it is in 1NF,and it has ____ dependencies.

Which normal form is the highest level usually achieved by database designers?

In a data file,fields are also called ____.

In a relational database which of the following allows a user to interact with the database?

Personal databases are preferred for database applications that retrieve and manipulate small amounts of data from databases containing large numbers of records.

In a data file,a(n)____________________ is a collection of related fields that contain related information.

In Oracle,you can use a(n) ____ to automatically generate surrogate keys.

As a general rule,database developers should use a personal database only for applications that are not mission critical.What are some of the reasons for this?

Most modern databases are ____ databases.

It is best to use ____________________ values for primary keys rather than text values.

A shorthand method of identifying a table and its contents is to give the name of the table followed by a list of the column names and data types,separated by commas,within a set of square brackets.

relationships are rare in a relational database;usually you work with relationships.

Which data type do surrogate keys have?

During the normalization process,it is common to decrease the number of tables in the database design.

Oracle can automatically generate surrogate keys.

If no candidate keys exist in a table,which of the following is used?

A student can take many different classes in the same term,and each class can be composed of many different students;this is an example of a many-to-many relationship.

A ____ key is a unique key that you create by combining two or more columns.