Concurrency in Index Structures MCQ (Multiple Choice Questions) PDF - 42

MCQ 206: The system must deal with the deadlocks that are not prevented by using schemes of

1. Validation
2. Deadlock detection
3. Deadlock recovery
4. Both A and B

MCQ 207: The query for finding the department names of all instructors, is

1. select dept_name about instructor;
2. define dept_name from instructor;
3. select dept_name from instructor;
4. define dept_name about instructor;

MCQ 208: The alternative way of expressing recursion is the usage of clause definition of

1. Like clause
2. As clause
3. with clause
4. without clause

MCQ 209: The process of creation of an E-R design tends to generate

1. 2NF designs
2. 3NF designs
3. 4NF designs
4. 5NF designs

MCQ 210: The processes that execute the queries and sends the result back, is known as

1. Lock manager processes
2. Server processes
3. Log writer process
4. Database writer process