ITExamDump 에서 제공해드리는 Oracle인증1Z1-054시험덤프자료를 구입하시면 퍼펙트한 구매후 서비스를 약속드립니다. ITExamDump에서 제공해드리는 덤프는 IT업계 유명인사들이 자신들의 노하우와 경험을 토대로 하여 실제 출제되는 시험문제를 연구하여 제작한 최고품질의 덤프자료입니다. Oracle인증1Z1-054시험은ITExamDump 표Oracle인증1Z1-054덤프자료로 시험준비를 하시면 시험패스는 아주 간단하게 할수 있습니다. 구매하기전 PDF버전 무료샘플을 다운받아 공부하세요.
지난 몇년동안 IT산업의 지속적인 발전과 성장을 통해Oracle 인증1Z1-054시험은 IT인증시험중의 이정표로 되어 많은 인기를 누리고 있습니다. IT인증시험을ITExamDump덤프로 준비해야만 하는 이유는ITExamDump덤프는 IT업계전문가들이 실제시험문제를 연구하여 시험문제에 대비하여 예상문제를 제작했다는 점에 있습니다.
시험 번호/코드: 1Z1-054
시험 이름: Oracle (Oracle Database 11g: Performance Tuning)
당신이 구입하기 전에 시도
일년동안 무료 업데이트
100% 환불보장약속
100% 합격율 보장
Q&A: 192 문항
업데이트: 2014-04-28
ITExamDump에서는 시장에서 가장 최신버전이자 적중율이 가장 높은 Oracle인증 1Z1-054덤프를 제공해드립니다. Oracle인증 1Z1-054덤프는 IT업종에 몇십년간 종사한 IT전문가가 실제 시험문제를 연구하여 제작한 고품질 공부자료로서 시험패스율이 장난 아닙니다. 덤프를 구매하여 시험에서 불합격성적표를 받으시면 덤프비용 전액을 환불해드립니다.
IT인증자격증만 소지한다면 일상생활에서 많은 도움이 될것입니다. 하지만 문제는 어떻게 간단하게 시험을 패스할것인가 입니다. ITExamDump는 IT전문가들이 제공한 시험관련 최신 연구자료들을 제공해드립니다.ITExamDump을 선택함으로써 여러분은 성공도 선택한것이라고 볼수 있습니다. ITExamDump의Oracle 인증1Z1-054시험대비 덤프로Oracle 인증1Z1-054시험을 패스하세요.
ITExamDump의Oracle인증 1Z1-054시험대비 덤프는 가격이 착한데 비하면 품질이 너무 좋은 시험전 공부자료입니다. 시험문제적중율이 높아 패스율이 100%에 이르고 있습니다.다른 IT자격증에 관심이 있는 분들은 온라인서비스에 문의하여 덤프유무와 적중율등을 확인할수 있습니다. Oracle인증 1Z1-054덤프로 어려운 시험을 정복하여 IT업계 정상에 오릅시다.
ITExamDump는 유일하게 여러분이 원하는Oracle인증1Z1-054시험관련자료를 해결해드릴 수 잇는 사이트입니다. ITExamDump에서 제공하는 자료로 응시는 문제없습니다, 여러분은 고득점으로 시험을 통과할 것입니다.
네트웨크시대인 지금 인터넷에 검색하면 수많은Oracle인증 1Z1-054시험공부자료가 검색되는데 그중에서도ITExamDump에서 출시한 Oracle인증 1Z1-054덤프가 가장 높은 인지도를 지니고 있습니다. Oracle인증 1Z1-054덤프에는Oracle인증 1Z1-054시험문제의 기출문제와 예상문제가 수록되어있어 덤프에 있는 문제만 잘 공부하시면 시험은 가볍게 패스가능합니다. Oracle인증 1Z1-054시험을 통과하여 자겨증취득하는 꿈에 더욱 가까이 다가가세요.
1Z1-054 덤프무료샘플다운로드하기: http://www.itexamdump.com/1Z1-054.html
NO.1 View the Exhibit and examine a portion of the output obtained from the following query:
SQL> SELECT * FROM v$sys_time_model;
Select three correct interpretations of the time model statistics. (Choose three.)
A. DB time includes the wait time of all the nonidle and idle user sessions.
B. SQL execute elapsed time includes the time spent in performing fetches of query results.
C. DB CPU includes the CPU time spent on database user-level calls and background CPU time.
D. SQL execute elapsed time includes components of the hard parse elapsed time like bind elapsed time.
E. DB time includes the connection management call elapsed time excluding the background process
time.
ANSWER: BDE
Oracle기출문제 1Z1-054 1Z1-054 1Z1-054 1Z1-054 dumps
NO.2 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 OPTIMIZER_INDEX_COST_ADJ initialization parameter has a low value.
B. The DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter has a low value.
C. The statistics for the table and all the indexes associated with the table are not current.
D. The table has less than DB_FILE_MULTIBLOCK_READ_COUNT blocks under the high-water mark.
ANSWER: CD
Oracle 1Z1-054 1Z1-054 1Z1-054자료
NO.3 You observed that some of the queries are performing poorly on the SALES_RECORDS table in your
database.
On further investigation, you find that at the end of each day the contents of the SALES_RECORDS table
are transferred to the SALES table and deleted from the SALES_RECORDS table. The deleted
operations cause the table to be sparsely populated.
You decided to use the ALTER TABLE...SHRINK SPACE COMPACT command to shrink the table.
Why would you choose this method? (Choose all that apply.)
A. because it can be used during peak hours
B. because it avoids unnecessary cursor invalidation
C. because it adjusts the high-water mark (HWM) immediately
D. because you have long-running queries that might span the shrink operation
E. because it does not allow any data manipulation language (DML) operations, thereby making the
shrink
operation faster
ANSWER: ABD
Oracle기출문제 1Z1-054 dumps 1Z1-054 dump 1Z1-054자격증
NO.4 A batch workload that historically completed in the maintenance window between 10:00 PM and
midnight is currently showing poor performance and completing at 2 AM.
To help in the diagnosis of the performance degradation, the senior DBA in your organization asks you to
execute the awrddrpt.sql script to produce a Compare Periods report.
Which two statements are true about the report produced by this script? (Choose two.)
A. It is refreshed automatically based on the moving window baseline.
B. It compares details between any two selected time periods of the same duration.
C. It normalizes the statistics by the amount of time spent on the database for each time period.
D. It compares details between two consecutive time periods of the same or different durations and is
refreshed every 60 minutes.
ANSWER: BC
Oracle자료 1Z1-054 1Z1-054 1Z1-054
NO.5 View Exhibit1 to examine the description of the CUSTOMERS table.
The CUSTOMERS table has been updated heavily today. In a frequently used SQL statement, you notice
that estimated rows and the actual number of rows fetched differ greatly. The COUNTRY_ID column has
an index.
View Exhibit2 and examine the query execution plan.
What would you recommend to improve the optimizer's estimation?
A. setting the STATISTICS_LEVEL parameter to ALL
B. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE
C. creating extended statistics for the CUST_LAST_NAME, CUST_ID, and CUST_TOTAL columns
D. updating the statistics for the CUSTOMERS table by using the
DBMS_STATS.GATHER_TABLE_STATS
procedure
ANSWER: D
Oracle dumps 1Z1-054 1Z1-054 1Z1-054 dump 1Z1-054
NO.6 View the Exhibit exhibit1 to examine the series of SQL commands and parameter settings.
View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline.
The first plan (in red) is created when OPTIMIZER_MODE is set to ALL_ROWS and the second plan (in
blue) is created when OPTIMIZER_MODE is set to FIRST_ROWS.
Which SQL plan baseline would be used if the SQL query in exhibit1 is executed again when the value of
OPTIMIZER_MODE is set to FIRST_ROWS?
A. the second plan, because it is a fixed plan
B. the first plan, because it is an accepted plan
C. the second plan, because it is the latest generated plan in FIRST_ROW mode
D. A new plan, because the second plan in FIRST_ROW mode is not an accepted plan
ANSWER: B
Oracle dumps 1Z1-054최신덤프 1Z1-054 1Z1-054최신덤프
NO.7 You are working on a development database that was upgraded to Oracle Database 11g from Oracle
Database 9i. An ADDM finding in this database says that the shared pool is inadequately sized, as shown
in the Exhibit.
You diagnosed that this is due to different kinds of workloads and this occurs only during peak hours. You
tried to resize this by shrinking the database buffer cache but that caused inadequate buffer cache
problems. The following are the related parameter settings:
SQL> show parameter sga
NAME TYPE VALUE
------------------------------ --------------- -----------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 300M
sga_target big integer 0
SQL> show parameter target
NAME TYPE VALUE
------------------------------ --------------- -----------------
.....
fast_start_mttr_target integer 0
memory_max_target big integer 0
memory_target big integer 0
pga_aggregate_target big integer 100M
sga_target big integer 0
You want to balance the memory between the System Global Area (SGA) components within SGA
without affecting the size of the Program Global Area (PGA).
Which action would solve this problem?
A. Set the SGA_TARGET parameter to 300M.
B. Set the SGA_MAX_SIZE parameter to 400M.
C. Set the MEMORY_TARGET parameter to 100M.
D. Set the MEMORY_MAX_TARGET parameter to 300M.
ANSWER: A
Oracle자격증 1Z1-054인증 1Z1-054덤프 1Z1-054 1Z1-054 1Z1-054 dumps
NO.8 Which three factors influence the optimizer's behavior while choosing an optimization approach and
goal for a SQL statement? (Choose three.)
A.parsing of a SQL statement
B.operating system (OS) statistics
C.object statistics in the data dictionary
D.the OPTIMIZER_MODE initialization parameter
E.optimizer SQL hints for changing the query optimizer goal
ANSWER: CDE
Oracle pdf 1Z1-054 1Z1-054 1Z1-054
NO.9 Identify two correct statements about the Active Session History (ASH) data. (Choose two.)
A.A part of SGA memory is used to store ASH data as rolling buffer.
B.The ASH data can be analyzed between any two small time intervals.
C.All ASH data in memory are flushed to disk by MMON in every 3 seconds.
D.All ASH data in memory are flushed to disk by MMNL process whenever the buffer is full.
ANSWER: AB
Oracle인증 1Z1-054자료 1Z1-054덤프 1Z1-054 pdf
NO.10 You plan to use adaptive thresholds as part of the performance tuning activity. You decide to increase
the window size of the default moving window baseline for all metric observations and comparisons in
your database. The following error occurs when you try to increase the window size through Enterprise
Manager:
Failed to commit: ORA-13541: system moving window baseline size (1296000) greater than retention
(1036800) ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 601 ORA-06512: at line 2
Which action would allow you to perform the preceding task successfully?
A. increasing the flashback retention period
B. increasing the retention period for SQL Management Base
C. increasing the undo retention period for the database instance
D. increasing the Automatic Workload Repository (AWR) retention period
ANSWER: D
Oracle 1Z1-054 1Z1-054인증 1Z1-054
NO.11 You are working on an online transaction processing (OLTP) system. By day most of the application
users perform queries accessing the most recently added or modified rows. The applications have most
of the queries based on multiple tables. But at night, some batch processing is also done.
Which two actions would you recommend to choose a goal for the optimizer based on the needs of your
application? (Choose two.)
A.setting the OPTIMIZER_MODE parameter to ALL_ROWS at the instance level
B.setting the OPTIMIZER_MODE parameter to FIRST_ROWS_n at the instance level
C.asking the developer to add a hint /*ALL_ROWS*/ in the long-running batch processing queries
D.asking the developer to add a hint /*FIRST_ROWS_n*/ in the long-running batch processing queries
ANSWER: BC
Oracle최신덤프 1Z1-054 1Z1-054 1Z1-054 1Z1-054
NO.12 A user in a session executed the following SQL statement to set the optimizer mode:
ALTER SESSION SET OPTIMIZER_MODE = ALL_ROWS
What impact would it have on the goal of the optimizer for that session? (Choose all that apply.)
A. Statement level OPTIMIZER_MODE hints take precedence over the session-level setting.
B. The OPTIMIZER_MODE parameter set at instance level takes precedence over the session-level
value.
C. The optimizer uses a cost-based approach, regardless of the presence of statistics; it optimizes with a
goal of best response time.
D. The optimizer uses a cost-based approach for all SQL statements in the session, regardless of the
presence of statistics; it optimizes with a goal of best throughput.
ANSWER: AD
Oracle 1Z1-054 1Z1-054 dump 1Z1-054덤프
NO.13 You are working on an online transaction processing (OLTP) system. You detected free buffer waits
events for your database instance running in a machine that has multiple CPUs. You increased the
database buffer cache size as the first step. After a few hours of work on the database, further
investigation shows that the same event is being recorded.
What would be your next step to avoid this event in future?
A. Decrease the value of the DBWR_IO_SLAVES parameter.
B. Set the USE_INDIRECT_DATA_BUFFERS parameter to TRUE.
C. Increase the value of the DB_WRITER_PROCESSES parameter.
D. Increase the value of the DB_FILE_MULTIBLOCK_READ_COUNT parameter.
ANSWER: C
Oracle 1Z1-054덤프 1Z1-054 dump 1Z1-054인증 1Z1-054 1Z1-054덤프
NO.14 View Exhibit1 to examine the description of the CUSTOMERS table.
You observed that optimizer selectivity is not accurate when the CUST_STATE_PROVINCE and
COUNTRY_ID columns are used together in the WHERE clause of a query.
View Exhibit2 to examine the query execution plan and the commands executed to gather the statistics.
The optimizer predicts that 20 rows will be processed rather than the 3,341 rows, which is the actual
number of rows returned from the table.
What can you do to make the optimizer detect the actual number of rows?
A. Set the STATISTICS_LEVEL parameter to ALL.
B. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE.
C. Create extended statistics for the CUST_STATE_PROVINCE and COUNTRY_ID columns.
D. Increase the STALE_PERCENT value for the CUSTOMERS table by using the
DBMS_STATS.SET_TABLE_PREFS procedure.
ANSWER: C
Oracle자격증 1Z1-054 1Z1-054시험문제 1Z1-054
NO.15 After running SQL Performance Analyzer (SPA), you observe a few regressed SQL statements in the
SPA output. Identify the two actions that you would suggest for these regressed SQL statements.
(Choose two.)
A.Running SQL Access Advisor
B.Adding them to SQL Plan Baseline
C.Submitting them to SQL Tuning Advisor
D.Running Automatic Database Diagnostic Monitor (ADDM)
ANSWER: BC
Oracle 1Z1-054인증 1Z1-054 dump 1Z1-054
NO.16 The columns CUST_CITY, CUST_STATE_PROVINCE, and COUNTRY_ID are frequently used
together in the WHERE clause of the queries. The CUSTOMERS table is a big table with 20 GB of data.
You notice that the selectivity for these three columns varies from the selectivity that the optimizer
calculates.
What would you recommend to influence the selectivity calculated by the optimizer?
A. creating function-based indexes by concatenating all the columns
B. updating histogram statistics for these columns by using the DBMS_STATS.GATHER_TABLE_STATS
procedure
C. using the DBMS_STATS.CREATE_EXTENDED_STATS function to create a virtual column and create
index on the virtual column
D. using the DBMS_STATS.CREATE_EXTENDED_STATS function to create a virtual column and the
DBMS_STATS.GATHER_TABLE_STATS procedure to collect statistics on the virtual column
ANSWER: D
Oracle최신덤프 1Z1-054 pdf 1Z1-054 1Z1-054 pdf 1Z1-054
NO.17 View Exhibit1 and examine the indexes on the CUSTOMERS table.
The statistics for the CUSTOMERS table have been updated recently by using the following command:
SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS('SH','CUSTOMERS',method_opt=>'FOR ALL
INDEXED COLUMNS SIZE AUTO');
View Exhibit2 to examine a query plan. Even though the index is present on the COUNTRY_ID and
CUST_GENDER columns, the query uses a full table scan. What could be the reason?
A. because the histogram statistics for the COUNTRY_ID column are not updated
B. because the DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter is set to a high value
C. because the optimizer calculates the cost of accessing blocks by using a full table scan to be less as
compared to index scans, even though indexes are available
D. because indexes on CUST_GENDER and COUNTRY_ID columns are of different types, the index on
the CUST_GENDER column is bitmap index, and on COUNTRY_ID columns is btree index.
ANSWER: C
Oracle 1Z1-054 dumps 1Z1-054기출문제
NO.18 You are working on a decision support system (DSS). The index is available on the COUNTRY_ID
column of the CUSTOMERS table.
View the Exhibit and examine the parameter settings and the query execution plan.
Why is the query using a full table scan instead of an index scan?
A. because the histogram statistics for the COUNTRY_ID column are not updated
B. because the index statistics for the index on the COUNTRY_ID column are not current
C. because the DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter is set to a higher value
D. because the optimizer predicts that most of the blocks in the table are accessed. Therefore, it uses a
full table scan, even though indexes are available.
ANSWER: D
Oracle 1Z1-054 pdf 1Z1-054 pdf
NO.19 You work as a DBA for a company and you have the responsibility of managing one of its online
transaction processing (OLTP) systems. The database encountered performance-related problems and
you generated an Automatic Workload Repository (AWR) report to investigate it further.
View the Exhibits and examine the AWR report.
What could be the problem in this database?
A.Java pool is not configured.
B.The CPU in the system is slow.
C.The shared pool size is inadequate.
D.The database buffer cache is inadequate.
E.The OPEN_CURSORS parameter is set to a small value.
ANSWER: C
Oracle기출문제 1Z1-054 dumps 1Z1-054시험문제 1Z1-054 1Z1-054자격증
NO.20 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
You notice that the one of the queries is using a full table scan (view Exhibit1) instead of index unique
scan (view Exhibit2). The index is present on the column that is accessed in the WHERE clause of the
query. The cost for a full table scan is more than that for an index unique scan.
Why would the optimizer choose full table scan over index unique scan? (Choose all that apply.)
A. The OPTIMIZER_INDEX_COST_ADJ initialization parameter is set to a low value.
B. The OPTIMIZER_INDEX_COST_ADJ initialization parameter is set to a high value.
C. The DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter is set to a low value.
D. The statistics for the table and all the indexes associated with the table are not current.
ANSWER: BD
Oracle시험문제 1Z1-054 1Z1-054덤프 1Z1-054덤프 1Z1-054
ITexamdump의 MB6-889덤프의 VCE테스트프로그램과 MSC-331덤프는 한방에 시험을 패스하도록 도와드립니다. ITexamdump 에서는 최신버전의 1Y0-400시험에 대비한 고품질 덤프와 C4040-224시험 최신버전덤프를 제공해드립니다. 최고품질 VCPC510시험자료는 100% 간단하게 시험패스하도록 최선을 다하고 있습니다. IT인증시험패스는 이토록 간단합니다.
