1z0-054 | how many questions of 1z0-054 exam question?
Q41. 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
Q42. While reviewing the Top 5 Timed Events section in the Automatic Workload Repository report, you notice that the db file scattered read and db file sequential read events appear in the list.
Which two reasons could have caused these wait events? (Choose two.)
A. SQL statements performing frequent full table scans
B. tablespaces using manual segment space management
C. SQL statements performing frequent fast full index scans
D. excessive writes due to an aggressive checkpointing policy
Answer: AC
Q43. 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.
Answer: D
Q44. You identified poorly performing SQL by analyzing the V$SQL and V$SQLSTATS views. You want to investigate the plans for these SQL statements.
Which two methods can you use to pull out the execution plan from the library cache for the already executed SQL? (Choose two.)
A. Query V$SQL_PLAN to view the execution plan.
B. Query DBA_HIST_SQL_PLAN to view the execution plan.
C. Copy and paste the SQL text from the V$SQL view and use EXPLAIN PLAN to generate the execution plan.
D. Use the dbms_xplan.display_cursor function with the SQL ID and child number to generate the execution plan.
Answer: AD
Q45. Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)
A. Cursor cache
B. Stored outline
C. SQL Tuning Set
D. Automatic Workload Repository (AWR) snapshots
Answer: AC
Q46. 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 machine on which the production 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 performed the following operations for replay:
1) You preprocessed the captured workload.
2) You restored the replay database to match the capture database at the start of the workload capture.
3) You resolved all external references.
4) You set up replay clients.
You have the following replay considerations:
1) minimal data divergence to be ensured
2) all sessions to connect immediately.
3) user waits between issuing calls to be kept to a minimum
What replay options would you choose to accomplish the replay?
A. SYNCHRONIZATION = TRUE, THINK_TIME_SCALE = 0,
CONNECT_TIME_SCALE = 0 and
THINK_TIME_AUTO_CORRECT = TRUE
B. SYNCHRONIZATION = TRUE, THINK_TIME_SCALE = 0,
CONNECT_TIME_SCALE = 100 and
THINK_TIME_AUTO_CORRECT = TRUE
C. SYNCHRONIZATION = TRUE, THINK_TIME_SCALE = 100,
CONNECT_TIME_SCALE = 0 and
THINK_TIME_AUTO_CORRECT = FALSE
D. SYNCHRONIZATION = TRUE, THINK_TIME_SCALE = 100,
CONNECT_TIME_SCALE = 100 and
THINK_TIME_AUTO_CORRECT = TRUE
Answer: A
Q47. View the Exhibit and examine the Load Profile from the AWR report of a test database.The application must process an average of 10,000 very small transactions per day. The bulk of the processing activity is for DML operations with minimal to nil query processing.
Which two statements are correct about the values of the Physical reads events? (Choose two.)
Exhibit:
A. The per second value indicates the total number of data blocks read from disk to only the buffer cache.
B. The per transaction value includes both the db block gets and the consistent gets that occurred during the last sample period.
C. The per transaction value indicates that write or update transactions have been committed or rolled back during the last sample period.
D. The per second value indicates the total number of data blocks read from disk to the buffer cache including reads bypassing the buffer cache, and reads into process private buffers.
Answer: CD
Q48. View the Exhibit and examine the partial output from the following query in an online transaction processing (OLTP) database:
SQL>SELECT intsize_csec,metric_name,value, metric_unit FROM v$sysmetric;
Which two conclusions can you draw about the database from these metrics? (Choose two.)
Exhibit:
A. The buffer cache is inadequately sized for the workload.
B. Very few executions of SQL statements resulted in reparsing.
C. There were no multipass executions in the Program Global Area (PGA).
D. The database spends more time in wait events in comparison to statement processing.
Answer: BD
Q49. In which two scenarios would you recommend using RAID level 5 as an option for database storage?(Choose two.)
A. For a database with lower recovery (MTTR) overhead
B. For a database in which the applications primarily perform read operations and predominantly sequential I/O is performed
C. For a database in which performance is the primary goal of the database because applications are demanding in terms of I/O operations
D. For a database in which the database size grows rapidly, the cost of storage is critical and data accessibility is more important than performance
Answer: BD
Q50. View the Exhibit and examine the Automatic Database Diagnostic Monitor (ADDM) performance analysis.
Identify the correct description of the Impact(%) column in the Exhibit.
Exhibit:
A. It is the time consumed by the corresponding issue compared with the database time for the analysis period.
B. It is the time consumed by the corresponding issue compared with the response time for the analysis period.
C. It is the workload volume by the corresponding issue compared with the SYSTEM_MOVING_WINDOW baseline for the analysis period.
D. It is the resource consumed by the corresponding issue compared with the SYSTEM_MOVING_WINDOW baseline for the analysis period.
Answer: A