A.UPDATE emp80
SET department_id=90
WHERE department_id=80;

B.SELECT *
FROM emp80
WHERE department_id=80;

C.SELECT *
FROM emp80
WHERE department_id=90;

D.DELETE FROM emp80
WHERE department_id=90;

A.Read only views cannot be dropped.

B.Data selected by a view's defining query is deleted from Its underlying tables when the view is dropped.

C.CASCADE constraints must be specified when referential integrity constraints on other objects refer to primary or unique keys In the view to be dropped.

D.The creator of a view to be dropped must have the drop ANY_ VIEW privilege.

E.Views referencing a dropped view become Invalid.

A.A set of one or more sequential queries in which generally the result of the inner query is used as the search value in the outer query.

B.A set of sequential queries, all of which must return values from the same table.

C.A set of sequential queries, all of which must always return a single value.

D.A SELECT statement that can be embedded in a clause of another SELECT statement only.

A.SELECE order _id, order _ date FRON orders
LNTERSECT
SELECT invoice_ id, invoice_ id, order_ date FROM orders

B.SELECT * FROM orders ORDER BY order_ id
UNION
SELECT * FROM invoices;

C.SELECT order_ id, invoice_ data order_ date FROM orders
MINUS
SELECT invoice_ id, invoice_ data FROM invoices ORDER BY invoice_ id;

D.SELECT order_ id, order_ data FROM orders
UNION ALL
SELECT invoice_ id, invoice_ data FROM invoices ORDER BY order_ id;

E.(SELECT * FROM orders
UNION ALL
SELECT* FROM invoices) ORDER BY order _id;

F.SELECT * FROM orders ORDER BY order_ id
INTERSEOT
SELECT * FROM invoices ORDER BY invoice_ id;

G.SELECT * FROM orders
MINUS
SELECT * FROM INVOICES ORDER BY 1

A.DELETE orders
WHERE order_total < 1000;

B.DELETE order_id
FROM orders
WHERE order_total < 1000;

C.DELETE orders o, order_items I
WHERE o.order_id = i.order_id;

D.DELETE
FROM orders
WHERE (SELECT order_id
FROM order_items);