A.  display all suppliers whose list price is more than 1000

B.  display all products whose minimum list price is more than the average list price of products having the status 'orderable'

C.  display the total number of products supplied by supplier 102 and have product status as 'OBSOLETE'

D.  display the minimum list price for each product status

E.  display the number of products whose list prices are more than the average list price

A.  MERGE INTO new_prices n
USING (SELECT * FROM products WHERE cost>150) p
ON (n.prod_id=p.prod_id)
WHEN NATCHED THEN
UPDATE SET n.price=p.cost*.01
DELETE WHERE (p.cost<200);

B.  MERGE INTO new_prices n
USING(SELECT*FROM product WHERE cost>150) p
ON (n.prod_id=p.prod_id)
WHEN NATCHED THEN
DELETE WHERE(p.cost<200)
WHEN NOT MATCHED THEN
INSERT (n.prod_id,n.price)VALUES (p.prod_id,p.cost*.01);

C.  MERGE INTO new_prices n
USING(SELECT*FROM products)p
WHEN MATECHED THEN
UPDATE SET n.price=p.cost*.01
WHEN NOT MATCHED THEN
INSERT(n.prod_id,n.price)VALUES (p.prod_id,cost*01)
WHERE(p.cost<200);

D.  MERGE INTO new_prices n
USING products p
WHEN NOT NATCHED THEN
INSERT (n.prod_id, n.price)VALUES (p.prod_id,cost*.01)
WHERE (p.cost <200);

A.  An INSERT INTO...VALUES.. statement can add multiple rows per execution to a table.

B.  An UPDATE... SET... statement can modify multiple rows based on multiple conditions on a table.

C.  A DELETE FROM..... statement can remove rows based on only a single condition on a table.

D.  An INSERT INTO... VALUES..... statement can add a single row based on multiple conditions on a table.

E.  A DELETE FROM..... statement can remove multiple rows based on multiple conditions on a table.

F.  An UPDATE....SET.... statement can modify multiple rows based on only a single condition on a table.

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

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

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

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

A.  when a DBA issues a successful SHUTDOWN TRANSACTIONALstatement and the user then issues a COMMIT

B.  when a CREATE INDEXstatement is executed successfully in the same session

C.  when a COMMITstatement is issued by the same user from another session in the same database instance

D.  when the session logs out successfully

E.  when a DBA issues a successful SHUTDOWN IMMEDIATEstatement and the user then issues a COMMIT

F.  when a CREATE TABLE AS SELECTstatement is executed unsuccessfully in the same session