Oracle
1Z0-082 · Question #6
1Z0-082 Question #6: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-082 to reveal the answer and full explanation for question #6. The question stem and answer options stay visible for context.
Question
In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces are smallfile tablespaces. SALES_Q1 is a permanent user-defined tablespace in the SALES database. Examine this command which is about to be issued by a DBA logged in to the SALES database: ALTER TABLESPACE sales_q1 ADD DATAFILE; Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)
Options
- AEnsure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at
- BSpecify a path in the DATAFILE clause of the command specifying a location with at least 100M
- CEnsure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available
- DAdd the AUTOEXTEND ON clause with NEXT set to 100M.
- EEnsure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations
Unlock 1Z0-082 to see the answer
You've previewed enough free 1Z0-082 questions. Unlock 1Z0-082 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.