A.

B.

C.

D.

E.

A.It would give an error because the USING INDEX is not permitted in the CRETAE TABLE command.

B.It would execute successfully and only ORD_ITM_IDX index would be created.

C.It would give an error because the USING INDEX clause cannot be used on a composite primary.

D.It would execute successfully and two indexes ORD_ITM_IDX and ORD_ITM_ID PK would be created.

A.When the BOOKStable is dropped, all the rows in the BOOK_TRANSACTIONStable are deleted but the table structure is retained.

B.When the BOOKStable is dropped, the BOOK_TRANSACTIONStable is dropped.

C.When a row in the BOOKStable is deleted, the rows in the BOOK_TRANSACTIONStable whose BOOK_IDmatches that of the deleted row in the BOOKStable are also deleted.

D.When a value in the BOOKS.BOOK_IDcolumn is deleted, the corresponding value is updated in the BOOKS_TRANSACTIONS.BOOK_IDcolumn.

A.2 returns the value 20.

B.1 and 4 give different results.

C.2 and 3 give the same result.

D.3 returns an error.

E.1 and 4 give the same result.

A.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 are also deleted.

B.When a value in the BOOKS.BOOK_ID column is deleted, the corresponding value is updated in the books transactions. BOOK_ID column.

C.When the books table is dropped, all the rows in the BOOK_TRANSACTIONS table are deleted but the table structure is retained.

D.When the books table is dropped, the BOOK_TRANSACTIONS table is dropped.