chapter 1 quiz #3

Question 1

Which of the following is a function of the DBMS in a database system?

A) Create and transmit queries

B) Control applications

C) Create and process forms

D) Perform backup and recover

E) Process Web page requests

Answer 1

D) Perform backup and recover

Question 2

Which of the following is a function of the database application in a database system?

A) Create and transmit queries

B) Update database data

C) Maintain database structures

D) Create tables

E) Backup and restore data

Answer 2

A) Create and transmit queries

Question 3

Which of the following is not a function of the database application in a database system?

A) Execute application logic

B) Control concurrency

C) Create and process forms

D) Create and transmit queries

E) Create and process reports

Answer 3

B) Control concurrency

Question 4

Microsoft SQL Server is an example of a:

A) database.

B) database management system.

C) data manipulation system.

D) table.

E) list manager.

Answer 4

B) database management system.

Question 5

Referential integrity constraints must be enforced by the application program. (T/F)

Answer 5

FALSE

Question 6

A relational database can be defined as a self-describing collection of related tables. (T/F)

Answer 6

TRUE

Question 7

The purpose of a database is to help people keep track of things. (T/F)

Answer 7

True

Question 8

Which of the following is not true about a relation?

A) A relation is a two-dimensional table.

B) The cells of a relation must hold a single value.

C) A relation may have duplicate column names.

D) A relation may not have duplicate rows.

E) The order of the rows of a relation is insignificant.

Answer 8

C) A relation may have duplicate column names.