单选题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 o

第1题：

You work as a database administrator for Certkiller .com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.  Which advisory component would you refer to， in order to determine the appropriate indexes？（）

• A、Memory Advisors
• B、Segment Advisors
• C、SQL Tuning and Access Advisors
• D、Automated Workload Repository （AWR）
• E、Automatic Database Diagnostic Monitor （ADDM）

第2题：

You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）

• A、All control files are opened
• B、All redo files are opened
• C、The password file is opened
• D、The parameter file is opened
• E、All online data files are opened

第3题：

You work as a database administrator for Certkiller .com. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this？（）

• A、Enable instance failover
• B、Configure shared server
• C、Enable database failover
• D、Enable connect-time failover
• E、Enable Transparent Application Failover （TAF）

第4题：

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

第5题：

You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error： ERROR：  ORA-12154：TNS：couldnot resolve service name  Which network configuration files would you look into to resolve this error？（）

• A、snmp.ora
• B、names.ora
• C、spfile.ora
• D、sqlnet.ora
• E、listener.ora
• F、tnsnames.ora

第6题：

You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically.  Which tool or utility would you use to achieve this？ （）

• A、The DBMS_JOB package
• B、The BACKUP_JOB package
• C、The DBMS_BACKUP_RESTORE package
• D、The calendar tool in the Operating System （OS）
• E、The backup scheduler in Enterprise Manager （EM）
• F、The DBMS_BACKUP_SCHEDULER packager inline mode

第7题：

You work as a database administrator for Certkiller .com. In your organization， you have four databases， Certkiller DB01， Certkiller DB02， Certkiller DB03， and Certkiller DB04， which are located in Berlin， Frankfurt，Rammstein， and Munich respectively， and which were created using Database Configuration Assistant （DBCA）.  You want to perform administrative tasks on these databases that include startup and shutdown， taking regular backups， and so on， fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task？（）

• A、Control file
• B、Password file
• C、Parameter file
• D、Online redo log file
• E、Listener controller file
• F、Server parameter file

第8题：

You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）

• A、Hot backup
• B、Online backup
• C、consistent backup
• D、incremental backup
• E、inconsistent backup

第9题：

You work as a database administrator for Certkiller .com. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）

• A、The trace file
• B、The fixed views
• C、The data dictionary views
• D、The operating system log fields
• E、The dynamic performance views.

第10题：