This preview shows page 1. Sign up to view the full content.
Unformatted text preview: been set to TYPICAL in the parameter file.
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
Actualtests.com - 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
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
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
F.AFTER INSERT OR DELETE OR DELETE
G.BEFORE INSERT OR DELETE OR DELETE
You work as a database administrator for Certkiller .com. You enabled tracing while
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09