[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-053 Dumps with VCE and PDF 471-480

2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!

Oracle Database 11g: Administration II

Question No: 471 – (Topic 14)

View the Exhibit to observe the error.

You receive this error regularly and have to shutdown the database instance to overcome the error. Automatic Shared Memory Management is configured for the instance.

What can you do to reduce the chance of this error in the future?


Ensurepass 2018 PDF and VCE

  1. Increase the value of SGA_MAX_SIZE

  2. Enable automatic memory management

  3. Set the PRE_PAGE_SGA parameter to true

  4. Lock the System Global Area (SGA) in memory

Answer: B Explanation:

ORA-04031: unable to allocate string bytes of shared memory (quot;stringquot;,quot;stringquot;,quot;stringquot;,quot;stringquot;)

Cause: More shared memory is needed than was allocated in the shared pool or Streams pool.

Action: If the shared pool is out of memory, either use the DBMS_SHARED_POOL package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE. If the large pool is out of memory, increase the initialization parameter LARGE_POOL_SIZE. If the error is issued from an Oracle Streams or XStream process, increase the initialization parameter STREAMS_POOL_SIZE or increase the capture or apply parameter MAX_SGA_SIZE.

Question No: 472 – (Topic 14)

In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command:

SQLgt;SELECT /* RESULT_CACHE */ sale_category, sum(sale_amt) FROM sales GROUP BY sale_category;

Where would the result of this query be stored?

  1. database buffer cache

  2. shared pool

  3. PGA

  4. large pool

Answer: B

Question No: 473 – (Topic 14)

Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)






Answer: A,B,C,D

Question No: 474 – (Topic 14)

When tuning Automatic PGA Memory Management, which of the following views will provide the information specified?

  1. The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET.

  2. The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET.

  3. The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management.

  4. The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management.

Answer: A

Question No: 475 – (Topic 14)

View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has undergone workloads of different capacities:

SQLgt; SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US FROM v$memory_dynamic_components

WHERE current_size!=0; What do you infer from this? Exhibit:

Ensurepass 2018 PDF and VCE

  1. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.

  2. The database instance is running with manual shared memory management.

  3. The database instance is running with manual PGA management.

  4. The database instance has the MEMORY_TARGET value set to a nonzero value.

Answer: D

Question No: 476 – (Topic 14)

View the Exhibit to examine the parameter values. You are planning to set the value for the MEMORY_TARGET parameter of your database instance.

What value would you assign? Exhibit:

Ensurepass 2018 PDF and VCE

  1. 1440 MB

  2. 90 MB

  3. 362 MB

  4. 272 MB

Answer: C

Question No: 477 – (Topic 14)

View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE). When you tried to start the database instance, you received the following error:

SQLgt; startup

ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information

Why did the instance fail to start? Exhibit:

Ensurepass 2018 PDF and VCE

  1. Because the PGA_AGGREGATE_TARGET parameter is not set

  2. Because the STATISTICS_LEVEL parameter is set to BASIC

  3. Because MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal

  4. Because both the SGA_TARGET and MEMORY_TARGET parameters are set.

Answer: B Explanation:

Setting SGA Target Size

You enable the automatic shared memory management feature by setting the SGA_TARGET parameter to a nonzero value. This parameter sets the total size of the SGA. It replaces the parameters that control the memory allocated for a specific set of individual components, which are now automatically and dynamically resized (tuned) as needed.


The STATISTICS_LEVEL initialization parameter must be set to TYPICAL (the default) or ALL for automatic shared memory management to function.

Question No: 478 – (Topic 14)

You have applications that have frequently executed queries, and produce small and static result sets. You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter.

What is the purpose of this configuration?

  1. to avoid round trips to the server by enabling caching of query results in client memory

  2. to improve performance by storing a copy of the data from the private SQL area of the PGA

  3. to enhance the query performance by creating a cache in the client memory for sorting operations

  4. to avoid the storing of query plans and results in the server by creating a cache in the client memory

Answer: A

Question No: 479 – (Topic 14)

Which statements about the MEMORY_TARGET initialization parameter are true? (Choose all that apply.)

  1. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zero

  2. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set

  3. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.

  4. MEMORY_TARGET is static and cannot be modified without shutting down the instance

Answer: A,B,C

Question No: 480 – (Topic 14)

Note the following parameters settings in your database:

Ensurepass 2018 PDF and VCE

You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQLgt; ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;

What would happen?

  1. It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically

  2. It will be successful only if the memory is available from the auto tuned components

  3. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET

  4. It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within


Answer: D Explanation:

This is an actually mathematic question.

100% Free Download!
Download Free Demo:1z0-053 Demo PDF
100% Pass Guaranteed!
Download 2018 EnsurePass 1z0-053 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 EnsurePass IT Certification PDF and VCE

Leave a Comment


Your email address will not be published. Required fields are marked *