Alter database clear logfile group 2 d alter database

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: ILE GROUP 2; D. ALTER DATABASE RECOVER LOGFILE GROUP 2; E. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2; Answer: E QUESTION 34: You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting: Configuration page you find that the majority of the wait time is for the redo log buffer. - The Power of Knowing 1Z0-042 Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks, and that the disk I/O for the redo log files is the reason for the performance degradation. Which two actions would you take to gain performance? Choose two A.Increase the size of redo log files B.Increase the size of redo log buffer C.Increase the number of redo log files D.Place the redo log files on a separate disk E.Decrease the number of redo log groups to two F.Increate the number Log Writer (LGWR) process Answer: B, D QUESTION 35: Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups? A.The database is in mount state. B.One of the tablespaces is offline. C.One of the tablespaces is read only. D.The database operates in ARCHIEVELOG mode. E.The database operates in NOARCHIEVELOG mode. Answer: E QUESTION 36: You work as a database administrator for Certkiller .com. In the middle of a transaction, a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario? Choose two A.Event Viewer gives more details on the failure. B.The alert log file gives detailed information about the failure. C.PMON rolls back the transaction and releases the locks. D.SMON rolls back the transaction and releases the locks. E.The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction. F.Data modified by the tra...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online