In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（） A、recovery catalogB、Oracle Enterprise Manager

第1题：

You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）

• A、 Flashback logs are not archived.
• B、 Flashback logs are maintained in redo log files.
• C、 Flashback logs are maintained in the Flash Recovery Area.
• D、 Flashback logs are used to maintain Flashback Database related errors.
• E、 Flashback logs need to be cleared manually after you disable Flashback Database.

第2题：

our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）

• A、Oracle Net Manager
• B、Listener Control utility
• C、Database Configuration Assistant
• D、Oracle Net Configuration Assistant

第3题：

In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（）

• A、 Recovery catalog
• B、 Oracle Enterprise Manager Repository
• C、 Automatic Workload Repository （AWR）
• D、 Oracle 10g Enterprise Manager Grid Control
• E、 Automatic Database Diagnostic Monitor （ADDM）

第4题：

You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces？（）

• A、SQL*Plus
• B、iSQL*Plus
• C、Management Server
• D、Management Repository
• E、Oracle Enterprise Manager 10g Database Control

第5题：

You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？ （）

• A、It is a SQL script.
• B、It is a PL/SQL file.
• C、It is an operating system （OS） file.
• D、It is a Recovery Manager （RMAN） script

第6题：

In an Oracle 10g database， the in/x7fmemory statistics are gathered at regular intervals and used to perform growth/x7ftrend analysis and capacity planning of the database. Which component stores these statistics？（）

• A、recovery catalog
• B、Oracle Enterprise Manager Repository
• C、Automatic Workload Repository （AWR）
• D、Oracle 10g Enterprise Manager Grid Control
• E、Automatic Database Diagnostic Monitor （ADDM）

第7题：

As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?（）

• A、CKPT
• B、SMON
• C、MMON
• D、DBWR

第8题：

You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）

• A、control file
• B、password file
• C、listener controller file
• D、control file and password file

第9题：

第10题：

第11题：

第12题：

第13题：

You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components？（）  

• A、 MMAN
• B、 PMON
• C、 MMON
• D、 MMNL

第14题：

You work as a database administrator for Supportcenter.cn. You want to administer your database servers， which are running on different host machines， using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）

• A、Application Server Control
• B、Oracle Management Service
• C、Oracle Enterprise Manager Repository
• D、Oracle Enterprise Manager Database Control

第15题：

While planning to manage more than one database in your system， you perform the following activities：  1. Organize different categories of files into independent subdirectories.  2. Use consistent naming convention for database files.  3. Separate administrative information pertaining to each database.  Which option corresponds to the type of activities performed by you？（）

• A、Oracle Managed Files
• B、Oracle Grid Architecture
• C、Optimal Flexible Architecture
• D、Oracle database architecture

第16题：

Which setting enables the baselines by default in Oracle Database 11g？（）  

• A、 setting the STATISTICS_LEVEL parameter to TYPICAL
• B、 adding filters to the Automatic Database Diagnostic Monitor （ADDM）
• C、 enabling Automated Maintenance Task using Oracle Enterprise Manager
• D、 setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE

第17题：

You have three databases， FINDB， PAYDB and ADMINDB， located in Sydney， Tokyo and Singapore respectively. You want to perform administrative tasks which include starting up and shutting down the databases， creating and managing tablespaces and database users， and taking regular backups， for all of the three databases from London. Which component must be enabled and running on each host machine to achieve your objective？（）

• A、Oracle Management Agent
• B、Enterprise Manager with Grid Control
• C、Enterprise Manager with Database Control
• D、Operating System Socket for incoming requests
• E、Real Application Cluster （RAC） with three instances
• F、Enterprise Manager with Generic Database Management

第18题：

Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?（）

• A、Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
• B、Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
• C、Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
• D、Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
• E、Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

第19题：

You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）

• A、 target database
• B、 auxiliary database
• C、 third-party database
• D、 recovery catalog database

第20题：

第21题：

第22题：

第23题：

第24题：