Databases represent the core of an organization's informational infrastructure. To effectively maintain those databases, it is imperative for administrators to be well trained. In this hands-on course, you gain the knowledge and skills to create and configure Oracle 10g databases, manage memory and storage effectively, and deploy essential procedures to maintain your organization's database and ensure its availability. | Exam 1Z0-042 Title Oracle Database 10g Administration I Ver 1Z0-042 QUESTION 1 You executed the following command to back up the control file ALTER DATABASE BACKUP CONTROLFILE TO TRACE What do you find in the trace file A. Image of the control file B. Location of the control file C. Contents of the control file in text format D. SQL command to re-create the database E. SQL command to re-create the control file F. Contents of the control file in binary format Answer E QUESTION 2 Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two steps are performed the first time any UPDATE statement is issued after the instance is started Choose two A. Creating the parse tree of the statement B. Writing the modified data blocks to the data files C. Writing the modified data to the archived redo log files D. Updating the control file to indicate the most recent checkpoint E. Updating the data file header to indicate the most recent checkpoint F. Reading the blocks to database buffer cache if they are not already there Answer C D QUESTION 3 You work as a database administrator for Certkiller .com. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective which component would you configure on each database server A. Database Control B. Management Server C. Management Repository D. Application Server Control E. Oracle Management Agent Answer E QUESTION 4 - The Power of Knowing 1Z0-042 The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file A. The data file cannot be recovered. B. The date file can be restored from theSYSTEMauto backup. C. Take thetablespaceoffline drop kand re-create it. D. Recovery Manager RMAN is used to recover the data file. E. The ALTER DATABSE CREATE used to recover the data file. Answer A QUESTION 5 You work as a database .
