CCP Database Management & Information Systems 2

Question 1

Which normal form eliminates transitive dependencies in a relational table?

Accepted Answer

Third Normal Form (3NF)

Answer

3NF removes transitive dependencies by ensuring every non-key attribute depends only on the primary key.

Question 2

In a client-server database architecture, where is the DBMS engine typically located?

Accepted Answer

On the server

Answer

In client-server architecture, the DBMS engine runs on the server and processes queries sent by client applications.

Question 3

What does a ROLLBACK statement do in a database transaction?

Accepted Answer

Undoes all changes made since the last COMMIT

Answer

ROLLBACK reverses all data modifications made during the current transaction, restoring the database to its prior state.

Question 4

Which type of JOIN returns only the rows that have matching values in both tables?

Accepted Answer

INNER JOIN

Answer

An INNER JOIN returns only records where there is a match in both joined tables.

Question 5

What is the purpose of an index in a relational database?

Accepted Answer

To speed up data retrieval operations

Answer

Indexes create a separate data structure that allows the DBMS to locate rows faster without scanning the entire table.

(CCP) Certified Computing Professional Practice Test