Oracle 1z0-074 問題集

質問 1：
Which three statements are true about the SQL Performance Analyzer? (Choose three.)
A. It recommends the creation of indexes for regressed SQL statements.
B. It generates execution plans for each SQL statement in an STS.
C. It compares and analyzes execution plans for the SQL statements in a SQL Tuning Set (STS).
D. It always executes triggers that are fired recursively in FULLDML mode.
E. It recommends the use of SQL Tuning Advisor for regressed SQL statements.
正解：B,C,E

質問 2：
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

質問 3：
You log in to the ORCL database as SYSTEM and successfully execute these two blocks of code:

The SCOTT user has the SELECT privilege on HR.EMP.
Which statement is true about queries by non-DBA users with the SELECT privilege on HR.EMP?
A. All their queries display blanks for LAST_NAME and zeroes for SALARY.
B. All their queries display blanks for LAST_NAME and the true contents of the SALARY column.
C. Only SCOTT'S queries display the true contents of the SALARY column and blanks for LAST_NAME.
D. Only SCOTT'S queries display the true contents of the SALARY and LAST_NAME columns.
E. Only SCOTT'S queries display zero for SALARY and the true contents of the LAST_NAME column.
正解：A

質問 4：
In which situation can the optimizer choose a hash join?
A. when a non-equijoin is used between a table and a sorted hash cluster
B. when a non-equijoin is used and the join column in at least one of the tables is a primary key
C. when any self-join is done
D. when an equality operator is used
E. when a non-equijoin is used and the join column for both tables is a primary key
正解：D

質問 5：
Which statement is true about Trace File Analyzer (TFA) Collector?
A. It is used to collect diagnostic data only for ORA-600, ORA-7445, and ORA-4031 events.
B. If TFA is installed on any cluster node, it automatically collects diagnostic data on all other cluster nodes.
C. TFA collects diagnostic data only for Oracle 12c Release 2 databases or later versions.
D. In Oracle 12c Release 2, TFA installation can be done only while executing root.sh.
E. It can be used to collect diagnostic data for predefined events, and can be configured to automatically collect data for other events.
正解：D

質問 6：
You notice a large number of latch: cache buffers lru chain and latch: cache buffers chains wait events.
Which four might be reasons for these? (Choose four.)
A. A large number of connected user sessions are idle.
B. Cursors are closed explicitly after each execution.
C. Too many sort operations are being performed.
D. The same small number of blocks are repeatedly accessed by different sessions simultaneously.
E. Blocks are ageing out of the buffer cache frequently.
F. DBWR is not writing the dirty buffers fast enough.
G. The buffer cache is undersized.
正解：C,D,E,F

質問 7：
Examine this parameter:

Examine these commands:

Which three are true after executing these commands? (Choose three.)
A. All statements executed by SH are captured and included in a baseline.
B. Only statements executed by SYS are captured and included in a baseline.
C. Only statements executed by SH containing the "TEST_ONLY" string are excluded from capture.
D. Statements executed by any user containing the "TEST_ONLY" string are excluded from capture.
E. Only repeatable statements executed by SYS and SH are considered for baselines.
F. Statements executed by both SH and SYS may be captured and included in a baseline.
正解：A,D,E