Question 5

Which of the following is NOT true?

A column that is used in a SELECT clause should be indexed.

A column that is used in a WHERE clause should be indexed.

A column that is used in a GROUP BY clause should be indexed.

A column that is used in a ORDER BY clause should be indexed.

Question 6

Which of the following are locks that are created automatically by the database?

transaction locks

explicit locks

implicit locks

durable locks

Question 7

A new database administrator is trying to determine the best isolation level to set for the database. Which of the following should be used?

Read Uncommitted

Serializable

Repeatability Read

Read Committed

Question 8

You have just created a new table. What type of index should you use for the primary key column?

covering index

bitmap index

clustered index

function-based index

Question 9

A database administrator (DBA) must make a major change to the database. To accomplish this change the DBA must lock all the resources in the database. What type of lock is required?

A database administrator (DBA) must make a major change to the database. To accomplish this change the DBA must lock all the resources in the database. What type of lock is required?

database level exclusive lock

table level exclusive lock

row level exclusive lock

page level exclusive lock

Question 10

A transaction log will contain all of the following except one. Which one of the following would not be found on a transaction log?

rollback markers

checkpoint records

after images

before images