Oracle 1Z0-054 問題集

質問 1：
You are a DBA in ABC Corp. You are working on an online transaction processing (OLTP)
system.The applications running on the database use connection pooling to connect to the
database to perform transactions.
The company wants to upgrade the CPU and the memory for the machine on which the database
is running. To test the realistic workload on the new machine with increased CPU and memory,
you identified the peak workload time for the database and captured the workload on the
production system.
You set up the test machine with the upgraded CPU and memory and installed the database with
the same version as production.
Which three actions would you perform to accomplish the realistic replay of the peak workload on
the test machine? (Choose three.)
A. Resolve all external references such as database links, external tables, and directory objects.
B. Set up as many replay clients as there are actual clients to the production system.
C. Restore the replay database to match the capture database at the start of the workload capture.
D. Preprocess the captured workload for the specified target database version.
E. Set up all the replay clients on the same machine on which the test database is running.
正解：A,C,D

質問 2：
Your database has the ACCTG service configured for an accounting application that runs on a
middle tier. The application has three modules LEDGER, ACCOUNTS, and BILLING. You enabled
tracing at the service level by executing the following command:
SQL> exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE('ACCTG');
Which statement is true?
A. The trace file would not be created because the module name is not specified.
B. A trace file is created for each session that uses the service, regardless of the module and action.
C. A single trace file would be created for all the sessions for the service.
D. Three trace files would be created for the three modules in the application.
正解：B

質問 3：
View the Exhibit and examine the output for the WRC command-line utility that you executed to estimate the number of replay clients.Identify three prerequisites for completing the replay. (Choose three.)

A. The replay database should be in the RESTRICTED mode.
B. The replay options for think_time_scale and connect_time_scale must be set to 100 each.
C. You need to start at least 21 replay clients on six CPUs to start the replay.
D. The user should be able to use the workload replay package and should have the DBA role.
E. The replay directory must have all the replay files that have been preprocessed.
正解：C,D,E

質問 4：
Examine the initialization parameter values for the instance given below: NAME TYPE VALUE
optimizer_capture_sql_plan_baselines boolean FALSE optimizer_dynamic_sampling integer 2 optimizer_features_enable string 11.1.0.6 optimizer_index_caching integer 0 optimizer_index_cost_adj integer 100 optimizer_mode string ALL_ROWS db_file_multiblock_read_count integer 64 The index created on the column used in the WHERE clause of the query. You notice that the query is not using the index. Instead of an index scan, a full table scan is used. View the Exhibit and examine the autotrace output for a query.

What could be the reason for it? (Choose all that apply.)
A. The statistics for the table and all the indexes associated with the table are not current.
B. The table has less than DB_FILE_MULTIBLOCK_READ_COUNT blocks under the high-water mark.
C. The DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter has a low value.
D. The OPTIMIZER_INDEX_COST_ADJ initialization parameter has a low value.
正解：A,B

質問 5：
Examine the output of the following query:
SQL> SELECT c.name,a.addr,a.gets,a.misses,a.sleeps,
2 a.immediate_gets,a.immediate_misses,b.pid
3 FROM v$latch a, v$latchholder b, v$latchname c
4 WHERE a.addr = b.laddr(+) and a.latch# = c.latch#
5 AND c.name LIKE '&latch_name%' ORDER BY a.latch#;
LATCH NAME ADDR GETS MISSES SLEEPS IMMEDIATE_GETS IMMEDIATE_MISSES
shared pool 20016544 8520540 14112 3137 0 0
Which two conclusions can you draw from this? (Choose two.)
A. The shared pool operations to allocate and free memory in it caused the misses.
B. Automatic Memory Management is not enabled because the IMMEDIATE_GETS and IMMEDIATE_MISSES columns have zero in them.
C. The latch was requested in willing-to-wait mode.
D. The latch was requested in no wait mode.
正解：A,C

質問 6：
You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently, whereas other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command at regular intervals: SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH','SALES',GRANULARITY=>'AUTO');You need statistics to be collected more quickly. How do you achieve this?
A. Increase the value of the STALE_PERCENT preference for the partition table.
B. Set the PUBLISH preference to TRUE for the partition table.
C. Set the NO_VALIDATE preference to TRUE for the partition table.
D. Set the INCREMENTAL preference to TRUE for the partition table.
正解：D

質問 7：
You are working for a company that uses huge applications to manage its customer details. During your regular performance checks, you executed the following query: SQL> show parameter shared_pool_reserved_size NAME TYPE VALUE
shared_pool_reserved_size big integer 6920601 SQL> SELECT free_space, used_space, request_misses, request_failures from V$SHARED_POOL_RESERVED; FREE_SPACE USED_SPACE REQUEST_MISSES REQUEST_FAILURES
6469776 555528 0 113
You observed that REQUEST_FAILURES is 113 but not increasing, and also that
REQUEST_MISSES is not increasing.
What would you interpret from this?
A. The reserved pool is large and has free space to satisfy requests. Consider reducing the size of the reserved pool.
B. The reserved pool is very large. Consider reducing the size of the shared pool.
C. The reserved pool is very small and is not finding enough memory to satisfy requests. Increase the size of the shared pool.
D. The reserved pool is very small and is not finding enough memory to satisfy requests. Increase the size of the reserved pool.
正解：A