Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 411:

  By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value, you will enable which of the following memory-management options?

  A. Automatic PGA Memory Management

  B. Automatic SGA Memory Management

  C. Automatic Shared Memory Management

  D. Automatic Memory Management

  E. Manual SGA Memory Management

  F. None of the above

  Correct Answer: C

• Question 412:

  For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory management features?

  A. Automatic PGA Memory Management

  B. Automatic SGA Memory Management

  C. Automatic Shared Memory Management

  D. Automatic Memory Management

  E. Manual SGA Memory Management

  F. None of the above

  Correct Answer: D

• Question 413:

  To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor, you can set values for which of the following initialization parameters? (Choose all that apply.)

  A. DB_CACHE_SIZE

  B. SHARED_POOL_SIZE

  C. LARGE_POOL_SIZE

  D. JAVA_POOL_SIZE

  E. SGA_MAX_SIZE

  F. SORT_AREA_SIZE

  Correct Answer: ABCD

• Question 414:

  When manually configuring the SGA, which of the following parameter changes requires an instance restart to take effect?

  A. DB_CACHE_SIZE

  B. SHARED_POOL_SIZE

  C. LARGE_POOL_SIZE

  D. JAVA_POOL_SIZE

  E. SGA_MAX_SIZE

  F. SORT_AREA_SIZE

  Correct Answer: E

• Question 415:

  Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropriately? (Choose all that apply.)

  A. DB_CACHE_SIZE

  B. SHARED_POOL_SIZE

  C. LARGE_POOL_SIZE

  D. JAVA_POOL_SIZE

  E. SGA_MAX_SIZE

  F. SORT_AREA_SIZE

  Correct Answer: AB

• Question 416:

  What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?

  A. MMON

  B. LGWR

  C. ARCH

  D. ARWR

  E. COPY

  Correct Answer: C

• Question 417:

  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?

  A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE.

  B. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA.

  C. The database instance starts, but Automatic Memory Management is disabled.

  D. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter.

  Correct Answer: B

• Question 418:

  Which statements are true regarding the Query Result Cache? (Choose all that apply.)

  A. It can be set at the system, session, or table level.

  B. It is used only across statements in the same session.

  C. It can store the results from normal as well as flashback queries.

  D. It can store the results of queries based on normal, temporary, and dictionary tables.

  Correct Answer: AC

• Question 419:

  Note the following parameters settings in your database:

  

  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

  Correct Answer: D

  This is an actually mathematic question.

• Question 420:

  Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?

  A. Automatic PGA Memory Management

  B. Automatic SGA Memory Management

  C. Automatic Shared Memory Management

  D. Automatic Memory Management

  E. Manual SGA Memory Management

  F. None of the above

  Correct Answer: D