module 8 part #3

Question 2

A table can be deleted from the database by using the _____ TABLE command.

a. DROP
b. DELETE
c. MODIFY
d. ERASE

Answer 2

a. DROP

Question 3

37. The _____ command is used to restore the database to its previous condition.
    a. ROWCOUNT
    b. BACKUP
    c. COMMIT
    d. ROLLBACK

Answer 3

d. ROLLBACK

Question 4

The _____ pseudo-column is used to select the next value from a sequence.

a. CURRVAL
b. NEXTVAL
c. NEXT
d. GET_NEXT

Answer 4

b. NEXTVAL

Question 5

The _____ constraint assigns a value to an attribute when a new row is added to a table.

a. NOT NULL
b. CASCADE
c. UNIQUE
d. DEFAULT

Answer 5

d. DEFAULT

Question 6

When a user issues the DELETE FROM tablename command without specifying a WHERE condition, _____.

a. no rows will be deleted
b. the first row will be deleted
c. the last row will be deleted
d. all rows will be deleted

Answer 6

d. all rows will be deleted

Question 7

A(n) _____ cursor is automatically created in procedural SQL when the SQL statement returns only one value.

a. implicit
b. dynamic
c. explicit
d. static

Answer 7

a. implicit