A.You can explicitly provide the join condition with a NATURAL JOIN.

B.You can use the JOIN clause to join only two tables.

C.You can use the USING clause to join tables on more than one column.

D.You can use the ON clause to specify multiple conditions while joining tables.

A.A TIMESTAMPdata type column stores only time values with fractional seconds.

B.The value for a CHARdata type column is blank-padded to the maximum defined column width.

C.Only one LONGcolumn can be used per table.

D.The BLOBdata type column is used to store binary data in an operating system file.

E.The minimum column width that can be specified for a VARCHAR2data type column is one.

A.when a PL/SQL anonymous block is executed

B.when a DELETE statement is executed

C.when a ROLLBACK command is executed

D.when a data definition language (DDL) statement is executed

E.when a TRUNCATE statement is executed after the pending transaction

A.You can never DELETE rows from a table if foreign key constraints will be violated.

B.You can never TRUNCATE a table if foreign key constraints will be violated.

C.For large tables TRUNCATE is faster than DELETE.

D.For tables with multiple indexes and triggers DELETE is faster than TRUNCATE.

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

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

C.When a row in the BOOKStable is deleted, the rows in the BOOK_TRANSACTIONStable whose BOOK_ID matches 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.