Question 1 of 10

1.0 Points

Which is NOT one of the responsibilities of the database administrator?

A. Backup the database

B. Do performance tuning

C. Set up user authentication

D. Determine data confidentiality

Reset Selection Mark for Review What's This?

Question 2 of 10

1.0 Points

One column of a table in a relational database is called a(n) ____.

A. attribute

B. relation

C. tuple

D. element

Reset Selection Mark for Review What's This?

Question 3 of 10

1.0 Points

____ are a critical element of relational database design because they are the bases for representing relationships among tables.

A. Keys

B. Attributes

C. Fields

D. Tables

Reset Selection Mark for Review What's This?

Question 4 of 10

1.0 Points

In a distributed database when the data is divided so that separate columns of the same table are at distinct locations that is referred to as _________.

A. data replication

B. horizontal partitioning

C. vertical partitioning

D. synchronization

Reset Selection Mark for Review What's This?

Question 5 of 10

1.0 Points

Microsoft SQL Server is an example of what?

A. An application server

B. A database management system

C. A programming language compiler

D. A Web server

Reset Selection Mark for Review What's This?

Question 6 of 10

1.0 Points

A relational database table is in ____ normal form if every non-key field is functionally dependent on the primary key.

A. first

B. second

C. third

D. fourth

Reset Selection Mark for Review What's This?

Question 7 of 10

1.0 Points

All ____ in a table are guaranteed to be unique if the table's primary key is guaranteed to be unique.

A. columns

B. foreign keys

C. rows

D. values

Reset Selection Mark for Review What's This?

Question 8 of 10

1.0 Points

A relational database table is in ____ normal form if no non-key field is functionally dependent on any other non-key field.

A. first

B. second

C. third

D. fourth

Reset Selection Mark for Review What's This?

Question 9 of 10

1.0 Points

Referential integrity is normally enforced by the ____.

A. application programmer

B. database management system

C. operating system

D. user

Reset Selection Mark for Review What's This?

Question 10 of 10

1.0 Points

Which of the following is NOT a component or function of a typical database management system (DBMS)?

A. Low-level process management

B. Direct query processor

C. Application program interface processor

D. Administrative interface

Reset Selection Mark for Review What's This?