The database instance is currently using SPFILE. View the Exhibit and examine the error that you receivedwhile running the DB Structure Integrity check. Given below are the steps to recover from the error in randomorder： 1.Shut down the instance， if not already done. 2.Copy one of the remaining control files to a new location. 3.Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of thecontrol files. 4.Start up the database instance to the NOMOUNT stage. 5.Recover the database to the point of failure of the control file. 6.Open the database.  Identify the correct sequence of steps（）

You execute this command in MOUNT mode： ALTER DATABASE ARCHIVELOG；  Where is the information that the database is now in ARCHIVELOG mode stored？（）

单选题查看答案

You created a database by using the Database Configuration Assistant. What must you do to access a user account in the sample schemas？（）

单选题查看答案

Examine the following command that is used to duplicate a database on the same host：   RMAN> RUN {  ALLOCATE AUXILIARY CHANNEL， aux 1 DEVICE TYPE DISK； DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY； / } Which two statements describe the effect after the database is duplicated successfully？（）

多选题查看答案

You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task（）

单选题查看答案

The SQL Tuning Advisor configuration has default settings in your database instance.  Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task？（）

单选题查看答案

Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database？（）

单选题查看答案

You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification.  Whichschema object enables the user to access the information from the remote database（）

单选题查看答案

You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure.  How would you proceed to recover the database？（）

单选题查看答案

You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?（）

单选题查看答案

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？（）

多选题查看答案