Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 208

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.)

CREATE INDEX price_idx ON products (price);

ALTER TABLE products SET UNUSED (expiry_date);

DROP TABLE products;

ALTER TABLE products DROP COLUMN expiry_date;

TRUNCATE TABLE products;

ALTER TABLE products DROP UNUSED COLUMNS;

Correct Answer: A, B, F

In a read-only mode, the following commands will execute successfully on the PRODUCTS table. Creating an index (Option A) is allowed because it does not modify the existing data, it only creates a new index. Setting a column as UNUSED (Option B) is permitted because it marks a column for removal in future DDL operations without immediate physical deletion of the column data, keeping the table read-only. Dropping UNUSED columns (Option F) also does not alter existing data, it just manages columns previously marked UNUSED. Commands like dropping the table (Option C), dropping a specific column (Option D), and truncating the table (Option E) are not allowed in read-only mode because they would modify the table's data or structure in a way that's not supported while read-only.

Discussion

billysunday1Options: ACF

ACF, I have tested on Oracle DB and it works

zouve

wrong img table https://www.examtopics.com/assets/media/exam-media/02818/0024900001.png

ArslanAltafOptions: ACF

ACF is correct. E is wrong

ArslanAltaf

Tested

tom100menOptions: ACE

ACE is correct

FestoOptions: ACE

The correct answer is ACE

Sathitest071

https://www.examtopics.com/discussions/oracle/view/9440-exam-1z0-071-topic-1-question-301-discussion/