You have two databases， FINDB and PAYDB， on single operating system and using Optimal Flexible architecture （OFA）. FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the followin

第1题：

You need to migrate the DeliveryVans， AirlinePreferences， and SeasonalContractors databases into the data center. What should you do？（）

• A、Install a separate instance of SQL Server 2005 for each of the databases on a single server.
• B、Create a SQL Server database for each of the databases in a single instance of SQL Server 2005.
• C、Import the data from each of the databases into a single database in an instance of SQL Server 2005.
• D、Install a default instance of SQL Server 2005 on three separate servers. Use one server for each of the databases.

第2题：

You manually create an additional listener process，L1，for databases PROD，  PAYDB and FINDB. While starting up the listener process，you get the following error message： LSNRCTL> start l1  Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr： please wait...  TNSLSNR for Linux： Version 10.1.0.2.0 - Production  System parameter file is /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/product/10.1.0/db_1/network/log/l1.log Error listening on： （ADDRESS=（PROTOCOL=TCP）（HOST=144.23.230.185）（port=8899））  TNS-12542： TNS：address already in use TNS-12560：  TNS：protocol adapter error TNS-00512： Address already in use  Linux Error： 98： Address already in use  Listener failed to start. See the error message（s） above...  What action would you take to overcome this error without disrupting any existing database communications？（）

• A、stop and restart the listener process
• B、set the TNS_ADMIN environmental variable
• C、stop all running listener processes and restart the listener process
• D、change the port number to an unused port number and restart the listener process
• E、change the IP address to host machine name in the LISTENER.ORA file and restart the listener process

第3题：

You have been assigned to manage a set of databases. The previous DBA did not leave you notes regarding the structure of each of the databases. While analyzing an instance， you notice that the system identifier （SID） for the instance is set to ’+ASM’. What is the purpose of this instance？（）

• A、 This instance is being used to manage the operating system files.
• B、 This instance is being used to manage the files of other databases.
• C、 This instance is being used to manage the instances of other databases.
• D、 This instance is being used to manage the background processes of other instances.

第4题：

You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）

• A、You can perform consistent backups only.
• B、You can perform a complete database backup without shutting down the database instance.
• C、You can back up data files only when all data files have the same SCN recorded in the control file.
• D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

第5题：

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

第6题：

You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance : SQL> shutdown immediate; What is the result of executing this command?（）

• A、The ASM instance is shut down, but the other instances are still running.
• B、It results in an error because other database instances are connected to it.
• C、All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
• D、HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.

第7题：

You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）

• A、The Oracle kernel will be placed in this location.
• B、The Oracle software will be placed in this location.
• C、The server parameter file （SPFILE） will be placed in this location.
• D、The database files will be placed in this location， if not specified explicitly.
• E、The location will be considered for the base of Oracle Managed Files （OMF）.
• F、The location will be considered for the base of Optimal Flexible Architecture （OFA）.

第8题：

You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL> shutdown immediate; What is the result of executing this command?（）

• A、All the instances, including the ASM instance, are shut down in the ABORT mode
• B、The ASM instance is shut down, but the other instances are still running 
• C、The ASM instance is still functional, but the other instances are shut down 
• D、All the instances, including the ASM instance, are shut down in the IMMEDIATE mode. 
• E、HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode 
• F、HRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in the IMMEDIATE mode

第9题：

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?（）

• A、By default, EM express is available for a database after database creation.
• B、You can use EM express to manage multiple databases running on the same server.
• C、You can perform basic administrative tasks for pluggable databases by using the EM express interface.
• D、You cannot start up or shut down a database Instance by using EM express.
• E、You can create and configure pluggable databases by using EM express.

第10题：

You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings， you find that the following parameter has been set in the parameter file of the database：  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）

• A、to enable operating system authentication for a remote client
• B、to restrict the scope of administration to identical operating systems
• C、to allow the start up and shut down of the database from a remote client
• D、to enable the administration of the operating system from a remote client
• E、to disable the administration of the operating system from a remote client