1z0-071 Exam - Question 208

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

Examice · Accepted Answer

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.

zouve · Answer

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

billysunday1 · Answer

ACF, I have tested on Oracle DB and it works

Sathitest071 · Answer

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

Festo · Answer

The correct answer is ACE

tom100men · Answer

ACE is correct

ArslanAltaf · Answer

ACF is correct. E is wrong

1z0-071 Exam - Question 208

Discussion