Free 1Z0-182 Web TestEngine Demo

Q23 Multiple choice

Oracle Managed Files is used, and a DBA wants ALTER TABLESPACE sales_q1 ADD DATAFILE to succeed for a smallfile tablespace. Which two actions, either one of which is sufficient, can ensure success? Choose two.

Select all that apply.

A
Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each have at least 50 MB available.
B
Specify a path in the DATAFILE clause with at least 100 MB available.
C
Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 MB available.
D
Add AUTOEXTEND ON with NEXT set to 100 MB.
E
Ensure that only DB_RECOVERY_FILE_DEST specifies a location with at least 100 MB available.

1Z0-182 Web TestEngine demo