Oracle 1Z0-050 問題集

質問 1：
Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three.)
A. It detects changes in SQL execution plans.
B. The importance of SQL statements is based on the size of the objects accessed.
C. It shows only the overall impact on workload and not the net SQL impact on workload.
D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
E. It produces results that can be used to create the SQL plan baseline.
正解：A,D,E

質問 2：
View the Exhibit to examine the replay settings for replay parameters.
What is the implication for setting the values for replay parameters? (Choose all that apply.)

A. The COMMIT order in the captured workload is preserved during replay.
B. The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.
C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.
D. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.
E. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.
正解：A,D,E

質問 3：
Which statement describes the effect of table redefinition on the triggers attached to the table?
A. All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table '
B. Only triggers that are affected by the changes to the structure of the table are invalidated and automatically revalidated with the next DML execution on the table.
C. All triggers on the table remain valid.
D. All triggers on the table are invalidated and must be manually recompiled before the next DML execution on the table.
正解：A

質問 4：
View the Exhibit.

Examine the following command that is executed for the TRANSPORT table in the SH schema:
SQL> SELECT DBMS_STATS.CREATE_EXTENDED_STATS(lsh\ 'customers^be1, '(countryjd, cust_state_province)') FROM dual;
Which statement describes the significance of this command?
A. It collects statistics into the pending area in the data dictionary.
B. It creates a histogram to hold skewed information about the data in the columns.
C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT.
D. It creates a virtual hidden column in the CUSTOMERSjDBE table.
正解：D

質問 5：
Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.)
A. The BACKGROUND_DUMP_DEST initialization parameter overrides the DIAGNOSTIC_DEST initialization parameter for the location of the alert log file.
B. If the environmental variable ORACLE_BASE is set, then DIAGNOSTIC_DEST is set to $ORACLE_BASE.
C. A single ADR can support multiple ADR homes for different database instances.
D. The alert files are stored in XML file format in the TRACE directory of each ADR home.
正解：B,C

質問 6：
You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of l/Os. Which statement describes a solution to the above?
A. Modify the profile for the targeted users for which control needs to be imposed.
B. Add directives to the Automatic Database Diagnostic Monitor (ADDM).
C. Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.
D. Set a threshold for the default system-defined moving window baseline.
正解：C

質問 7：
Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)
A. It is created by default with the window size being equal to the AWR retention time.
B. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
C. It does not allow you to change the moving window size,
D. Adaptive threshold functionalities use it by default to compute statistics.
正解：A,D

質問 8：
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)
A. SQL Tuning Set
B. Cursor cache
C. Stored outline
D. Automatic Workload Repository (AWR) snapshots
正解：A,B