Oracle 1z0-062 問題集

質問 1：
Examine this command:
SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;
Which two statements are true? (Choose two.)
A. All DDL statements are logged in to a text file in Automatic Diagnostic Repository (ADR) home
B. Some DDL statements are written to an XML file in the ADR home
C. Some data definition language (DDL) statements are written to the control file
D. Some DDL statements are written to a text file in the ADR home
E. All data definition language (DDL) statements are written to the control file
F. The Alert Log still contains some DDL statements
正解：C,D

質問 2：
Which statement is true about unified auditing?
A. Only the CREATE, ALTER, and DROP statements are audited for all users, including SYS.
B. The unified audit trail, by default, resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace.
C. Unified auditing is enabled only if the AUDIT_TRAIL parameter is set to NONE.
D. The unified audit trail contains audit records only from unified audit policies and AUDIT settings.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Your database is configured in ARCHIVELOG mode, and daily full database backups are taken. RMAN is configured to perform control file autobackups.
Which statement is true about the loss of a duplexed control file?
A. The database instance remains open and the control file can be restored without shutting down the database.
B. The database instance aborts and a control file restore operation does not require media recovery.
C. The database instance aborts, and media recovery is required after restoration of the control file to open the database.
D. The database remains open but transactions are not permitted.
正解：A

質問 4：
In one of your databases, unified auditing is enabled and an SH.SALES table exists.
You can successfully execute these commands:

Which statement is true about SALES_POL?
A. It is enabled for all users having SELECT privilege on SH.SALES.
B. Audit records are always stored in an external audit file.
C. Only successful queries of SH.SALES are written to the audit trail.
D. It is only enabled for SH.
正解：C

質問 5：
Examine the parameters for your database instance:

Which three statements are true about the process of automatic optimization by using cardinality feedback?
(Choose three.)
A. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
B. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.
C. The optimizer can re optimize a query only once using cardinality feedback.
D. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
E. The optimizer enables monitoring for cardinality feedback after the first execution of a query.
正解：A,D,E
解説: (Topexam メンバーにのみ表示されます)