1) When a call to the db_opencommand returns successful, which two files are created: pathname.___ and pathname.___? A)

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

1) When a call to the db_opencommand returns successful, which two files are created: pathname.___ and pathname.___? A)

Post by answerhappygod »

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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply