Question 1

A ____ key is any column that could be used as the primary key.

Accepted Answer

A) surrogate 
B) foreign 
C) possible 
D) candidate

Question 2

In a database,the ______________________________ performs all routine data handling operations.

Accepted Answer

The answer of In a database,the ______________________________ performs all routine...

Question 3

MS Access is an example of a client/server database.

Accepted Answer

A) True 
 B)False

Question 4

In database terminology,a(n)____ is an object about which you want to store data.

Accepted Answer

A) component 
B) record 
C) file 
D) entity

Question 5

In a database,a(n)____________________ is an object about which you want to store data.

Accepted Answer

The answer of In a database,a(n)____________________ is an object about...

Question 6

A foreign key value must exist in the table where it is a primary key.

Accepted Answer

A) True 
 B)False

Question 7

If your database table has a lot of redundant data,how can you fix it?

Accepted Answer

A) delete the redundant data 
B) eliminate the table 
C) split the table into two and use a foreign key 
D) split the table into two and use a composite key

Question 8

What is a disadvantage of using a personal database over a network?

Accepted Answer

A) slow 
B) creates a lot of network traffic 
C) hard to save data 
D) not secure

Question 9

A personal database should only be used for non-mission-critical applications.

Accepted Answer

A) True 
 B)False

Question 10

A table that is in 1NF and does not have a(n)____________________ key must be in 2NF.

Accepted Answer

The answer of A table that is in 1NF and...

Question 11

The Microsoft Access personal database stores all data for a database in a single file with a(n)____ extension.

Accepted Answer

A) doc 
B) xls 
C) mdb 
D) odb

Question 12

Which of the following characterizes unnormalized data?

Accepted Answer

A) does not have a foreign key identified 
B) does not have a primary key identified and/or contains repeating groups 
C) has transitive dependencies 
D) has partial dependencies

Question 13

In a(n)____________________ database,the DBMS server process runs on one workstation,and the database applications run on separate client workstations across the network.

Accepted Answer

The answer of In a(n)____________________ database,the DBMS server process runs...

Question 14

Client/server databases create a lot of network traffic because the entire database is sent between the client and server for every request.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is the utility used for creating and testing queries in Oracle 10g?

Accepted Answer

A) Forms Builder 
B) Reports Builder 
C) SQL*Plus 
D) EnterpriseManager

Question 16

During the design of the actual database tables,the N:M relationship is broken down into a series of two or more 1:M relationships through the use of a linking table in the process of normalization.

Accepted Answer

A) True 
 B)False

Question 17

The name of the utility which handles all client and server communication in Oracle is ____.

Accepted Answer

A) Oracle Server 
B) Oracle Net 
C) Oracle Socket 
D) Oracle Protocol

Question 18

A(n)____ stores all organizational data in a central location.

Accepted Answer

A) database administrator 
B) record 
C) database 
D) index

Question 19

There are two main tasks involved with the design of a database: developing an entity-relationship (ER)model and regulating the database tables.

Accepted Answer

A) True 
 B)False

Question 20

When creating a database and inserting data values,you must specify the data type for each column.What are some data types that are commonly found in databases?

Accepted Answer

The answer of When creating a database and inserting data...

Exam 1: Clientserver Databases and the Oracle10g Relational Database

A ____ key is any column that could be used as the primary key.

In a database,the ______________________________ performs all routine data handling operations.

MS Access is an example of a client/server database.

In database terminology,a(n) ____ is an object about which you want to store data.

In a database,a(n)____________________ is an object about which you want to store data.

A foreign key value must exist in the table where it is a primary key.

If your database table has a lot of redundant data,how can you fix it?

What is a disadvantage of using a personal database over a network?

A personal database should only be used for non-mission-critical applications.

A table that is in 1NF and does not have a(n)____________________ key must be in 2NF.

The Microsoft Access personal database stores all data for a database in a single file with a(n) ____ extension.

Which of the following characterizes unnormalized data?

In a(n)____________________ database,the DBMS server process runs on one workstation,and the database applications run on separate client workstations across the network.

Client/server databases create a lot of network traffic because the entire database is sent between the client and server for every request.

Which of the following is the utility used for creating and testing queries in Oracle 10g?

During the design of the actual database tables,the N:M relationship is broken down into a series of two or more 1:M relationships through the use of a linking table in the process of normalization.

The name of the utility which handles all client and server communication in Oracle is ____.

A(n) ____ stores all organizational data in a central location.

There are two main tasks involved with the design of a database: developing an entity-relationship (ER)model and regulating the database tables.

When creating a database and inserting data values,you must specify the data type for each column.What are some data types that are commonly found in databases?