You plan to use static database registration for a new listener when you create it.What could be the two reasons for this？（）A、More than one database is to be registered with the listener.B、The users will connect the database by using the host naming metho

第1题：

ou need to configure fine-grained access control to external network resources from within your database. You create an access control list （ACL） using the DBMS_NETWORK_ACL_ADMIN package.  Which statement is true regarding the ACL created？（）

• A、 It is a list of remote database links stored in the XML file that are available to the users of the database.
• B、 It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.
• C、 It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.
• D、 It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.

第2题：

You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）

• A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. 
• B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. 
• C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. 
• D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. 
• E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

第3题：

Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the database PROD. While setting up the connect string using Oracle Enterprise Manager 10g Database Control， which two options would you select to balance the connection load across all the listener processes？（）

• A、Use only the first address.
• B、Try one address，selected at random.
• C、Try each address，in order，until one succeeds.
• D、Try each address，randomly，until one succeeds.

第4题：

You plan to use static database registration for a new listener when you create it. What could be the two reasons for this？（）

• A、More than one database is to be registered with the listener.
• B、The users will connect the database by using the host naming method.
• C、The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.
• D、The database that is to be registered with the listener is configured in shared server mode.
• E、The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

第5题：

In which situation would you use static database registration for a listener（）

• A、when multiple databases are to be registered with the listener
• B、when DBAs need to connect remotely to start up the database instance
• C、when users need to connect the database instance using the host naming method
• D、when the database instance that is to be registered with the listener is configured in shared server mode

第6题：

Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).（）(Choose two.)

• A、You can use RMAN stored scripts
• B、Recovery is faster if data is stored in catalog in addition to the control file
• C、You can store backup information of all registered databases in one place
• D、Database backups are automatically deleted when they are older than the specified time period

第7题：

Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager （RMAN）.（）

• A、 You can use RMAN stored scripts
• B、 Recovery is faster if data is stored in catalog in addition to the control file
• C、 You can store backup information of all registered databases in one place
• D、 Database backups are automatically deleted when they are older than the specified time period

第8题：

You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（） 

• A、Create the database by using a single data file and a single log file.
• B、Create the database by using a single data file and multiple log files.
• C、Create the database by using a single log file and multiple filegroups.
• D、Create the database by using a single log file and a filegroup that has multiple data files.

第9题：

第10题：

第11题：

第12题：

第13题：

You need to design a configuration for Exchange Server storage that meets the business and technical requirements. What should you do？（）

• A、Create a single storage group. Create one database for all users
• B、Create two storage groups. In each storage group， create one database. Place mailboxes for remote users in one storage group database， and place all other mailboxes in the other storage group database
• C、Create two storage groups. In each storage group， create one database. Place executive mailboxes in one storage group database， and place all other mailboxes in the other storage group database
• D、Create two storage groups. In one storage group， create a database， and place all mailboxes for remote users and executives in the database. In the other storage group， create a database for all other mailboxes

第14题：

If you create your database using Oracle Managed Files （OMF）， what is true？（）

• A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures. 
• B、You must define directories for two online redo log groups and three copies of the control file. 
• C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. 
• D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.

第15题：

You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package. Which statement is true regarding the ACL created?（）

• A、It is a list of remote database links stored in the XML file that are available to the users of the database.
• B、It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.
• C、It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.
• D、It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.

第16题：

You are working as a Database Administrator. Despite having a password in the data dictionary as change_on_install， you always log on to the database MYNEWDB using operating system authentication. Your organization is planning to recruit two junior-level DBAs. You decide to enable remote authentication in your database so that the new DBAs can log on to the database from their workstations to carry out administrative tasks.   To allow the new DBAs to perform the administrative tasks， you create a password file on the database server using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4   After creating the password file， you remove the operating system authentication and change the value of the  REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE. You also create a net service name as MYNEWDB that allows the new DBAs to connect to the database server from their workstations using this net service name. Which command must you use to connect to the database to start it？（）  

• A、 CONNECT / AS SYSDBA
• B、 CONNECT sys/admin AS SYSDBA
• C、 CONNECT sys/admin@mynewdb AS SYSDBA
• D、 CONNECT sys/change_on_install AS SYSDBA

第17题：

You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)

• A、Reregistering the target database in recovery catalog
• B、Transporting the new tablespaces to the recovery catalog database
• C、Syncronizing the recovery catalog with the target database control file
• D、Performing a fresh backup of the target database to include the new data files in the catalog database

第18题：

You work as a database administrator for Supportcenter.cn. Your listener process， L1， is currently listening to three databases： CertK INDB04， SupportCenter DB05 and SupportCenter DB06. Using Database Configuration Assistant （DBCA） you create one more database， SupportCenter DB07， and enable dynamic registration. Which two commands of Listener Control Utility （lsnrct1） would you use to determine whether the dynamic registration occurred for the database， SupportCenter DB07， with the L1 listener process？（）

• A、SHOW L1
• B、SPAWN L1
• C、STATUS L1
• D、SERVICES L1
• E、STATUS LISTENER
• F、SERVICES LISTENER
• G、SHOWcurrent_listener

第19题：

You work as a database administrator for Supportcenter.cn. You are using three database， SupportCenter DB01， SupportCenter DB02， and SupportCenter DB03， on different host machines in your development environment. The database server configuration， such as IP address and listener port number， change frequently due to development requirements， and you have the task of notifying the developers of the changes. Which connection method would you use to overcome this overhead？（）

• A、Host naming
• B、Local naming
• C、Easy Connect
• D、External naming
• E、directory naming

第20题：

You have a listener process， L1， currently listening for the connections to the PROD and ADMIN databases. You create a new database， PAY， using CREATE  DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.  Which command of Listener control utility （LSNRCTL） would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications？（）

• A、START
• B、RELOAD
• C、RESTART
• D、REFRESH
• E、START L1
• F、RELOAD L1
• G、RESTART L1
• H、REFRESH L1

第21题：

第22题：

第23题：