Oracle 1Z0-072 問題集

質問 1：
What two are benefits of Data Pump? (Choose two.)
A. It can restart failed export jobs.
B. It represents database metadata information as DDL statements in the dump file.
C. It makes use of client system resources.
D. It can execute in parallel.
E. It can export data into sequential media, such as tapes.
正解：A,D

質問 2：
Which two backup configurations are set by default when you choose Cloud Storage Only as the backup destination? (Choose two.)
A. RMAN incremental backups in a seven-day cycle
B. encryption of backups only for Enterprise Edition databases
C. automatic daily full database backups
D. on-demand backups that need to be scheduled
E. encryption for all backups
F. encryption of backups only for High Performance and Extreme Performance database versions
正解：A,F

質問 3：
In the ORCL database, USER1 has unlimited quota on TBS1 and TBS2.
The USER1.EMP table with primary key EMP_ENO_PK resides in TBS1.
USER1.EMP_IDX residing in TBS2 is an index on U1.EMP.ENAME.
TBS1 is exported from ORCL by using this command:
[oracle@host01 ~]$ expdp system/oracle tablespace=tbs1 directory=exp_dir dumpfile=tbs1.dmp The TESTDB database has a TBS1 tablespace but no TBS2.
The SYSTEM user in TESTDB executes this command:
[oracle@host01 ~]$ impdp system/oracle directory=exp_dir dumpfile=u1.dmp tablespace=tbs1 What is the result and why?
A. It fails because TESTDB does not have TBS2 to create EMP_IDX.
B. It fails because TESTDB has TBS1.
C. It imports only EMP.
D. It imports only EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK.
E. It imports EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK and EMP_IDX.
正解：D

質問 4：
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 creates a dump file for the entire database.
C. It creates a dump file only for objects in the SYSTEM schema.
D. It starts only when four worker processes are available.
E. It creates a master table to store details of the export operation.
正解：B,D

質問 5：
Which three failures do not require intervention for recovery? (Choose three.)
A. statement failure
B. transaction failure
C. user process failure
D. network interface card (NIC) failure
E. media failure
正解：A,B,C

質問 6：
Which two are true about RETENTION GUARANTEE? (Choose two.)
A. It prevents FLASHBACK DATABASE operation failure.
B. It prevents "Snapshot too old" errors.
C. It prevents out-of-space errors.
D. It is a tablespace attribute.
E. It is a static parameter.
正解：A,D

質問 7：
EMP_IDX is an index on the EMP.ENO column.
EMP and EMP_IDX reside in the TBS1 tablespace.
During an INSERT into EMP, you get this error:
ERROR at line 1:
ORA-01654: unable to extend index USERS.EMP_IDX BY 8 in tablespace TBS1 Which two actions would you take to correct the space problem in TBS1 without affecting uncommitted transactions on EMP? (Choose two.)
A. Shrink EMP.
B. Drop and re-create EMP_IDX.
C. Coalesce EMP_IDX.
D. Rebuild EMP_IDX online in a tablespace with sufficient space.
E. Shrink TBS1.
正解：B,C

質問 8：
Which two are true about roles? (Choose two.)
A. The SET ROLE statement can be used once per session.
B. The SET ROLE statement enables as well as disables roles in a session.
C. All privileges and roles granted to a user are enabled by default when the user logs in.
D. A role must be disabled before it can be revoked from a user.
E. The ALTER USER statement must be used to set specific default roles for a user.
正解：B,C

質問 9：
Which three failures require intervention for recovery? (Choose three.)
A. statement failure
B. user process failure
C. network interface card (NIC) failure
D. a user error such as dropping the wrong table
E. media failure
正解：B,D,E