单选题To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL > startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARG

第1题：

You specify a nonzero value for the MEMORY_TARGET initialization parameter，but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.  Which statement about the result is true？（）

• A、 The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
• B、 The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGA
• C、 The database instance starts，but Automatic Memory Management is disabled
• D、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

第2题：

You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）

• A、Set the UNDO_RETENTION parameter to AUTO.
• B、Create an initial undo segment in undotablespace.
• C、Set the UNDO_RETENTION parameter to 900 or more
• D、Set the initialization parameter UNDO_MANAGEMENT to AUTO
• E、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

第3题：

You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）

• A、  STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；
• B、  STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
• C、  STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
• D、  STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

第4题：

Which of the following would you use to enable automatic media recovery for a database？（）

• A、SET AUTORECOVERY ON
• B、SET RECOVERY ON
• C、SET AUTO ON
• D、You cannot enable automatic media recovery.

第5题：

You set the following parameters in the parameter file and restarted the database：MEMORY_MAX_TARGET=0MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90MSGA_TARGET=270M Which two statements are true about these parameters after the database instance is restarted（）

• A、The MEMORY_MAX_TARGET parameter is automatically set to 500 mb.
• B、The pga_AGGREGATE_TARGET and sga_TARGET parameters are automatically set to zero.
• C、The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.
• D、The lower bounds of pga_AGGREGATE_TARGET and sga_TARGET parameters are set to 90 nb and270 mb， respectively

第6题：

The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL> STARTUP; Which two activities are performed during a successful start up operation?（）

• A、The databases configured to use the ASM instance are mounted
• B、The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter
• C、ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started
• D、ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters

第7题：

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. Now you get a report from users saying that DB1 meets deadlock problems. As the technical support, you have to capture the deadlock information to the SQL Server error log. What should you do?（）  

• A、For the AdventureWorks database, enable Server Auditing 
• B、First you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance 
• C、You should configure the data collector and make it capture the deadlock graphs
• D、You should configure a SQL Profiler trace, and make it capture the deadlock graphs

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which statement about Automatic Memory Management with Oracle 11g is true？（）  

• A、 You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or  PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.
• B、 Oracle can reallocate memory between the SGA and PGA automatically as needed.
• C、 To use Automatic Memory Management， you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.
• D、 You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.

第14题：

The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL> STARTUP; Which two activities are performed during a successful start up operation? （）(Choose two.)

• A、The databases configured to use the ASM instance are mounted
• B、The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter
• C、ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started
• D、ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters

第15题：

You execute the following command to start an Automatic Storage Management （ASM） instance：   SQL>STARTUP；   In which of the following modes will the ASM instance start？（）

• A、 OPEN
• B、 MOUNT
• C、 NORMAL
• D、 NOMOUNT

第16题：

You have control-file autobackups enabled. When starting your database from SQL*Plus， you receive the following error message：   SQL> startup ORA-01078： failure in processing system parameters LRM-00109：  could not open parameter file ，  C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN，   how would you respond to this error？（）  

• A、 Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.
• B、 Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.
• C、 Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.
• D、 Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.
• E、 Issue the restore spfile from autobackup command from the RMAN prompt.

第17题：

You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file：   INSTANCE_TYPE = ASM  ASM_POWER_LIMIT = 11  LARGE_POOL_SIZE = 4M   ASM_DISKGROUPS = DG1， DG2  DB_UNIQUE_NAME = +ASM   You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）

• A、 only the INSTANCE_TYPE initialization parameter is set to an invalid value
• B、 only the ASM_POWER_LIMIT initialization parameter is set to an invalid value
• C、 only the LARGE_POOL_SIZE initialization parameter is set to an invalid value
• D、 both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values

第18题：

Your network consists of a single Active Directory domain. The network contains two servers named Server1 and Server2 that run Windows Server 2003 Service Pack 2 （SP2）.You log on to Server1 by using the Administrator account for the domain. You open Event Viewer and attempt to connect to Server2 but receive the following error message.You verify that you can connect to Server2 by using Windows Explorer and that Windows Firewall is disabled on Server2. You open the Services snap-in on Server2 as shown in the exhibit.You need to ensure that you can connect to Server2 remotely by using Event Viewer.  What should you do on Server2？（）

• A、Add the Administrator account to the HelpServicesGroup.
• B、Set the Startup Type for the Remote Registry service to Automatic and then start the service.
• C、Set the Startup Type for the Secondary Logon service to Disabled and then stop the service.
• D、Set the Startup Type for the Special Administration Console Helper service to Automatic and then start the service.

第19题：

You configured automatic archive logging for the database. On the next startup the database runs for a while， but then hangs. After checking the alert log， you determine that all the online redo logs need archiving.  Which step was skipped when you set up automatic archive log？（）

• A、LOG_ARCHIVE_DEST was not set in the parameter file.
• B、LOG_ARCHIVE_START was not set in the parameter file.
• C、alter database archivelog； was not executed in MOUNT mode.
• D、LOG_ARCHIVE_MAX processes were not set in the parameter file.

第20题：

第21题：

第22题：

第23题：