Database Management System Mock Test 10

1. ______________ policy allows multiple updates to accumulate on a block before it is output to stable storage, which can reduce the number of output operations greatly for frequently updated blocks.

2. Evaluate the following command:

CREATE TABLE employees (employee_id NUMBER(2) PRIMARY KEY, last_name VARCHAR2(25) NOT
NULL, department_id NUMBER(2), job_id VARCHAR2(8), salary NUMBER(10,2));
You issue the following command to create a view that displays the IDs and last names of the sales staff in the organization:
CREATE OR REPLACE VIEW sales_staff_vu AS SELECT employee_id, last_name job_id FROM employees
WHERE job_id LIKE 'SA_%' WITH CHECK OPTION;

Which statements are true regarding the above view?

3. The magnetic storage chip used to provide non-volatile direct access storage of data and that have no moving parts are known as

4. A transaction commits as soon as its commit log record is written to stable storage at the primary site. This is

5. B-link tree requires a pointer to its __________ sibling.

6. Which of the following belongs to transaction failure

7. Non-volatile storage needs to have a _________ where the loses in future can be recovered.

8. A _______________ configuration can make takeover by the backup site almost instantaneous.

9. If a transaction does not modify the database until it has committed, it is said to use the ___________ technique.

10. If ___________ are not obtained in undo operation it will cause problem in undo-phase.