Answer Happy

1) When a call to the db_opencommand returns
successful, which two files are created: pathname.___
and pathname.___?
A) dat, ini
B) dat, idx
C) dll, lib
D) dll, ini
2)What are some advantages of a centralized implementation of
functions within a database system? Check all that apply.
A) Each function can apply the required concurrency
controls.
B) Each function can issue its own I/O function calls.
C) A record is read by the process and passed to the requesting
process using IPC.
D) Customer tuning of its operation may be possible.
E) Customers can assign different priorities to different
processes.
F) The scheduling of I/O operations is possible.
G) he kernel’s disk I/O can determine which waiting process will
obtain the lock next.
H) Easier recovery when restoration of the database is
needed.
I) With the locking routines in place, implementation is faster
because IPC is avoided.
3)A disadvantage of coarse-grain locking is that it does not
limit concurrency within a database process.
A) True
B) False