1Z0-054 Exam Dumps | As a DBA configuring a new instance, you want to run a representative workload on the instance and examine

<< Prev Question Next Question >>

Question 60/180

As a DBA configuring a new instance, you want to run a representative workload on the instance and examine the relevant statistics to see whether the cache is underconfigured or overconfigured.Given below is a list of the initialization parameters that would affect the statistics collection and advisories.
1. STATISTICS_LEVEL set to BASIC
2. STATISTICS_LEVEL set to TYPICAL
3. DB_CACHE_ADVICE set to ON
4. TIMED_STATISTICS set to TRUE
Which of the above initialization parameters' values must be set explicitly to get the relevant statistics with minimal impact on the overall database performance?

A. 2 and 3

B. 2, 3, and 4

C. 1, 3, and 4

D. only 2

Question List (180q): Question 1: The columns CUST_CITY, CUST_STATE_PROVINCE, and COUNTRY_ID a...; Question 2: Identify the correct statements about the SYSTEM_MOVING_WIND...; Question 3: Which statement is correct about server-generated alerts?...; Question 4: Examine the output of the following query: SQL> SELECT c....; Question 5: View the Exhibit and examine the result of Automatic SQL Tun...; Question 6: View the Exhibit.Which statement is true about applying the ...; Question 7: View the Exhibit and examine the statistics of a SQL stateme...; Question 8: You work as a DBA for a company and manage an online transac...; Question 9: You are a DBA in ABC Corp. You are working on an online tran...; Question 10: You are working on an online transaction processing (OLTP) s...; Question 11: Identify situations in which collecting statistics at the se...; Question 12: As a DBA, you notice a change in the performance of your dat...; Question 13: A user session executes a query and the plan for the query i...; Question 14: You are managing an online transaction processing (OLTP) app...; Question 15: View the Exhibit exhibit1 to examine the series of SQL comma...; Question 16: You enabled tracing for a session by executing the following...; Question 17: View the Exhibit and examine the content of the V$PGA_TARGET...; Question 18: View the Exhibit and examine the partial output from the que...; Question 19: Examine the initialization parameter values for the instance...; Question 20: You are working as a DBA in ABC Corp. You are working on an ...; Question 21: You observed in your database that the queries formerly exec...; Question 22: View the Exhibit and examine the output for the WRC command-...; Question 23: You query the V$SYSSTAT view and notice a significantly high...; Question 24: You plan to use adaptive thresholds as part of the performan...; Question 25: You want to capture the performance statistics during a syst...; Question 26: You analyze an Automatic Database Diagnostic Monitor (ADDM) ...; Question 27: Identify the type of recommendation that can automatically b...; Question 28: You are working on an online transaction processing (OLTP) s...; Question 29: Your database has the ACCTG service configured for an accoun...; Question 30: Identify two correct statements about the Active Session His...; Question 31: Which two statements are true about the database buffer cach...; Question 32: Examine the SQL statement given below: SQL> EXPLAIN PLAN ...; Question 33: Your database supports many applications running on the midd...; Question 34: What indicates that the rate of writing data blocks to the d...; Question 35: The OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter is set to...; Question 36: Which three statements are true about Statspack usage? (Choo...; Question 37: What is the purpose of running the statspack.snap script dur...; Question 38: After an Automatic Database Diagnostic Monitor (ADDM) run, y...; Question 39: You have the automatic optimizer statistics gathering enable...; Question 40: A batch workload that historically completed in the maintena...; Question 41: You created two services HR and FINANCE on a single instance...; Question 42: You want information in the form of charts for throughput an...; Question 43: View Exhibit1 to examine the description of the CUSTOMERS ta...; Question 44: You are working as a DBA for a DSS system, on which applicat...; Question 45: You upgraded database from the Oracle Database 10g to Oracle...; Question 46: You work as a database administrator to manage an online tra...; Question 47: The OS administrator in your company informed you about the ...; Question 48: After running SQL Performance Analyzer (SPA), you observe a ...; Question 49: You are working on an online transaction processing (OLTP) s...; Question 50: You notice that two wait events, Latch:cache buffer chains a...; Question 51: You are working on a database that was upgraded to Oracle Da...; Question 52: You are a DBA in ABC Corp. You are working on an online tran...; Question 53: You queried V$SYSTEM_EVENT in your online transaction proces...; Question 54: You work for a small manufacturing company as a DBA. The com...; Question 55: There are 500 users of an online transaction processing (OLT...; Question 56: You queried V$SYSTEM_EVENT in your online transaction proces...; Question 57: View the Exhibit and analyze a portion of the Active Session...; Question 58: View the Exhibit and examine the partial output from the fol...; Question 59: You are managing an online transaction processing (OLTP) sys...; Question 60: As a DBA configuring a new instance, you want to run a repre...; Question 61: View the Exhibit.You want to set the threshold for the numbe...; Question 62: You work on an online transaction processing (OLTP) database...; Question 63: Examine the output of the following query: SQL> SELECT c....; Question 64: Which two activities can be identified as common unscalable ...; Question 65: You are hired by ABC Pvt Ltd., and assigned the task of mana...; Question 66: In your organization the Oracle Database 11g installation in...; Question 67: On examining the Automatic Workload Repository (AWR) report,...; Question 68: While diagnosing performance problems for a database, you fi...; Question 69: You plan to collect statistics for an important table in you...; Question 70: You receive a recommendation for a SQL statement through the...; Question 71: Which three factors influence the optimizer's behavior while...; Question 72: View the Exhibit and analyze the output of the query.What do...; Question 73: View the Exhibit that shows your investigation of performanc...; Question 74: While configuring the snapshot data capture for your databas...; Question 75: You are working on an online transaction processing (OLTP) s...; Question 76: Which two symptoms related to the database buffer cache toge...; Question 77: Identify the situation in which you would use the Automatic ...; Question 78: View the Exhibit and analyze the output of a query executed ...; Question 79: The Automatic Workload Repository (AWR) snapshot interval is...; Question 80: You work on an online transaction processing (OLTP) database...; Question 81: View the Exhibit and examine the plans in the SQL plan basel...; Question 82: You work for ABC Pvt Ltd. The company has recently upgraded ...; Question 83: In a database, the values for transactions per second are hi...; Question 84: Your system is upgraded from Oracle Database 10g to Oracle D...; Question 85: You are working on a development database that was upgraded ...; Question 86: You have the automatic optimizer statistics gathering enable...; Question 87: View the Exhibit and examine the Instance Efficiency Percent...; Question 88: You work as a DBA and have the responsibility of managing a ...; Question 89: Which statement is true regarding the setting of the PCTFREE...; Question 90: As part of a proactive tuning activity, you have the Automat...; Question 91: You are working as a DBA in ABC Corp. You are working on onl...; Question 92: You work as a DBA for a company and you have the responsibil...; Question 93: You generate an AWR Compare Periods Report for two consecuti...; Question 94: While reviewing the Top 5 Timed Events section in the Automa...; Question 95: A user in a session executed the following SQL statement to ...; Question 96: Your organization has purchased licenses for the Diagnostic ...; Question 97: You received complaints from users about slow response time ...; Question 98: The SALES table in your database undergoes frequent changes....; Question 99: View the Exhibit and examine the partial output obtained whe...; Question 100: In your organization, there are two key databases. One of th...; Question 101: You observed very low cache-hit ratio in your database as sh...; Question 102: View the Exhibit and examine the content of the V$SGA_RESIZE...; Question 103: View the Exhibit.You decide to select the setting option in ...; Question 104: View the Exhibit and analyze the content of V$BUFFER_POOL_ST...; Question 105: As a DBA, you notice that the response time of your database...; Question 106: In which case is the database buffer cache NOT used?...; Question 107: During a proactive database performance monitoring routine, ...; Question 108: You identified a SQL statement with SQL ID 9g485acn2n30m, wh...; Question 109: The users in your online transaction processing (OLTP) envir...; Question 110: Examine the following block: BEGIN DBMS_WORKLOAD_REPOSITORY....; Question 111: Examine the output of the query given below: SQL> SELECT ...; Question 112: View the Exhibit and note the workload type selected to quic...; Question 113: You work as a DBA for a company and you have the responsibil...; Question 114: You are working on an online transaction processing (OLTP) s...; Question 115: The database application developers are planning to make som...; Question 116: View the Exhibit and examine the Load Profile from the AWR r...; Question 117: You noticed a high number of SQL statements with the same PL...; Question 118: View the Exhibit and examine the content of the V$SGA_RESIZE...; Question 119: Identify the reason why chained or migrated rows in a table ...; Question 120: What type of redundancy would you recommend for the Automati...; Question 121: You are working as a DBA on an online transaction processing...; Question 122: View the Exhibit and examine the query based on the DBA_THRE...; Question 123: You work as a consultant DBA for various clients. A performa...; Question 124: You work in an online transaction processing (OLTP) environm...; Question 125: View the Exhibit and examine the Automatic Database Diagnost...; Question 126: You work in an online transaction processing (OLTP) environm...; Question 127: You observe that suboptimal execution plans for the queries ...; Question 128: You work as a DBA in ABC Corp. You are working on an online ...; Question 129: You are a DBA in ABC Corp. You are working on an online tran...; Question 130: You work as a consultant DBA for various clients. A performa...; Question 131: View the Exhibit and examine a portion of the output obtaine...; Question 132: Examine the initialization parameter values for the instance...; Question 133: View the Exhibit.You decide to quickly configure the adaptiv...; Question 134: View the Exhibit and examine the details of the Top 5 Timed ...; Question 135: You used SQL Tuning Advisor for a long-running SQL statement...; Question 136: A user, SCOTT, complains that his database session, SID 249,...; Question 137: You are managing an online transaction processing (OLTP) sys...; Question 138: View Exhibit1 to examine the description of the CUSTOMERS ta...; Question 139: View the Exhibit and examine portions of two ASH reports gen...; Question 140: You want to review a summary of all the wait events in an in...; Question 141: You work as a DBA and you have the responsibility of managin...; Question 142: You are a DBA in ABC Corp. You are working on a DSS system.....; Question 143: You work as a DBA for a company and as a performance improve...; Question 144: Identify the two direct sources from where SQL plans can be ...; Question 145: Examine the values for the following initialization paramete...; Question 146: You identified poorly performing SQL by analyzing the V$SQL ...; Question 147: View the Exhibit and examine the content of the V$MEMORY_RES...; Question 148: You find that in the Top 5 Timed Events section of the Autom...; Question 149: In which two scenarios would you recommend using RAID level ...; Question 150: Which two inferences are correct about the CPU time and the ...; Question 151: View the Exhibit and examine the content. (Exhibit) ALLOCATE...; Question 152: You used SQL Tuning Advisor for a long-running SQL statement...; Question 153: You work as a DBA for a company and as a performance improve...; Question 154: View Exhibit1 and examine the indexes on the CUSTOMERS table...; Question 155: View the Exhibit and examine the content. ALLOCATED_SPACE an...; Question 156: You have a range-partitioned table in your database. Each pa...; Question 157: View the Exhibit that shows your investigation on degraded p...; Question 158: You are working on an online transaction processing (OLTP) d...; Question 159: You are asked to implement Automatic Memory Management (AMM)...; Question 160: You observed that some of the queries are performing poorly ...; Question 161: Examine the following query and its output: SQL>SELECT na...; Question 162: Your database has the HR and Reporting applications. The HR ...; Question 163: The Service-Level Agreement for the production database incl...; Question 164: You are working on an online transaction processing (OLTP) s...; Question 165: You find that the OS utilization is over 40% in your databas...; Question 166: The users in your online transaction processing (OLTP) envir...; Question 167: Your database has the ACCTG service configured for an accoun...; Question 168: Your company wants to migrate a single instance Oracle 11g R...; Question 169: View the Exhibit and examine the sample Automatic Database D...; Question 170: You are working in an online transaction processing (OLTP) e...; Question 171: You are working for a company that uses huge applications to...; Question 172: The users in your online transaction processing (OLTP) envir...; Question 173: You look at the Top 5 Timed Events section of the Automatic ...; Question 174: You are working on a single node database. The storage for t...; Question 175: Examine the following block that executes a SQL Performance ...; Question 176: Which is the correct description of SQL profiling while usin...; Question 177: Examine the following information from the AWR report: Top 5...; Question 178: You are working on the Database using file system RAID level...; Question 179: You identified poorly performing SQL statements that use bin...; Question 180: View Exhibit1 and examine a portion of Active Session Histor...

Question 60/180

LEAVE A REPLY

Download PDF File