When jack modifies a value in the table the new value

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: 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. Answer: D QUESTION 31: 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 appropriate indexes? Actualtests.com - The Power of Knowing 1Z0-042 A.Memory Advisors B.Segment Advisors C.SQL Tuning and Access Advisors D.Automated Workload Repository (AWR) E.Automatic Database Diagnostic Monitor (ADDM) Answer: C QUESTION 32: 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. Answer: E QUESTION 33: 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.

Ask a homework question - tutors are online