单选题You have executed this command to change the size of the database buffer cache： SQL ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered. To verify the change in size， you executed this command：SQL SHOW PARAMETER DB_CACHE_SIZENAME TYPE VALUE --------

第1题：

Automatic Shared Memory Management （ASMM） has been enabled for your database instance.  Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M；  Which statement is true in this scenario（）

• A、The minimum memory size for the database buffer cache is set to 100 mb.
• B、The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mb
• C、The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.
• D、The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb

第2题：

You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）

• A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
• B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.
• C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
• D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

第3题：

You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks.  Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（） 

• A、Memory Advisor
• B、Segment Advisor
• C、SQL Tuning Advisor
• D、SQL Access Advisor
• E、Automatic Database Diagnostic Monitor （ADDM）

第4题：

You decided to increase the value for the SHARED_SERVERS parameter by using the following command：  SQL> ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=？；  Which three values can be specified for the SCOPE clause？（）

• A、ALL
• B、PFILE
• C、BOTH
• D、NONE
• E、SPFILE
• F、MEMORY
• G、INSTANCE
• H、DATABASE

第5题：

our database instance is started using the server parameter file （SPFILE）. You executed a command tochange the value of the LOG_BUFFER initialization parameter：ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）

• A、The command succeeds only if Automatic Memory Management is not enabled.
• B、The command succeeds， but you need to restart the database for changes to take effect.
• C、The command returns an error because the size of the redo log buffer cannot be changed dynamically.
• D、The parameter value is changed and it comes into effect as soon as space becomes available in theSystem Global Area （SGA）

第6题：

You decided to change the location of the flash recovery area. You executed the following command：   ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’；   Which statement is true？（）

• A、 The location can be changed only if the flash recovery area is empty.
• B、 After executing the command， all new flash recovery area files will be created in the new location.
• C、 The command will generate an error because you cannot change the flash recovery area while the database is open.
• D、 All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location.

第7题：

Your database instance is started using the server parameter file （SPFILE）. You executed acommand to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH；  What would be the outcome of this command（）

• A、The command succeeds only if Automatic Memory Management is not enabled.
• B、The command succeeds， but you need to restart the database for changes to take effect.
• C、The command returns an error because the size of the redo log buffer cannot be changed dynamically.
• D、The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area （SGA）.

第8题：

You executed the following command to start the database：  SQL> STARTUP  ORACLE instance started.  Total System Global Area 281018368 bytes  Fixed Size 789000 bytes  Variable Size 229635576 bytes  Database Buffers 50331648 bytes  Redo Buffers 262144 bytes ORA-00205： error in identifying controlfile， check alert log for more info  Which view would you query at this stage to investigate this missing control file？（）

• A、V$INSTANCE
• B、V$CONTROLFILE
• C、DBA_CONTROL_FILES
• D、V$DATABASE_PROPERTIES
• E、V$CONTROLFILE_RECORD_SECTION

第9题：

Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter：  ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH；  What would be the outcome of this command？ （）

• A、The command would return an error because LOG_BUFFER is a static parameter.
• B、The parameter value would be changed and it would come into effect immediately.
• C、You need to restart the database so that parameter changes can come into effect.
• D、The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

第10题：

The current time zone for one of the user sessions is set to the database local time zone. For one application， the user session requires the time zone to be set to the local operating system time zone without affecting other user sessions. Which two solutions could the user implement to achieve this objective？ （）

• A、 use the ALTER SYSTEM command to change the time zone
• B、 use the ALTER SESSION command to change the time zone
• C、 use the ALTER DATABASE command to change the time zone
• D、 set the value for the operating system variable ORA_SDTZ on the client machine
• E、 set the value for the operating system variable ORA_SDTZ on the database server machine