Oracle
1Z0-052 · Question #251
Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the immediate option. Which statement is correct in this scenario?
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #251. The question stem and answer options stay visible for context.
Performing Backup and Recovery
Question
Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the immediate option. Which statement is correct in this scenario?
Options
- AThe operation would fail if tbs_1 were a read-only tablespace.
- BThe operation would fail if tbs_1 were a read/write tablespace.
- CThe operation would fail if tbs_1 were the default tablespace for the database.
- DIf the above operation were successful, media recovery would be required to bring the tablespace
- EIf the above operation were successful, instance recovery would be required to bring the
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.
Topics
#tablespace offline IMMEDIATE#media recovery#ARCHIVELOG mode#tablespace recovery