Oracle 1z0-074 問題集

質問 1：
From which two failure scenarios can a database be restored and recovered with the REPAIR DATABASE command? (Choose two.)
A. loss of all copies of the control file
B. loss of a noncritical data file
C. loss of SPFILE
D. loss of a critical data file such as SYSTEM, SYSAUX or UNDO
E. loss of a redo log member
F. loss of ARCHIVELOGS
正解：A,D

質問 2：
Examine these commands executed in the cdb1 container database:

Which statement is true about the c##USER1 account?
A. It is locked after for consecutive failed login attempts.
B. It is locked if the password is not changed within three weeks.
C. It is locked for 90 minutes after four failed login attempts.
D. It is locked for two days after the password expires.
E. It is not affected by the profile because the user has the SYSDBA privilege.
正解：A

質問 3：
In your CDB, DEPTCDB, local undo is enabled. You successfully execute this command:
FLASHBACK PLUGGABLE DATABASE hrpdb to SCN 424366;
Which action must you perform next?
A. Take a backup of HRPDB
B. Open HRPDB
C. Open DEPTPDB
D. Take a backup of DEPTCDB
E. Open HRPDB with RESETLOGS
F. Open DEPTCDB with RESETLOGS
正解：E

質問 4：
You create a new application container, SALES_APP, with application PDBs, SALES1_PDB, and SALES2_PDB.
You want to install the NEW_APP application in SALES1_PDB and SALES2_PDB by using:

Where should you execute these statements?
A. All the statements should be executed in the application root.
B. BEGIN/END INSTALL statements should be executed in the application root and the SYNC statement in SALES1_PDB and SALES2_PDB.
C. BEGIN/END INSTALL statements should be executed in the CDB root and the SYNC statement in the application root.
D. All the statements should be executed in the application seed.
E. All the statements should be executed in the SALES1_PDB and SALES2_PDB application containers.
正解：A,B

質問 5：
Which two are true about the ADR retention advisor in Oracle Database 12c Release 2? (Choose two.)
A. ESTIMATE (SIZEP_POLICY = 209715200) estimates the value of LONGP_POLICY.
B. ESTIMATE (SHORTP_POLICY = 192) estimates the space requirement based on the SHORTP_POLICY value of 192 minutes.
C. ESTIMATE (SIZEP_POLICY = 209715200) estimates only the long retention policy.
D. ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 8760) provides estimates that users can use to set SIZEP_POLICY.
E. ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 2160) estimates the space requirement based on current ADR diagnostics file space usage.
正解：A,D

質問 6：
The ORCL CDB has a PDB, ORCL_PDB.
Examine these parameters in ORCL:

Examine these parameters in ORCL_PDB:

You switch to ORCL_PDB and plan to execute these commands:

What will be the outcome?
A. SGA_TARGET is set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDThe other values remain unchanged in both ORCL and ORCL_PD
B. SGA_TARGET and SGA_MAX_SIZE are set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDB.SGA_TARGET and SGA_MAX_SIZE are set to (1360-600)M and DB_CACHE_SIZE to
200M in ORCL.
C. Altering the DB_CACHE_SIZE results in an error because it cannot be altered in a PDB.SGA_TARGET size is changed to 600 M.
D. SGA_TARGET is set to 600M.The other values remain unchanged in both ORCL and ORCL_PDB.
E. Altering the DB_CACHE_SIZE results in an error because SGA_TARGET should be altered to 600M first.
正解：A

質問 7：
Which statement is true about policy expressions?
A. A redacted table can have only one policy expression defined on it.
B. A named policy expression is stored in the Data Masking format library.
C. A named policy expression is stored in the Enterprise Manager Database Express repository.
D. A policy expression can be applied to columns in different redacted tables.
E. A named policy expression applied to a column in a redacted table overrides the default expression of its redaction policy.
正解：A