Oracle认证考试
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=1
题目
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 dynamically
- B、It will be successful only if the memory is available from the auto tuned components
- C、It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET
- D、It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE
相似问题和答案
第1题：
To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message:SQL > startupORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.Identify the reason the instance failed to start.（）
A.The PGA_AGGREGATE_TARGET parameter is set to zero.
B.The STATISTICS_LEVEL parameter is setto basic.
C.Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.
D.The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.
第2题：
You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）
- A、Immediately following statement execution
- B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued
- C、After the ALTER TABLE SET UNUSED COLUMN command is issued
- D、After the ALTER TABLE MODIFY command is issued
正确答案:B
第3题：
A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB
B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually
C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero
D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively
第4题：
You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）
- A、 STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
- B、 STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；
- C、 STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；
- D、 STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
正确答案:D
第5题：
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
第6题：
Your database is running in the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）
- A、modify the HASH_AREA_SIZE initialization parameter
- B、modify the PGA_AGGREGATE_TARGET initialization parameter
- C、modify the WORK_AREASIZE_POLICY initialization parameter
- D、increase the value of the SGA_TARGET initialization parameter
- E、increase the value of the SGA_MAX_SIZE initialization parameter
- F、increase the value of the SORT_AREA_SIZE initialization parameter
正确答案:B
第7题：
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
正确答案:A
第8题：
A. It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically
B. It will be successful only if the memory is available from the auto tuned components
C. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET
D. It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE
第9题：
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
第10题：
You created the ORDERS table in your database by using the following code： SQL> CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）； Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL> INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）； SQL> INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）； SQL> COMMIT； Next， you issued the following statement to change the time zone for the database： SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’； What will be the result of executing the above statement？（）
- A、 The statement will fail.
- B、 The statement will be executed successfully， and the new time zone will be set for the database.
- C、 The statement will be executed successfully， but the new time zone will be set for the current session.
- D、The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.
正确答案:A