Database - Managing Multiuser Databases

Exercise : Managing Multiuser Databases - General Questions
16.
Which of the following locks the item from access of any type?
Implicit lock
Explicit lock
Exclusive lock
Shared lock
Answer: Option
Explanation:
No answer description is available. Let's discuss.

17.
The size of a lock is called:
implicit lock.
lock granularity.
exclusive lock.
shared lock.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

18.
A cursor type in which the application sees the data as they were at the time the cursor was opened is called:
forward only.
static.
keyset.
dynamic.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

19.
What is the overall responsibility of the DBA?
Facilitate the development and use of the database
Create and populate tables
Development, operation, and maintenance of the database and its applications
Both the first and third answers above are correct.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

20.
Locks placed by the DBMS are called ________ .
implicit locks
explicit locks
exclusive locks
shared locks
Answer: Option
Explanation:
No answer description is available. Let's discuss.