OCA OCP Oracle Certification Exam Braindumps

116. In your test database, you want to automatically collect database statistics at regular intervals. You execute the spauto.sql script to automate this task. What must you ensure before executing this script? 
A.The LOCK_SGA parameter is set to TRUE. 
B.The THREAD parameter is set to a nonzero value. 
C.The OPTIMIZER_MODE parameter is set to CHOOSE. 
D.The JOB_QUEUE_PROCESSES parameter is set to a nonzero value. 
E.The AQ_TM_PROCESSES parameter is set to a value higher than one. 
ANSWER: D  

117. Which three statements are true regarding STATSPACK? (Choose three.) 
A.STATSPACK data should be separated from production data by putting it in its own tablespace. 
B.Obsolete statistical data collected by STATSPACK cannot be purged. DBAs will need to drop the user PERFSTAT and reinstall STATSPACK.
C.To make performance comparisons from one day, week, or year to the next, there must be multiple snapshots taken over a period of time. 
D.You can capture both the complete text of a high-load SQL statement and   information on any SQL plan(s) associated with that statement in a STATSPACK report. 
E.When a snapshot is taken, STATSPACK will automatically generate a report that displays the statistical output, including load profile, efficiency percentage of the instance, and top five wait events.
ANSWER: ACD  

118. You detected a sudden file I/O load on your database. Consequently, you need to isolate user sessions that are contributing to the load. What is the first diagnostic step that you can take in the given scenario?  A.query the V$SYSSTAT dynamic performance view to identify the SQL statements causing maximum I/O 
B.use Top Session diagnostic pack in Oracle Enterprise Manager to identify the sessions that are contributing most to the I/O 
C.use the findings of the Reorg Wizard to identify the SQL statements that are causing maximum I/O 
D.query the V$SESSION dynamic performance view to check the value for the ROW_WAIT_ROW# column 
ANSWER: B  

119. The database performance is degrading. You need to isolate the SQL statements that are contributing to the disk I/O load. Which diagnostic step would you recommend in the given scenario? 
A.querying the V$SYSSTAT dynamic performance view to identify the SQL statements causing maximum I/O 
B.query the V$SQL dynamic performance view to check the value for the EXECUTIONS column 
C.using the findings of the Reorg Wizard to identify the SQL statements that are causing maximum I/O
 D.using Oracle SQL Analyze application of the Oracle Tuning pack to identify the SQL statements that consume the most resources 
ANSWER: D  

120. A customer has various dictionary-managed tablespaces with past data. The extents in dictionary-managed tablespaces are not uniformly sized. Newly created tablespaces are locally managed. You want to make all the tablespaces locally   managed. What approach would you use to change  the dictionary-managed tablespaces to locally managed tablespaces to get all the performance benefits of local extent management? 
A.use only the DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL procedure 
B.create new locally managed tablespaces and move data from existing dictionary-managed tablespaces to locally managed tablespaces 
C.use the DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL procedure, followed byDBMS_SPACE_ADMIN.TABLESPACE_FIX_SEGMENT_STATES 
D.use the ALTERTABLESPACE command to change extent management to  local, and then use the DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL procedure 
ANSWER: B