Oracle Database Administration I — Question 68

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

Answer options

• A. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.
• B. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
• C. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
• D. Add the AUTOEXTEND ON clause with NEXT set to 100M.
• E. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

Correct answer: B, C

Explanation

The correct answers are B and C because adding a datafile requires a specified path with sufficient space, and DB_CREATE_FILE_DEST must point to a location with enough space for the new file. Options A and E are not sufficient on their own as they do not guarantee the needed space for the datafile addition. Option D does not address the requirement of having an initial location for the datafile.