Oracle Database SQL 12c 1z0-071 Exam Practice Test 4

Question : 26 of 57

Marks: +1, -0

Examine this description of the PRODUCTS table:

Rows exist in this table with data in all the columns. You put the PRODUCTS table in read-only mode.
Which three commands execute successfully on PRODUCTS? (Choose three.)

DROP TABLE products;
ALTER TABLE products DROP COLUMN expiry_date;
ALTER TABLE products SET UNUSED (expiry_date);
ALTER TABLE products DROP UNUSED COLUMNS;
CREATE INDEX price_idx ON products (price);
TRUNCATE TABLE products;

Validate

Go to Question:

Prev Question

Next Question