You execute the following command to change the status of the SALES tablespace: SQL> ALTER TABLESPACE sales OFFLINE; Which statements describe the effect of the command? (Choose all that apply.)

Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #95. The question stem and answer options stay visible for context.

Managing Database Storage Structures

Question

You execute the following command to change the status of the SALES tablespace:

SQL> ALTER TABLESPACE sales OFFLINE; Which statements describe the effect of the command? (Choose all that apply.)

Options

AThe tablespace would require recovery to go back online.
BA checkpoint is taken on all data files that are associated with the SALES tablespace.
CThe sessions that subsequently try to access the objects in the SALES tablespace receivean error.
DThe new status of the SALES tablespace is recorded in the control file when the database instance

Unlock 1Z0-052 to see the answer

You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Unlock 1Z0-052 - $49.99 / 30 days Sign in

Topics

#tablespace offline#checkpoint#control file#data files

Full 1Z0-052 Practice