Ethe statisticslevel parameter has been set to

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: been set to TYPICAL in the parameter file. Answer: C QUESTION 46: You work as a database administrator for Certkiller .com. In your transaction application, you have scheduled a job to update the optimizer statistics at05:00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected? Choose three A.Average row size B.Last analyzed date C.Size of table in bytes - The Power of Knowing 1Z0-042 D.Size of table in database blocks E.Number of free blocks in the free list F.Number of extents present in the table. Answer: A, B, D QUESTION 47: You work as a database administrator for Certkiller .com. You want to be notified when the number of disk I/O increases by 10% of what it was yesterday. You create a baseline metric for yesterday's disk I/O performance. How do you use the baseline metrics to achieve your objective? A.Save the baseline in the database B.Save the baseline in the Database Control Home Page C.Create a procedure to read and apply the baseline to disk I/O metrics D.Apply the baseline to the disk I/O metrics in the Mange Metrics page E.Alter the disk I/O metrics to include baseline by using the ALTER METRICScommnd Answer: D QUESTION 48: You work as a database administrator for Certkiller .com. In the Certkiller PRODUCTION database you have granted RESUMABLE system privilege to the CONNECT role.Resumablespace operation has been enabled for all user session. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead, you want the problem to be resolved by a database trigger automatically. Which combination of triggering time and event would you use to achieve this objective? A.AFTER CREATE B.AFTER SUSPEND C.BEFORE CREATE D.AFTER TRUNCATE E.BEFORE SUSPEND F.AFTER INSERT OR DELETE OR DELETE G.BEFORE INSERT OR DELETE OR DELETE Answer: B QUESTION 49: You work as a database administrator for Certkiller .com. You enabled tracing while creatin...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online