Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

51.

In a granularity hierarchy the highest level represents the(a) Entire database(b) Area(c) File(d) RecordThe question was asked in unit test.Enquiry is from Multiple Granularity topic in division Concurrency Control of Database Management

Answer»

The CORRECT ANSWER is (a) ENTIRE database

The EXPLANATION is: This level is the root of the tree.
Discussion
52.

A deadlock exists in the system if and only if the wait-for graph contains a ___________(a) Cycle(b) Direction(c) Bi-direction(d) RotationI have been asked this question in a job interview.The above asked question is from Deadlocks in section Concurrency Control of Database Management

Answer»

Right ANSWER is (a) CYCLE

Best explanation: Each transaction involved in the cycle is said to be DEADLOCKED.
Discussion
53.

Which refers to a property of computer to run several operation simultaneously and possible as computers await response of each other(a) Concurrency(b) Deadlock(c) Backup(d) RecoveryThe question was asked in unit test.This intriguing question originated from Lock-Based Protocols in division Concurrency Control of Database Management

Answer»

Right answer is (a) Concurrency

The best EXPLANATION: Concurrency is a property of SYSTEMS in which SEVERAL computations are EXECUTING simultaneously, and potentially interacting with each other.
Discussion
54.

Which of the following is not true about B+ trees?(a) B+ tree index takes the form of balanced tree(b) Performance of B+ tree degrades as the file grows(c) Look-up in B+ tree is straightforward and efficient(d) Insertion and deletion in B+ tree is complicated but efficientThe question was posed to me in homework.My question comes from Multiversion Schemes in section Concurrency Control of Database Management

Answer» RIGHT ANSWER is (b) Performance of B+ TREE degrades as the file grows

Explanation: The answer is evident.
Discussion