1Z0-054 Exam Questions (December)

[Free] Download New Updated (December) Oracle 1Z0-054 Exam Questions 121-130

By on December 29, 2015
EnsurepassQUESTION 121 You received complaints from users about slow response time in some parts of the application. On investigation, you find that this happens whenever the application runs any query against the PROD_DET   table that contains detailed information about all the products.   You gathered the table statistics and executed the following statements to find more information about this table:   SQL> SELECT chain_cnt, 2 round(chain_cnt/num_rows*100,2) pct_chained, 3 avg_row_len, Read more [...]

Continue Reading

1Z0-054 Exam Questions (December)

[Free] Download New Updated (December) Oracle 1Z0-054 Exam Questions 111-120

By on
EnsurepassQUESTION 111 You work as a consultant DBA for various clients. A performance issue in one of the online transaction processing (OLTP) systems is reported to you and you received the Automatic Workload Repository (AWR) report generated in the database. The main sections of the AWR report are shown in the Exhibits.   View the Exhibit named DBTIME and note % DB Time.     View the Exhibit named TIMEMODEL and note what has contributed to % DB Time.     View the Exhibit Read more [...]

Continue Reading

1Z0-054 Exam Questions (December)

[Free] Download New Updated (December) Oracle 1Z0-054 Exam Questions 101-110

By on
EnsurepassQUESTION 101 You are working in an online transaction processing (OLTP) environment. You received many complaints from users about degraded performance. Your senior DBA asked you to execute the following command to improve the performance:   SQL> ALTER TABLE subscribe_log STORAGE(BUFFER_POOL recycle);   You checked the data in the SUBSCRIBE_LOG table and found that it is a large table having one million rows. Which factor could be a reason for this recommendation?   Read more [...]

Continue Reading

1Z0-054 Exam Questions (December)

[Free] Download New Updated (December) Oracle 1Z0-054 Exam Questions 91-100

By on
EnsurepassQUESTION 91 Your database supports many applications running on the middle tier. Many applications users create jobs for which you want to statistically measure workload as a part of performance management.What would you do to accomplish the task?   A. Assign resource consumer group to jobs while creating the jobs. B. Create services for the applications and create jobs by using the DBMS_JOBS PL/SQL package. C. Query v$SESSION to gather statistics of the individual sessions Read more [...]

Continue Reading

1Z0-054 Exam Questions (December)

[Free] Download New Updated (December) Oracle 1Z0-054 Exam Questions 81-90

By on
EnsurepassQUESTION 81 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 Read more [...]

Continue Reading

1Z0-054 Exam Questions (December)

[Free] Download New Updated (December) Oracle 1Z0-054 Exam Questions 61-70

By on
EnsurepassQUESTION 61 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.   The SALES_RECORDS table has Automatic Segment Space Management (ASSM) and row movement enabled. The table is accessible Read more [...]

Continue Reading

1Z0-054 Exam Questions (December)

[Free] Download New Updated (December) Oracle 1Z0-054 Exam Questions 71-80

By on
EnsurepassQUESTION 71 In your organization, there are two key databases. One of them is used primarily for an online transaction processing (OLTP) application and is directly accessed by the users in a client/server configuration. The application must process an average of 4,000 small transactions per day. The users enter frequent queries on whose results they depend for completing their transactions. One of the SLA requirements is that any query or transaction processing in the OLTP system should Read more [...]

Continue Reading

1Z0-054 Exam Questions (December)

[Free] Download New Updated (December) Oracle 1Z0-054 Exam Questions 51-60

By on
EnsurepassQUESTION 51 You notice that two wait events, Latch:cache buffer chains and Latch:cache buffer LRU chains, appear consistently in the Top 5 Timed Events for your database.Which two options describe what these wait events indicate? (Choose two.)   A. Latch:cache buffer LRU chains - indicates excessive block replacement B. Latch:cache buffer LRU chains - indicates insufficient size of application cursor cache C. Latch:cache buffer chains - indicates inefficient SQL that accesses Read more [...]

Continue Reading

1Z0-054 Exam Questions (December)

[Free] Download New Updated (December) Oracle 1Z0-054 Exam Questions 31-40

By on
EnsurepassQUESTION 31 View the Exhibit and examine the Instance Efficiency Percentages that you got on generating an Automatic Workload Repository (AWR) report for your online transaction processing (OLTP) database.What can you deduce from this part of the AWR report? (Choose all that apply.)     A. A low Library Hit % indicates that cursors are not being reused. B. A low Execute to Parse % indicates that most SQL statements are reusing the existing execution plans. C. A high Read more [...]

Continue Reading

1Z0-054 Exam Questions (December)

[Free] Download New Updated (December) Oracle 1Z0-054 Exam Questions 21-30

By on
EnsurepassQUESTION 21 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? Read more [...]

Continue Reading

1Z0-054 Exam Questions (December)

[Free] Download New Updated (December) Oracle 1Z0-054 Exam Questions 41-50

By on
EnsurepassQUESTION 41 You analyze an Automatic Database Diagnostic Monitor (ADDM) report to identify the component that contributes most to the database time. Which is the correct description of database time?   A. It is the sum of the CPU time of all nonidle sessions. B. It is the sum of wait time and the CPU time of all nonidle sessions. C. It is the time spent in processing the input/output (I/O) request by users. D. It is the difference between the wait time and the CPU time Read more [...]

Continue Reading

1Z0-054 Exam Questions (December)

[Free] Download New Updated (December) Oracle 1Z0-054 Exam Questions 11-20

By on
EnsurepassQUESTION 11 Which three statements are true about Statspack usage? (Choose three.)   A. If both Statspack and AWR are used, they cannot be scheduled to capture snapshots at the same time. B. Time Model data cannot be captured by Statspack unless the STATISTICS_LEVEL parameter is set to ALL. C. Both Statspack and AWR can be used on the same database only if the Database Diagnostics pack is present. D. Statspack can be used to generate a report for a specific instance as Read more [...]

Continue Reading

1Z0-054 Exam Questions (December)

[Free] Download New Updated (December) Oracle 1Z0-054 Exam Questions 1-10

By on
EnsurepassQUESTION 1 After an Automatic Database Diagnostic Monitor (ADDM) run, you receive a recommendation for buffer busy wait issue. View the Exhibit. What is the significance of the Benefit(%) column in the Exhibit?     A. It produces better query plans if the recommendation is implemented. B. It gives the maximum reduction in the number of input/output (I/O) operations. C. It gives the maximum reduction in resource usage if the recommendation is implemented. D. It gives Read more [...]

Continue Reading