The SPFILE for your database contains the following parameter settings: SGA_TARGET = 1000M DB_CACHE_SIZE = 512M SHARED_POOL_SIZE = 128M LOG_BUFFER = 10M DB_8K_CACHE_SIZE = 50M What is the total memory that can be distributed across the auto-tuned memory components?()
第1题:
Which three statements regarding the server parameter file (SPFILE) are true()
第2题:
In your running instance, some of the initialization parameters are set as shown below: SGA_MAX_SIZE = 14GB DB_CACHE_SIZE = 1GB SHARED_POOL_SIZE = 3GB STATISTICS_LEVEL = BASIC PGA_AGGREGATE_TARGET = 0 You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason?()
第3题:
You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area (PGA): SORT_AREA_SIZE = 150M HASH_AREA_SIZE = 150M BITMAP_MERGE_AREA_SIZE = 150M CREATE_BITMAP_AREA_SIZE = 150M WORKAREA_SIZE_POLICY = AUTO You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area (SGA) is currently sized at 4G. What is the total PGA memory allocated across all database server processes?()
第4题:
You create an Oracle 10g database and configure the SPFILE as follows: SGA_TARGET=2G DB_CACHE_SIZE=512M LOG_BUFFER=50M DB_KEEP_CACHE_SIZE=128M You modify the SGA_TARGET initialization parameter using the following statement: SQL>ALTER SYSTEM SET SGA_TARGET = 1G SCOPE = BOTH; Which entity does this statement affect?()
第5题:
Your SPFILE contains the following parameter settings: SGA_TARGET = 8G DB_CACHE_SIZE = 4G SHARED_POOL_SIZE = 2G LARGE_POOL_SIZE = 512M JAVA_POOL_SIZE = 512M LOG_BUFFER = 100M SGA_MAX_SIZE = 10G You query the V$SGA_DYNAMIC_COMPONENTS dynamic performance view and discover that the large pool component is currently sized at 1G. You want the value of the SGA_TARGET initialization parameter to 10G, but instead of specifying a value of 10G for the SGA_TARGET initialization parameter, you erroneously execute the following statement: SQL>ALTER SYSTEM SET SGA_TARGET = 0 SCOPE = BOTH; What is the result of this statement?()
第6题:
You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration, you specify the following parameter settings in the SPFILE:// SGA_TARGET = 512M SHARED_POOL_SIZE = 256M Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE? ()
第7题:
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?()
第8题:
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).
第9题:
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.
第10题:
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
第11题:
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)
第12题:
10M
400M
600M
800M
第13题:
You specify a nonzero value for the MEMORY_TARGET initialization parameter,but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true?()
第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()
第15题:
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()
第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? ()
第17题:
The database has the data block size set to 8 KB. You need to import a tablespace with a 4 KB block size into the database. Which additional memory parameter(s) should be configured to perform a transportable tablespace import?()
第18题:
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?()
第19题:
An SPFILE is a binary file.
An SPFILE cannot reside on a client.
An SPFILE cannot contain static parameters.
An SPFILE can store changes persistently across instance restarts.
An SPFILE can be read by the database server, but it is not written to by the server.
An SPFILE must be created manually, before creating a database, even if you use the DatabaseConfiguration Assistant (DBCA) to create the database
第20题:
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.
第21题:
940M
990M
690M
1000M
第22题:
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.
第23题:
The database crashes.
The large pool releases 512M of memory.
The large pool retains 1G of allocated memory.
The large pool increases to 1,512M of memory.