Oracle 1Z0-054 Online Practice Questions and Exam Preparation

Oracle 1Z0-054 Online Questions & Answers

• Question 121:

  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 many blocks repeatedly
  D. Latch:cache buffer chains - indicates that there are several sessions waiting for a buffer that is presently being read into the buffer cache by another session
  A. Latch:cache buffer LRU chains - indicates excessive block replacement
  C. Latch:cache buffer chains - indicates inefficient SQL that accesses many blocks repeatedly

• Question 122:

  Examine the output of the following query:

  SQL> SELECT c.name,a.addr,a.gets,a.misses,a.sleeps,

  2 a.immediate_gets,a.immediate_misses,b.pid

  3 FROM v$latch a, v$latchholder b, v$latchname c

  4 WHERE a.addr = b.laddr(+) and a.latch# = c.latch#

  5 AND c.name LIKE 'andlatch_name%' ORDER BY a.latch#;

  LATCH NAME ADDR GETS MISSES SLEEPS IMMEDIATE_GETS IMMEDIATE_MISSES ------------ -------- -------- ------- ------ -------------- ---------------- shared pool

  20016544 8520540 14112 3137 0 0

  Which two conclusions can you draw from this? (Choose two.)

  A. The latch was requested in no wait mode.
  B. The latch was requested in willing-to-wait mode.
  C. The shared pool operations to allocate and free memory in it caused the misses.
  D. Automatic Memory Management is not enabled because the IMMEDIATE_GETS and IMMEDIATE_MISSES columns have zero in them.
  B. The latch was requested in willing-to-wait mode.
  C. The shared pool operations to allocate and free memory in it caused the misses.

• Question 123:

  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 for the workload created by the jobs.
  D. Create services for the applications, create job class associated with the service, and then create jobs by using the job classes.
  D. Create services for the applications, create job class associated with the service, and then create jobs by using the job classes.

• Question 124:

  View the Exhibit and analyze a portion of the Active Session History (ASH) report marked with a red rectangle.Which two can be inferred from the output? (Choose two.)

  

  A. increase in the number of active sessions
  B. unable to grow the database buffer cache as per demand
  C. increase in number of COMMITS and ROLLBACKS per second
  D. increase in the number of processes waiting for the buffer busy wait event
  A. increase in the number of active sessions
  D. increase in the number of processes waiting for the buffer busy wait event

• Question 125:

  You work for ABC Pvt Ltd. The company has recently upgraded one of its development databases to Oracle Database 11g from Oracle Database 10g. You noticed that the System Global Area (SGA) is undersized as shown in the Exhibit. To investigate further, you checked the related parameters as shown below: SQL> show parameter sga_max_size NAME TYPE VALUE ------------------------------ --------------- ----------------- sga_max_size big integer 500M SQL> show parameter target NAME TYPE VALUE ------------------------------ --------------- ------------------ archive_lag_target integer 0 db_flashback_retention_target integer 1440 fast_start_io_target integer 0 fast_start_mttr_target integer 0 memory_max_target big integer 0 memory_target big integer 0 pga_aggregate_target big integer 384M sga_target big integer 384M

  Which is the best solution that you would recommend?

  

  A. Increase the value of the SGA_MAX_SIZE parameter.
  B. Set MEMORY_MAX_TARGET and MEMORY_TARGET parameters.
  C. Reduce the value of the PGA_AGGREGATE_TARGET parameter.
  D. Increase the value of both SGA_TARGET and PGA_AGGREGATE_TARGET parameters.
  E. Diagnose further to identify which component in SGA is undersized and then resize it.
  B. Set MEMORY_MAX_TARGET and MEMORY_TARGET parameters.

• Question 126:

  Which three statements are true about performance analysis by SQL Performance Analyzer? (Choose three.)

  A. It detects changes in SQL execution plans.
  B. It shows only the overall impact on workload.
  C. It produces results that can be used to create the SQL plan baseline.
  D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQL statements.
  E. The importance of SQL statements to be analyzed is based on the size of the objects accessed.
  A. It detects changes in SQL execution plans.
  C. It produces results that can be used to create the SQL plan baseline.
  D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQL statements.

• Question 127:

  You are a DBA in ABC Corp. You are working on an online transaction processing (OLTP) system.The applications running on the database use connection pooling to connect to the database to perform transactions.

  The company wants to upgrade the CPU and the memory for the machine on which the database is running. To test the realistic workload on the new machine with increased CPU and memory, you identified the peak workload time for the

  database and captured the workload on the production system.

  You set up the test machine with the upgraded CPU and memory and installed the database with the same version as production.

  Which three actions would you perform to accomplish the realistic replay of the peak workload on the test machine? (Choose three.)

  A. Preprocess the captured workload for the specified target database version.
  B. Set up as many replay clients as there are actual clients to the production system.
  C. Set up all the replay clients on the same machine on which the test database is running.
  D. Resolve all external references such as database links, external tables, and directory objects.
  E. Restore the replay database to match the capture database at the start of the workload capture.
  A. Preprocess the captured workload for the specified target database version.
  D. Resolve all external references such as database links, external tables, and directory objects.
  E. Restore the replay database to match the capture database at the start of the workload capture.

• Question 128:

  Examine the following block:

  BEGIN

  DBMS_WORKLOAD_REPOSITORY.DROP_BASELINE (baseline_name => 'peak baseline', cascade => FALSE, dbid => 3310949047);

  END;

  Why would you use the FALSE value for the CASCADE parameter while dropping the baseline?

  A. because it does not remove snapshots associated with the baseline
  B. because it does not drop the template that is used to create the baseline
  C. because it does not remove the baseline from the performance page if it appears there
  D. because it does not remove the Automatic Database Diagnostic Management (ADDM) results from the Automatic Workload Repository (AWR) that were generated using the baseline
  A. because it does not remove snapshots associated with the baseline

• Question 129:

  View the Exhibit and analyze the output of a query executed on the V$MEMORY_RESIZE_OPS view. Why do INITIAL_SIZE, TARGET_SIZE, and FINAL_SIZE columns have the value zero for some of the components?

  

  A. because they are the only components that are auto-tuned
  B. because they are the only components that are not auto-tuned
  C. because they are the only components that have not undergone any manual resizing
  D. because they are the only components that do not have a default size or their respective parameters are not set in the initialization parameter file
  D. because they are the only components that do not have a default size or their respective parameters are not set in the initialization parameter file

• Question 130:

  Your organization has purchased licenses for the Diagnostic Pack along with the Oracle Database 11g software.The application workload on your database is known to be stable between 10:00 PM and midnight every night, but the performance on a particular Thursday was poor between 10:00 PM and 11:00 PM. Which tool would you consider using first to diagnose the cause of the performance degradation?

  A. Database Replay
  B. STATSPACK Report
  C. AWR Compare Report
  D. SQL Performance Analyzer
  C. AWR Compare Report