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

Accepted Answer

Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.

Accepted Answer

Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.

Answer

Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.

Answer

Add the AUTOEXTEND ON clause with NEXT set to 100M.

Answer

Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces are smallfile tablespaces. SALES_Q1 is a permanent…

Take the free 1Z0-082 practice test

Other 1Z0-082 practice questions