网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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


参考答案

参考解析
解析: 暂无解析
更多 “单选题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 sizeB Because 4194304 is the standard block sizeC Because 4194304 is the largest nonstandard block size defined in the databaseD Because 4194304 is the total size of data already available in the database buffer cache” 相关考题
考题 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 AdvisorB、Segment AdvisorC、SQL Tuning AdvisorD、SQL Access AdvisorE、Automatic Database Diagnostic Monitor (ADDM)

考题 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$INSTANCEB、V$CONTROLFILEC、DBA_CONTROL_FILESD、V$DATABASE_PROPERTIESE、V$CONTROLFILE_RECORD_SECTION

考题 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 mbC、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

考题 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.

考题 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.

考题 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).

考题 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)

考题 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.

考题 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、ALLB、PFILEC、BOTHD、NONEE、SPFILEF、MEMORYG、INSTANCEH、DATABASE

考题 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 zoneB、 use the ALTER SESSION command to change the time zoneC、 use the ALTER DATABASE command to change the time zoneD、 set the value for the operating system variable ORA_SDTZ on the client machineE、 set the value for the operating system variable ORA_SDTZ on the database server machine

考题 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 sizeB、because 4194304 is the standard block sizeC、because 4194304 is the largest nonstandard block size defined in the databaseD、because 4194304 is the total size of data already available in the database buffer cache

考题 Note the following parameters settings in your database: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; What would happen?()A、It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamicallyB、It will be successful only if the memory is available from the auto tuned componentsC、It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGETD、It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE

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

考题 多选题You set the value of the SGA_TARGET initialization parameter to 1G to enable Oracle to automatically resize most of the memory components according to the current workload in the database. You issue the following statement:   SQL SELECT name, value, isdefault  2 FROM v$parameter   3 WHERE name LIKE ’%size%’;   The output of this statement displays that the DB_CACHE_SIZE, SHARED_POOL_SIZE,  LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters contain a zero value.  What does this imply?()AThe SGA_TARGET initialization parameter cannot be set to a value less than 1GBThe SGA_TARGET initialization parameter cannot be set to a value greater than 1GCThe Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGADThe values of the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters cannot be set manually.ENo minimum limits are imposed on the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and  JAVA_POOL_SIZE initialization parameters.FThe Automatic Shared Memory Management feature cannot be disabled unless you specify values for the  DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters in the initialization parameter file.

考题 单选题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 sizeB because 4194304 is the standard block sizeC because 4194304 is the largest nonstandard block size defined in the databaseD because 4194304 is the total size of data already available in the database buffer cache

考题 单选题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 sizeB Because 4194304 is the standard block sizeC Because 4194304 is the largest nonstandard block size defined in the databaseD Because 4194304 is the total size of data already available in the database buffer cache

考题 单选题Note the following parameters settings in your database: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; What would happen?()A It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamicallyB It will be successful only if the memory is available from the auto tuned componentsC It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGETD It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE

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

考题 单选题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 sizeB Because 4194304 is the standard block sizeC Because 4194304 is the largest nonstandard block size defined in the databaseD Because 4194304 is the total size of data already available in the database buffer cache

考题 单选题You observe that a 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 that required size of the database buffer cache? ()A  Memory AdvisorB  Segment AdvisorC  SQL Tuning AdvisorD  SQL Access AdvisorE  Automatic Database Diagnostic Monitor (ADDM)

考题 单选题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 8GB  The DB_CACHE_SIZE initialization parameter cannot be set to a value less than 2GC  The DB_CACHE_SIZE initialization parameter cannot be set to a value greater than 2GD  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

考题 单选题The SPFILE for the PROD database specifies the following initialization parameter values:   SGA_TARGET = 2G   DB_8K_CACHE_SIZE = 128M   You create a tablespace named HR with the non-standard block size of 8K. Four database users are running queries on a table in the HR tablespace. These users complain that the queries are taking longer than usual to complete. While investigating the reasons for this delay, you discover that the database encounters extensive cache misses on the database buffer cache with the block size of 8K. You issue the following statement to increase the value of the DB_8K_CACHE_SIZE initialization parameter to 256M:   SQLALTER SYSTEM SET DB_8K_CACHE_SIZE=256M SCOPE = BOTH;   What is the result of this statement?()A  The statement fails because you cannot set the memory components manually if the SGA_TARGET initialization parameter is set to a nonzero value.B  The statement fails because the DB_8K_CACHE_SIZE initialization parameter is not a dynamic parameter.C  The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and extracts an additional 128M of memory from the automatically sized memory components.D  The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and reallocates an additional 128M memory from the memory components that are not auto-tuned.

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

考题 单选题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$INSTANCEB V$CONTROLFILEC DBA_CONTROL_FILESD V$DATABASE_PROPERTIESE V$CONTROLFILE_RECORD_SECTION

考题 多选题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? ()Ause the ALTER SYSTEM command to change the time zoneBuse the ALTER SESSION command to change the time zoneCuse the ALTER DATABASE command to change the time zoneDset the value for the operating system variable ORA_SDTZ on the client machineEset the value for the operating system variable ORA_SDTZ on the database server machine

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

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

考题 多选题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?()AALLBPFILECBOTHDNONEESPFILEFMEMORYGINSTANCEHDATABASE