Test Index

Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

Question : 12

Total: 50

Examine the command:

What does ON DELETE CASCADE imply?

When the BOOKS table is dropped, the BOOK_TRANSACTIONS table is dropped
When the BOOKS table is dropped, the BOOK_TRANSACTIONS table is dropped
When a row in the BOOKS table is deleted, the rows in the BOOK_TRANSACTIONS table whose BOOK_ID matches that of the deleted row in the BOOKS table arealso deleted.
When a value in the BOOKS.BOOK_ID column is deleted, the corresponding value is updated in the BOOKS_TRANSACTIONS.BOOK_ID column.

Go to Question:

Prev Question

Next Question