[Free] 2018(Jan) Latesttests Testking Oracle 1z0-053 Dumps with VCE and PDF Download 481-490

Latesttests 2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-053.html

Oracle Database 11g: Administration II

Question No: 481 – (Topic 14)

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

  1. DB_CACHE_SIZE

  2. SHARED_POOL_SIZE

  3. LARGE_POOL_SIZE

  4. JAVA_POOL_SIZE

  5. SGA_MAX_SIZE

  6. SORT_AREA_SIZE

Answer: E

Question No: 482 – (Topic 14)

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

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

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

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

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

Answer: A,C

Question No: 483 – (Topic 14)

Note the following parameter settings: Which setting is NOT allowed?

  1. ALTER SYSTEM SET DB_CACHE_SIZE=50M;

  2. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;

  3. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;

  4. ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;

Answer: B

Question No: 484 – (Topic 14)

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

  1. DB_CACHE_SIZE

  2. SHARED_POOL_SIZE

  3. LARGE_POOL_SIZE

  4. JAVA_POOL_SIZE

  5. SGA_MAX_SIZE

  6. SORT_AREA_SIZE

Answer: A,B,C,D

Question No: 485 – (Topic 14)

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

  1. Automatic PGA Memory Management

  2. Automatic SGA Memory Management

  3. Automatic Shared Memory Management

  4. Automatic Memory Management

  5. Manual SGA Memory Management

  6. None of the above

Answer: D

Question No: 486 – (Topic 14)

Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two.)

  1. set SHARED_POOL_SIZE to zero

  2. set STATISTICS_LEVEL to BASIC

  3. set SGA_TARGET to a non-zero value

  4. set DB_CACHE_SIZE to a non-zero value

  5. set STATISTICS_LEVEL to TYPICAL or ALL

Answer: A,C

Question No: 487 – (Topic 14)

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:

Latesttests 2018 PDF and VCE

  1. 120M

  2. 320M

  3. 440M

  4. 600M

Answer: D

Question No: 488 – (Topic 14)

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

SQLgt; SELECT * FROM sales;

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

  1. User process

  2. Server process

  3. System Monitor (SMON)

  4. Process Monitor (PMON)

  5. Checkpoint process (CKPT)

Answer: B

Question No: 489 – (Topic 14)

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

  1. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.

  2. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually.

  3. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.

  4. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.

Answer: A,D

Question No: 490 – (Topic 14)

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?

  1. 20% SGA, 80% PGA

  2. 25% SGA, 75% PGA

  3. 50% SGA, 50% PGA

  4. 75% SGA, 25% PGA

  5. 80% SGA, 20% PGA

Answer: E

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

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

2018 Latesttests IT Certification PDF and VCE