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
第1题:
第2题:
What are two reasons to create synonyms?()
第3题:
A.Do you try
B.Have you tried
C.Are you trying
D.Have you been trying
第4题:
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?()
第5题:
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?()
第6题:
第7题:
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 > startup ORA-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.()
第8题:
第9题:
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings, you find that the following parameter has been set in the parameter file of the database: REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE?()
第10题:
You have a single Automatic Storage Management (ASM) instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file?()