because 4194304 is the granule size
because 4194304 is the standard block size
because 4194304 is the largest nonstandard block size defined in the database
because 4194304 is the total size of data already available in the database buffer cache
第1题:
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()
第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?()
第3题:
Your database block size is 4 KB. In this database, you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace?()
第4题:
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?()
第5题:
The SGA_TARGET initialization parameter cannot be set to a value less than 1G
The SGA_TARGET initialization parameter cannot be set to a value greater than 1G
The Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGA
The values of the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters cannot be set manually.
No minimum limits are imposed on the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters.
The 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.
第6题:
Because 4194304 is the granule size
Because 4194304 is the standard block size
Because 4194304 is the largest nonstandard block size defined in the database
Because 4194304 is the total size of data already available in the database buffer cache
第7题:
The command would return an error because LOG_BUFFER is a static parameter.
The parameter value would be changed and it would come into effect immediately.
You need to restart the database so that parameter changes can come into effect.
The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
第8题:
The SGA_TARGET initialization parameter cannot be set to a value greater than 8G
The DB_CACHE_SIZE initialization parameter cannot be set to a value less than 2G
The DB_CACHE_SIZE initialization parameter cannot be set to a value greater than 2G
The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value greater than 960M
The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value less than 960M
第9题:
The command succeeds only if Automatic Memory Management is not enabled.
The command succeeds, but you need to restart the database for changes to take effect.
The command returns an error because the size of the redo log buffer cannot be changed dynamically.
The parameter value is changed and it comes into effect as soon as space becomes available in theSystem Global Area (SGA)
第10题:
use the ALTER SYSTEM command to change the time zone
use the ALTER SESSION command to change the time zone
use the ALTER DATABASE command to change the time zone
set the value for the operating system variable ORA_SDTZ on the client machine
set the value for the operating system variable ORA_SDTZ on the database server machine
第11题:
The minimum memory size for the database buffer cache is set to 100 mb.
The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mb
The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.
The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb
第12题:
ALL
PFILE
BOTH
NONE
SPFILE
MEMORY
INSTANCE
DATABASE
第13题:
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? ()
第14题:
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? ()
第15题:
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()
第16题:
The command succeeds only if Automatic Memory Management is not enabled.
The command succeeds, but you need to restart the database for changes to take effect.
The command returns an error because the size of the redo log buffer cannot be changed dynamically.
The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area (SGA).
第17题:
because 4194304 is the granule size
because 4194304 is the standard block size
because 4194304 is the largest nonstandard block size defined in the database
because 4194304 is the total size of data already available in the database buffer cache
第18题:
It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically
It will be successful only if the memory is available from the auto tuned components
It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET
It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE
第19题:
Because 4194304 is the granule size
Because 4194304 is the standard block size
Because 4194304 is the largest nonstandard block size defined in the database
Because 4194304 is the total size of data already available in the database buffer cache
第20题:
The statement fails because you cannot set the memory components manually if the SGA_TARGET initialization parameter is set to a nonzero value.
The statement fails because the DB_8K_CACHE_SIZE initialization parameter is not a dynamic parameter.
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.
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.
第21题:
V$INSTANCE
V$CONTROLFILE
DBA_CONTROL_FILES
V$DATABASE_PROPERTIES
V$CONTROLFILE_RECORD_SECTION
第22题:
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.
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.
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.
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.
第23题:
The STATISTICS_LEVEL initialization parameter is set to BASIC
The PGA_AGGREGATE_TARGET initialization parameter is set to zero.
The SGA_MAX_SIZE initialization parameter is set to less than 20 GB
The DB_CACHE_SIZE initialization parameter is set to less than 5 GB
The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.
第24题:
The parameter DB_CACHE_SIZE must be a multiple of 8.
The value of the parameter SGA_MAX_SIZE must be increased.
The tablespace must be created with a uniform extent size of 8 KB
The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.