Oracle
1Z0-071 · Question #334
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…
The correct answer is A. DROP TABLE products; E. CREATE INDEX price_idx ON products (price); F. TRUNCATE TABLE products. See the full explanation below for the reasoning.
Question
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.)
Exhibit
Options
- ADROP TABLE products;
- BALTER TABLE products DROP COLUMN expiry_date;
- CALTER TABLE products SET UNUSED (expiry_date);
- DALTER TABLE products DROP UNUSED COLUMNS;
- ECREATE INDEX price_idx ON products (price);
- FTRUNCATE TABLE products;
How the community answered
(43 responses)- A81% (35)
- B12% (5)
- C2% (1)
- D5% (2)
Community Discussion
No community discussion yet for this question.