多选题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？（）AALLBPFILECBOTHDNONEESPFILEFMEMORYGINSTANCE

第1题：

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.

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

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）

第4题：

Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command？ （）

• A、 os
• B、 local
• C、 -8：00
• D、 dbtimezone Li
• E、 Australia

第5题：

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.

第6题：

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_SIZE NAME TYPE VALUE  ------------------- ----------- ------------------  db_cache_size big integer 4194304  （4M）  Why is the value set to 4194304 and not to 2516582（）

• A、because 4194304 is the granule size
• B、because 4194304 is the standard block size
• C、because 4194304 is the largest nonstandard block size defined in the database
• D、because 4194304 is the total size of data already available in the database buffer cache

第7题：

In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level. You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated.How do you achieve this objective？（）

• A、 by setting the SQL_TRACE parameter to FALSE in the parameter file
• B、 by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session
• C、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session
• D、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You have specified the warning and critical threshold values of an application tablespace to be 60% and 70%， respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）

• A、The EVENT parameter was not set.
• B、The SQL_TRACE parameter is set to FALSE
• C、The Enterprise Manager Grid Control is not used.
• D、The STATISTICS_LEVEL parameter is set to BASIC
• E、The TIMED_STATISTICS parameter is set to FALSE

第14题：

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

第15题：

You are working as a DBA in an organization. The flash recovery area files are created in ’+disk1’. You want to create new flash recovery area files in the ’+disk2’ location. The new location of the flash recovery area files should be written in the control file and the spfile.Which command will you issue to change the location of the flash recovery area files？（）  

• A、 ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ’+disk2’ ；
• B、 ALTER SYSTEM SET DB_RECOVER_FILE_DEST = ’+disk2’ SCOPE = BOTH；
• C、 ALTER SYSTEM SET DB_CREATE_FILE_DEST = ’+disk2’；
• D、 ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_n = ’+disk2’；

第16题：

You have created a password file using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=3   Which of the following is true about this password file？（）

• A、 If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.
• B、 If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.
• C、 If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then the SYSDBA and SYSOPER privileges can be granted to other users as long as space in the password file is
• D、 If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then the SYSDBAand SYSOPER privileges can be granted to other users as long as space in the password file is available.

第17题：

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

第18题：

The database was started up using a text parameter file. What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement？（）

• A、Only MEMORY is updated.
• B、Only SPFILE values are updated.
• C、Only init.ora parameters are updated.
• D、Both init.ora parameters and SPFILE values are updated.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：