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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
Ensurepass HOT EXAM! 100-105 Dumps VCE PDF 200-105 Dumps VCE PDF 300-101 Dumps VCE PDF 300-115 Dumps VCE PDF 300-135 Dumps VCE PDF 300-320 Dumps VCE PDF 400-101 Dumps VCE PDF 640-911 Dumps VCE PDF 640-916 Dumps VCE PDF 70-410 Dumps VCE PDF 70-411 Dumps VCE PDF 70-412 Dumps VCE PDF 70-413 Dumps VCE PDF 70-414 Dumps VCE PDF 70-417 Dumps VCE PDF 70-461 Dumps VCE PDF 70-462 Dumps VCE PDF 70-463 Dumps VCE PDF 70-464 Dumps VCE PDF 70-465 Dumps VCE PDF 70-480 Dumps VCE PDF 70-483 Read more [...]
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 [...]
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 [...]
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 [...]
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 [...]