1Z1-054 Exam

免费下载 1Z1-054 认证考题Demo

下载 1Z1-054 PDF 认证考试题库
考试引擎下载

选择 pass4side 1Z1-054 题库

1Z1-054 考试是 Oracle 公司的 Oracle Database 11g: Performance Tuning 认证考试官方代号，pass4side 的 1Z1-054 权威考试题库软件是 Oracle 认证厂商的授权产品，pass4side 绝对保证第一次参加 1Z1-054 考试的考生即可顺利通过，否则承诺全额退款！

1、Pass4Side考题大师1Z1-054试题都是考试原题的完美组合，覆盖率95％以上，答案由多位专业资深讲师原版破解得出，正确率100％，只要您使用本站的考试题库参加1Z1-054 考试，我们保证您一次轻松通过考试；

2、售后服务第一！我们相信要想在当今时代取得成功，必须为广大用户提供全套的周到细致的全程优质售后服务，只有客户满意了，我们才能发展。客户至上是我们Pass4Side考题大师的一贯宗旨；

3、Pass4Side实行“一次不过全额退款”承诺。如果您购买我们1Z1-054的考题，只要不是首次通过，凭盖有PROMETRIC或VUE考试中心钢印的考试成绩单，我们将退还您购买1Z1-054考题大师的全部费用，绝对保证您的利益不受到任何的损失；

4、本站1Z1-054题库根据1Z1-054考试的变化动态更新，在厂家考题每次发生变化后，我们承诺2天内更新1Z1-054题库。在您购买我们的产品之后，我们将提供90天的免费更新。确保1Z1-054考题的覆盖率始终都在95％以上；我们提供2种 1Z1-054 考题大师版本供你选择。

5、软件版本1Z1-054 考试题库
优点：具有学习模式，测试模式，线上自动升级
缺点：仅限固定电脑使用，不可打印为文本，只能PC阅读

6、PDF 格式1Z1-054 考试题库(部分最新更新科目已不提供PDF)
优点：不需下载安装软件，方便用户打印和携带，但也带来了可随意制的弊端，因此我们提醒用户不得随意公开或出售本站的1Z1-054题库，一经发现立即取消其升级资格，且不予退款。
缺点：不具备测试模式，通过查看 pass4side.cn网站及查收我们的更新E-MAIL获取更新信息。
　
　
Exam : Oracle 1Z1-054
Title : Oracle Database 11g: Performance Tuning


1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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