Database Questions and Answers – Multiple Granularity

This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Multiple Granularity”.

1. In a granularity hierarchy the highest level represents the
a) Entire database
b) Area
c) File
d) Record
View Answer

Answer: a
Explanation: This level is the root of the tree.

2. In a database the file is contained in ________
a) Entire database
b) Two area
c) One area
d) more than one area
View Answer

Answer: c
Explanation: This level is below the root of the tree.

3. If a node is locked in an intention mode, explicit locking is done at a lower level of the tree. This is called
a) Intention lock modes
b) Explicit lock
c) Implicit lock
d) Exclusive lock
View Answer

Answer: a
Explanation: There is an intention mode associated with shared mode, and there is one with an exclusive mode.
advertisement
advertisement

4. If a node is locked in __________ explicit locking is being done at a lower level of the tree, but with only shared-mode locks.
a) Intention lock modes
b) Intention-shared-exclusive mode
c) Intention-exclusive (IX) mode
d) Intention-shared (IS) mode
View Answer

Answer: a
Explanation: There is an intention mode associated with shared mode, and there is one with an exclusive mode.

5. If a node is locked in ____________ then explicit locking is being done at a lower level, with exclusive-mode or shared-mode locks.
a) Intention lock modes
b) Intention-shared-exclusive mode
c) Intention-exclusive (IX) mode
d) Intention-shared (IS) mode
View Answer

Answer: c
Explanation: There is an intention mode associated with shared mode, and there is one with an exclusive mode.

6. If a node is locked in ______________ the subtree rooted by that node is locked explicitly in shared mode, and that explicit locking is being done at a lower level with exclusive-mode locks.
a) Intention lock modes
b) shared and intention-exclusive (SIX) mode
c) Intention-exclusive (IX) mode
d) Intention-shared (IS) mode
View Answer

Answer: b
Explanation: There is an intention mode associated with shared mode, and there is one with an exclusive mode.

7. ____________ denotes the largest timestamp of any transaction that executed write(Q) successfully.
a) W-timestamp(Q)
b) R-timestamp(Q)
c) RW-timestamp(Q)
d) WR-timestamp(Q)
View Answer

Answer: a
Explanation: The most common method for doing ordering transaction is to use a timestamp-ordering scheme.
advertisement

8. The _____________ ensures that any conflicting read and write operations are executed in timestamp order.
a) Timestamp-ordering protocol
b) Timestamp protocol
c) W-timestamp
d) R-timestamp
View Answer

Answer: a
Explanation: The most common method for doing ordering transaction is to use a timestamp-ordering scheme.

9. The __________ requires that each transaction Ti executes in two or three different phases in its lifetime, depending on whether it is a read-only or an update transaction.
a) Validation protocol
b) Validation-based protocol
c) Timestamp protocol
d) Timestamp-ordering protocol
View Answer

Answer: a
Explanation: A concurrency-control scheme imposes the overhead of code execution and possible delay of transactions. It may be better to use an alternative scheme that imposes less overhead.
advertisement

10. This validation scheme is called the _________ scheme since transactions execute optimistically, assuming they will be able to finish execution and validate at the end.
a) Validation protocol
b) Validation-based protocol
c) Timestamp protocol
d) Optimistic concurrency-control
View Answer

Answer: a
Explanation: A concurrency-control scheme imposes the overhead of code execution and possible delay of transactions. It may be better to use an alternative scheme that imposes less overhead.

Sanfoundry Global Education & Learning Series – Database Management System.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.