Exercise: Managing Multiuser Databases

Questions for: Managing Multiuser Databases

Locks placed by the DBMS are called ________ .
A:
implicit locks
B:
explicit locks
C:
exclusive locks
D:
shared locks
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
What is the overall responsibility of the DBA?
A:
Facilitate the development and use of the database
B:
Create and populate tables
C:
Development, operation, and maintenance of the database and its applications
D:
Both the first and third answers above are correct.
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
A cursor type in which the application sees the data as they were at the time the cursor was opened is called:
A:
forward only.
B:
static.
C:
keyset.
D:
dynamic.
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
The size of a lock is called:
A:
implicit lock.
B:
lock granularity.
C:
exclusive lock.
D:
shared lock.
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Which of the following locks the item from access of any type?
A:
Implicit lock
B:
Explicit lock
C:
Exclusive lock
D:
Shared lock
Answer: C
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz