Oracle 1z0-064 問題集

質問 1：
Examine the command:
SQL> ALTER SYSTEM SET TEMP_UNDO_ENABLED = TRUE;
Which two statements are true about setting the parameter value to TRUE?
A. It improves performance because DML and DDL operations performed on temporary tables do not use the database buffer cache and redo log buffer.
B. It reduces the amount of undo stored in the undo tablespace.
C. It reduces the amount of redo generated for DML operations performed on temporary tables.
D. It improves database performance by reducing the overhead on the PGA.
正解：B,D

質問 2：
Examine the initialization parameters set for a database instance:

The database supports an OLTP workload. Applications connect to the instance using shared server connections and perform small, random I/Os. All the data files are on the same disk. You notice free buffer wait events for sessions in the database instance.
To solve the problem, you increase the size of the buffer cache. But after some time, you notice sessions waiting again on free buffer waits.
What will you recommend to alleviate the issue? (Choose the best answer.)
A. Spread the data files over multiple disks, controllers, and I/O buses to ensure that there are no hotspots in the I/O subsystem.
B. Configure dedicated server connections for the applications.
C. Configure the database instance to make asynchronous I/O available to DBWR.
D. Run the I/O calibration tool.
正解：C

質問 3：
Examine this list of possible tasks:
1. Ensure that STATISTICS_LEVEL is set to TYPICAL or ALL.
2. Ensure that TIMED_STATISTICS is set to TRUE.
3. Set MAX_DUMP_FILE_SIZE to UNLIMITED and DIAGNOSTIC_DEST to an appropriate destination.
4. Ensure that SQL_TRACE is set to TRUE.
5. Enable tracing at the database instance level by using the DBMS_MONITOR.DATABASE_TRACE_ENABLE procedure.
6. Enable tracing in the required session by using the DBMS_SESSION.SET_SQL_TRACE procedure.
7. Run TKPROF with the EXPLAIN parameter on the output trace file.
8. Run the trcsess utility on the output trace files, and then run TKPROF on the output of the trcsess utility.
Select the minimum tasks to perform, in the correct order, to generate both a formatted trace file with timing information and an explain plan for each SQL statement for all sessions. (Choose the best answer.)
A. 1, 3, 6, 7
B. 1, 2, 5, 8
C. 2, 4, 5, 8
D. 1, 3, 4, 5, 6, 7
E. 1, 2, 4, 8
正解：C

質問 4：
Which two actions should you take to monitor the throughput generated by the modules of an application? (Choose two.)
A. Use a dedicated server configuration.
B. Create a service.
C. Use the DBMS_APPLICATION_INFO package to define the current module and action so that they appear in V$SESSION.
D. Enable SQL Trace at the session level.
E. Use the Resource Manager.
正解：D,E

質問 5：
As part of an application upgrade, new objects are being added to an application schem a. You want to check the effect of the new schema objects on the performance of the SQL workload generated by the application.
How would you accomplish this?
A. Capture the workload, set the OPTIMIZER_USE_PENDING_STATISTICS to FALSE, and then replay the workload.
B. Capture the workload in an STS and submit to SQL Tuning Advisor as an input to generate recommendations for indexes and SQL profiles.
C. Set the PUBLISH statistic preference to FALSE, gather statistics, capture the workload in a SQL Tuning Set (STS), and submit the STS to SQL Tuning Advisor.
D. Capture the workload in an STS and submit to SQL Access Advisor as an input to generate recommendations for indexes and materialized views.
正解：D

質問 6：
A parallel SQL statement is taking a long time to execute. You want to verify how the server processes are dividing work.
How should you determine this?
A. by using SQL Tuning Advisor
B. by using ASH
C. by using services
D. by using Real-Time ADDM
E. by using Real-Time SQL monitoring
正解：C