Consider the database that is organized - Virtual GATE 2017

Consider the database that is organized in terms of database object 'D', and it contains two files (F1 and F2). Each of which contains 1000 pages (P1, ..., P1000) and (P1001, ..., P2000) respectively. Each page contains 100 records. When multiple granularity protocol is used, the operation “Read all (records on all) pages in File 1” causes

(A) Intension shared lock on D and F1
(B) Intension shared lock on F1 and shared lock on D
(C) Intension shared lock on D and shared lock on F1
(D) Shared lock on D and F1

Answer

Discuss

0Comment