Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 401:

  Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:

  SQL> SELECT * FROM sales;

  Which process would retrieve the result from the database and return it to the client program?

  A. User process

  B. Server process

  C. System Monitor (SMON)

  D. Process Monitor (PMON)

  E. Checkpoint process (CKPT)

  Correct Answer: B

• Question 402:

  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:

  

  A. 1440 MB

  B. 90 MB

  C. 362 MB

  D. 272 MB

  Correct Answer: C

• Question 403:

  You set the following parameters in the parameter file and restarted the database:

  MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M

  Which two statements are true regarding these parameters after the database instance is restarted? (Choose two.)

  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.

  Correct Answer: AD

• Question 404:

  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?

  Exhibit:

  

  A. Increase the value of SGA_MAX_SIZE

  B. Enable automatic memory management

  C. Set the PRE_PAGE_SGA parameter to true

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

  Correct Answer: B

  ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string") 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 405:

  In Oracle 11g, by default which one of the following conditions implicitly enables Automatic PGA Memory Management?

  A. Setting a nonzero value for SGA_TARGET

  B. Configuring Automatic Shared Memory Management

  C. Configuring Automatic Memory Management

  D. Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET

  E. None of the above

  Correct Answer: B

• Question 406:

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

  A. SORT_AREA_SIZE

  B. HASH_AREA_SIZE

  C. BITMAP_MERGE_AREA_SIZE

  D. CREATE_BITMAP_AREA_SIZE

  E. PGA_AGGREGATE_TARGET

  Correct Answer: ABCD

• Question 407:

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

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

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

  C. 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.

  D. 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.

  Correct Answer: A

• Question 408:

  Examine the exhibit to view the parameters set in your parameter file. You restart the instance. To what value will the MEMORY_MAX_TARGET parameter be set by default? Exhibit:

  

  A. 120M

  B. 320M

  C. 440M

  D. 600M

  Correct Answer: D

• Question 409:

  Which statement about Automatic Memory Management with Oracle 11g is true?

  A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.

  B. Oracle can reallocate memory between the SGA and PGA automatically as needed.

  C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.

  D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.

  Correct Answer: B

• Question 410:

  The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application.

  Which of these are good starting points to use when configuring the maximum values for SGA and PGA, based on the amount of memory available on the system?

  A. 20% SGA, 80% PGA

  B. 25% SGA, 75% PGA

  C. 50% SGA, 50% PGA

  D. 75% SGA, 25% PGA

  E. 80% SGA, 20% PGA

  Correct Answer: E