A.Employee 100will have SALARYset to the same value as the SALARYof employee 200

B.Employees 100 and 200will have the same JOB_ID as before the update command

C.Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100

D.Employee 200will have SALARYset to the same value as the SALARYof employee 100

E.Employees 100will have JOB_ID set to the same value as the JOB_ID of employee 200

F.Employees 100and 200 will have the same SALARYas before the update command

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

B.For large tables TRUNCATE is faster than DELETE.

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

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

A.All indexes on the table remain but they are invalidated.

B.A pending transaction in the session is committed.

C.All data along with the table structure is deleted.

D.All views and synonyms on the table remain but they are invalidated.

E.All data in the table is deleted but the table structure remains.

A.SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING COUNT(*) >10;

B.SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY COUNT(*) >10;

C.SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY prod_id HAVING COUNT(*) >10;

D.SELECT COUNT (prod_id) FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;

E.SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold > 55000;

A.

B.

C.

D.

E.

F.