This preview shows page 1. Sign up to view the full content.
Unformatted text preview: lue in the table, the new
value is invisible to Bill.
Which is the modified value invisible to Bill?
A.The modified data are not available on disk.
B.The modified data have been flushed out from memory.
C.The modified rows of the Certkiller STAFF table have been locked.
D.Jack has not committed the changes after modifying the value.
E.Both users are accessing the database from two different machines.
You work as a database administrator for Certkiller .com. You find that reports are
running for a long time in your data warehousing applications. You suspect a lack
of indexes is the reason for the performance degradation.
Which advisory component would you refer to, in order to determine the
Actualtests.com - The Power of Knowing 1Z0-042 A.Memory Advisors
C.SQL Tuning and Access Advisors
D.Automated Workload Repository (AWR)
E.Automatic Database Diagnostic Monitor (ADDM)
You work as a database administrator for Certkiller .com. In your database server,
the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2.
What would this setting achieve?
A.It degrades the run time and compiler performance.
B.It provides better run time and compiler performance.
C.It provides better optimization of the statement during parse time.
D.It forces the rule based optimizer to be used for statement optimization.
E.It provides better run time performance but slightly degraded compiler performance.
F.It provides better run time performance but slightly degraded run time performance.
You work as a database administrator for Certkiller .com. Redo log files are not
multiplexed in your database. Redo log blocks are corrupted in group 2, and
archiving has stopped. All the redo logs are filled and database activity is halted.
Database writer has written everything to disk.
Which command would you execute to proceed further?
A. RECOVER LOFIEL BLOCK GROUP 2;
B. ALTER DATABASE DROP LOGFILE GROUP 2;
C. ALTER DATABASE CLEAR LOGF...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09