Online Access Free 1Z0-072 Practice Test

Which statement is true about an undo tablespace created using the Database Configuration Assistant (DBCA)?

• A.It is used for the FLASHBACK TABLE...TO BEFORE DROP operation.
• B.It can be recovered while the instance is open in READ WRITE mode.
• C.It contains undo only for uncommitted transactions.
• D.It must be a smallfile tablespace.
• E.It is a locally managed tablespace.

orcl.dmp contains a full export of the ORCL database.
This command is executed to load data from orcl.dmp into the TESTDB database:
[oracle@host01 ~] impdp system/oracle \
> SHEMAS=sh,oe \
> REMAP_SCHEMA=sh:hr \
> DUMPFILE=orcl.dmp \
> EXCLUDE=index \
> TABLE_EXISTS_ACTION=replace \
> LOGFILE=impdp.log
Which two are true? (Choose two.)

• A.It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.
• B.It skips all indexes of ORCL:SH and ORCL:OE.
• C.It skips only indexes that exist in both ORCL:SH and TESTDB:HR.
• D.It skips only tables that exist in both ORCL:SH and TESTDB:HR.
• E.It drops and recreates tables that exist in both ORCL:SH and TESTDB:HR.

Which three are true about Oracle Managed Files (OMF)? (Choose three.)

• A.If only DB_CREATE_ONLINE_LOG_DEST_n is specified, only the redo logs and control files are OMF.
• B.If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_RECOVERY_FILE_DEST by default.
• C.If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_CREATE_FILE_DEST by default.
• D.If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.
• E.If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, the data files and temp files are placed in DB_CREATE_ONLINE_LOG_DEST_1 by default.
• F.If only DB_CREATE_FILE_DEST is specified, only the data files and temp files are OMF.

DATADIR1 and DATADIR2 are database directory objects.
Examine this command:
[oracle@host01 ~] expdp system/oracle \
> FULL=y \
> DUMPFILE=datadir1:full%U.dmp, datadir2: full2%U.dmp \
> FILESIZE=2G \
> PARALLEL=4 \
> LOGFILE= datadir1:/expfull.log
> JOB_NAME= expfull
Which two are true about the expdp operation? (Choose two.)

• A.It fails if the total size of the dump file is more than 2 GB.
• B.It starts only when four worker processes are available.
• C.It creates a master table to store details of the export operation.
• D.It creates a dump file for the entire database.
• E.It creates a dump file only for objects in the SYSTEM schema.

Which three types of files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

• A.dump files
• B.bad files
• C.password files
• D.control files
• E.server parameter files (SPFILE)
• F.input files