Tài liệu dành cho các bạn luyện thi 1Z0-042 | 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 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. 1z0-042 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 administrator for Certkiller .com. You started the instance using . You have two
