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

第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 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）.

第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 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

第5题：

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.

第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题：

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

第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题：

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

第10题：

You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）

• A、Configure Java Pool to cache the java objects.
• B、Configure Streams Pool to enable parallel processing.
• C、Increase Shared Pool size to cache more PL/SQL objects.
• D、Increase Database Buffer Cache size to increase cache hits.
• E、Configure Large Pool to be used by RMAN and shared server.
• F、Increase the total System Global Area （SGA） size to increase memory hits.