Oracle Exam 1Z0-082 Topic 18 Question 23 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 23
Topic #: 18

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

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

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

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

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

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

Show Suggested Answer

Suggested Answer: B, C

by Alline at May 04, 2022, 10:23 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!