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

题目
单选题
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）.

相似考题

1.View the Exhibit to examine the parameter values.You are planning to set the value for the MEMORY_TARGET parameter of your database instance.What value would you recommend?()A. 90 MBB. 272 MBC. 362 MBD. 1,440 MB

2. Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile

3. You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.  What configuration would you effect to achieve your objective？（）  A、 Set the ASM compatibility attribute for the ASM disk group to 11.1.0.B、 Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.C、 Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.D、 Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

4.You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.D、 Increase the value of the SGA_TARGET initialization parameter.

更多“单选题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 ”相关问题

  • 第1题：

    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.

    正确答案:A

  • 第2题：

    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）

    正确答案:C

  • 第3题：

    How can you make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database？（）

    • A、Include an SPFILE parameter in each instance-specified initialization file.
    • B、Create an SPFILE copy on each client from which the instance will be started.
    • C、Store the SPFILE in a raw partition with a vendor-specifies location and name.
    • D、Use a single client to start the instances and create the SPFILE on this client.

    正确答案:A

  • 第4题：

    You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order：  1）Shut down the instance.  2）Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.  3）Execute the ALTER DATABASE FLASHBACK OFF command.  4）Start up the instance and mount the database.  5）Execute the ALTER DATABASE FLASHBACKON command.  6）Open the database.  Select the correct order in which these tasks need to be performed. （）

    • A、2，1，4，3，5，6
    • B、1，4，3，2，6，5
    • C、1，4，2，6，3，5
    • D、3，2，1，4，5，6

    正确答案:A

  • 第5题：

    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

    正确答案:C,E,F

  • 第6题：

    单选题
    You executed the following command to back up your control file：  ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  Which initialization parameter is used to specify the location of the trace file？（）
    A

    USER_DUMP_DEST

    B

    CORE_DUMP_DEST

    C

    TRACE_DUMP_DEST

    D

    BACKUP_DUMP_DEST

    E

    BACKGROUND_DUMP_DEST


    正确答案： E
    解析： 暂无解析

  • 第7题：

    单选题
    You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of yourdatabase to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order： 1.Shut down the instance. 2.Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3.Execute the ALTER DATABASE FLASHBACK OFF command. 4.Start up the instance and mount the database. 5.Execute the ALTER DATABASE FLASHBACK ON command. 6.Open the database. Select the correct order in which these tasks need to be performed.（）
    A

    2，1，4，3，5，6

    B

    1，4，3，2，6，5

    C

    1，4，2，6，3，5

    D

    3，2，1，4，5，6


    正确答案： C
    解析： 暂无解析

  • 第8题：

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


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    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 ------------------- ----------- ------------------ db_cache_size big integer 4194304 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


    正确答案： C
    解析： 暂无解析

  • 第10题：

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


    正确答案： A
    解析： 暂无解析

  • 第11题：

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


    正确答案： D
    解析： 暂无解析

  • 第12题：

    多选题
    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


    正确答案： C,B
    解析： 暂无解析

  • 第13题：

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

    正确答案:C

  • 第14题：

    You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）

    • A、Datafiles
    • B、 Current control file
    • C、 Server parameter file （spfile）
    • D、 Password file

    正确答案:D

  • 第15题：

    You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of yourdatabase to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order： 1.Shut down the instance. 2.Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3.Execute the ALTER DATABASE FLASHBACK OFF command. 4.Start up the instance and mount the database. 5.Execute the ALTER DATABASE FLASHBACK ON command. 6.Open the database. Select the correct order in which these tasks need to be performed.（）

    • A、2，1，4，3，5，6
    • B、1，4，3，2，6，5
    • C、1，4，2，6，3，5
    • D、3，2，1，4，5，6

    正确答案:A

  • 第16题：

    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.

    正确答案:A

  • 第17题：

    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.

    正确答案:A

  • 第18题：

    单选题
    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）.


    正确答案： D
    解析： 暂无解析

  • 第19题：

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


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    How can you make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database？（）
    A

    Include an SPFILE parameter in each instance-specified initialization file.

    B

    Create an SPFILE copy on each client from which the instance will be started.

    C

    Store the SPFILE in a raw partition with a vendor-specifies location and name.

    D

    Use a single client to start the instances and create the SPFILE on this client.


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    You have included the following parameter settings in your SPFILE://    SGA_MAX_SIZE=8G   SGA_TARGET=6G   DB_CACHE_SIZE=2G   SHARED_POOL_SIZE=1G   LOG_BUFFER=64M   DB_KEEP_CACHE_SIZE=960M   Which statement is true if you modify the SGA_TARGET initialization parameter？（）
    A

    The SGA_TARGET initialization parameter cannot be set to a value greater than 8G

    B

     The DB_CACHE_SIZE initialization parameter cannot be set to a value less than 2G

    C

     The DB_CACHE_SIZE initialization parameter cannot be set to a value greater than 2G

    D

     The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value greater than 960M 

    E

     The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value less than 960M


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）
    A

    Datafiles

    B

     Current control file

    C

     Server parameter file （spfile）

    D

     Password file


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order：  1）Shut down the instance.  2）Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.  3）Execute the ALTER DATABASE FLASHBACK OFF command.  4）Start up the instance and mount the database.  5）Execute the ALTER DATABASE FLASHBACKON command.  6）Open the database.  Select the correct order in which these tasks need to be performed. （）
    A

    2，1，4，3，5，6

    B

    1，4，3，2，6，5

    C

    1，4，2，6，3，5

    D

    3，2，1，4，5，6


    正确答案： B
    解析： 暂无解析

  • 第24题：

    单选题
    You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）
    A

     Increase the value of the FAST_START_MTTR_TARGET initialization parameter.

    B

     Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.

    C

     Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.

    D

     Increase the value of the SGA_TARGET initialization parameter.


    正确答案： B
    解析： 暂无解析

相关内容