1Z0-072 무료 덤프문제 온라인 액세스

Which two statements are true about Oracle Data Pump? (Choose two.)

• A.It cannot be used to export data as of a previous SCN.
• B.The DBMS_DATAPUMP package can be used only with Data Pump clients
• C.impdp can change target data file names, schemas, and tablespaces during import.
• D.expdp and impdp are its client components.
• E.impdp always uses conventional path inserts when importing data.

You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE '/u01/app/oracle/sales01.dbf' SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)

• A.The FREELISTS and FREELIST GROUPS parameters are used to manage extent allocation.
• B.It uses the default blocksize used at database creation.
• C.It is read-only by default.
• D.It is a locally managed tablespace.
• E.It is offline by default.
• F.DML operations performed on objects in this tablespace are not logged by default.

The DATA tablespace uses Automatic Segment Space Management.
Examine this query and its output:

A block in EMP is 90% full.
At what percentage of free space will INSERT operations into the block again be possible?

• A.10%
• B.90%
• C.25%
• D.50%
• E.75%

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:

Which two actions are performed? (Choose two.)

• A.The alert log records the execution details.
• B.The online data files are opened.
• C.The control file is read.
• D.The initialization parameter file is read.
• E.The online redo logs are opened.
• F.The Oracle background processes are started.

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

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