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 ...

W hich two are true about multiple table INSERT statements? A. They always use subqueries. B. They can transform a row from a source table into multiple rows in a target table. C. The conditional INSE ...

Question： View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require subqueries? A. Display the total number of products supplied by supplier 102 which have a product s ...

Examine these statements executed in a single Oracle session: CREATE TABLE product (pcode NUMBER(2),pname VARCHAR2(20)); INSERT INTO product VALUES(1,'pen'); INSERT INTO product VALUES (2,'pencil'); I ...

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables. You want to display PROD IDS whose promotion cost is less than the highest cost PROD ID in a pro motion time interval. E ...

Examine the description or the BOOKS_TRANSACTIONS table: Name Null? Type CUST_ID NOT Null N ...