Database Management System Practice Test 10

1. You executed the following SQL statements in the given order:

CREATE TABLE orders
(order_id NUMBER(3) PRIMARY KEY,
order_date DATE,
customer_idnumber(3));

INSERT INTO orders VALUES (100,'10-mar-2007,,222);

ALTER TABLE orders MODIFY order_date NOT NULL;

UPDATE orders SET customer_id=333;

DELETE FROM order;

The DELETE statement results in the following error:
ERROR at line 1: table or view does not exist
What would be the outcome?

2. Which of the following is used only for data entry and storage, and never for processing?

3. The log is a sequence of _________ recording all the update activities in the database.

4. The ____________ scheme uses a page table containing pointers to all pages; the page table itself and all updated pages are copied to a new location.

5. ________ dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re-create the database.

6. The actions which are played in the order while recording it is called ______________ history.

7. How many techniques are available to control concurrency on B+ trees?

8. Which of the following belongs to transaction failure

9. The _______________ policy, allows a transaction to commit even if it has modified some blocks that have not yet been written back to disk.

10. The __________________ contains a list of pages that have been updated in the database buffer.