Q75 In your data center, Oracle Managed Files (OMF) is used for all databases

0 Shares

Lượt xem: 123.511

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

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