Fdata modified by the transaction up to the last

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: nsaction up to the last commit before the abnormal termination is retained in the database. Answer: C, F Actualtests.com - The Power of Knowing 1Z0-042 QUESTION 37: You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file? A.Restore all the data files and open the database B.Create the data file and performtablespacerecovery C.No need to restore any file, just recover the database D.Restore only the system data file and recover the database E.Restore only lost date file and performtablespacerecovery Answer: A QUESTION 38: You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this? Select two. A.Execute the ALTER DATABASE ARCHIVELOG statement B.Select ARCHIVELOG option in the database control and restart the database to apply the changes. C.Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement. D.Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement. Answer: B, D QUESTION 39: You work as a database administrator for Certkiller .com. You are using three database, Certkiller DB01, Certkiller DB02, and Certkiller DB03, on different host machines in your development environment. The database serverconfiguration, such as IP address and listener port number, change frequently due to development requirements, and you havethe task of notifying the developers of the changes. Which connection method would you use to overcome this overhead? A.Host naming B.Local naming C.Easy Connect D.External naming Actualtests.com - The Power of Knowing 1Z0-042 E.directory naming Answer: E QUESTION 40: Exhibit You work as a database administrator for Certkiller .com. While creating a new user...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online