You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occurwhen a database instance is started and database is opened： 1. SGA is allocated. 2. Control file is read. 3. Redo log files are opened.4. Instance recovery is started. 5. Background processes are started. 6. Data file headers are checked for consistency. 7. Server parameter file or the initialization parameter file is read.  Which option has the correct order in which these steps occur（）

You are implementing a very simple TCP/IP network. It rarely changes and you would like to use Oracle Connection Manager to filter client requests.  Which naming method can you use？（）

单选题查看答案

You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to  ’LOG%t_%s_%r.dbf’.  Why is %r used in the file name format？（） 

单选题查看答案

You work as a database administrator for Certkiller .com. You are using Recovery Manager （RMAN） to perform backups in your databases.  Which four backup operations can be performed using RMAN？（）

多选题查看答案

You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space.  You can use Segment Advisor to （）

单选题查看答案

You want to configure and schedule offline database backups to run automatically.  Which tool or utilitywould you use to achieve this（）

单选题查看答案

In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file：  In what sequence would you use this process to perform the recovery？（）

单选题查看答案

In your datawarehousing application， you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins， resulting in a large performance overhead.  What kind of database structure would you use to reduce the response time of the query？（） 

单选题查看答案

You have used the CROSSCHECK BACKUP command to verify that the backups recorded in the RMAN repository actually exist.  Which command should you now use to check if any of the files were missing？（）

单选题查看答案

In your production database， you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager.  For which three resources can you enable usage restrictions by using Resource Manager？（）

多选题查看答案

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

单选题查看答案