which three statements are true regarding single row subqueries? A. THEY CAN BE USED in the where clause. B. A SQL STATEMENT MAY HAVE MULTIPLE SINGLE ROW SUBQUERY BLOCKS. C. THEY MUST BE PLACED ON THE ...

Which two statements are true about truncate and delete? A. the result of a delete can be undone by issuing a rollback B. delete can use a where clause to determine which row(s) should be removed. C. ...

Which three statements are true about Structured Query Language (SQL)? A. It guarantees atomicity, consistency, isolation, and durability (ACID) features B. It best supports relational databases C. It ...

Examine the description of the PRODUCTS table: Name Null? Type PROD_ID NOT NULL NUMBER(2) QTY ...

Examine the description of the BOOKS table: Name Null? Type TRANSACTION_ID NOT NULL VARCHAR2(6) ...

Which three are true about the MERGE statement？ A. It can merge rows only from tables. B. It can use views to produce source rows. C. It can combine rows from multiple tables conditionally to insert ...

Which three statements are true about built-in data types? A. A VARCHAR2 blank-pads column values only if the data stored is non-numeric and contains no special characters. B. The default length for a ...

Which three statements are true about inner and outer joins? A. A full outer join returns matched and unmatched rows. B. A full outer join must use Oracle syntax. C. Outer joins can be used when there ...