: MCQs and True$/$False

i$.$ Locks that are placed assuming that a conflict will never occur are called $\_\_\_\_\_\_\_\_.$

A$)$ explicit locks

B$)$ implicit locks

C$)$ optimistic locks

D$)$ pessimistic locks

ii$.$ Which of the following is not a database administration responsibility of a DBA?

A$)$ Managing the database structure

B$)$ Writing the applications

C$)$ Managing the DBMS

D$)$ Maintaining the data repository

iii. The situation that occurs when two users are each waiting for a resource that the other person has locked is known as a$($n$)\_\_\_\_\_\_\_\_.$

A$)$ lost update problem

B$)$ deadlock

C$)$ inconsistent read problem

D$)$ checkpoint

iv$.$ The responsibilities of a Data Administrator involve:

A$)$ Creating data policies for the organisation

B$)$ Installation and setup of database and computing resources

C$)$ Keeping database up to date

D$)$ All of the above

iii. Two$-$phased locking is one of the techniques used to achieve serializability. True$/$false

iv$.$ Explicit locks are locks that are placed automatically by the DBMS$.$ True$/$False