Free Download Oracle 1Z0-053 VCE Test Engine Full Version Now (311-320)

QUESTION 311
Which is true concerning Database Replay in an Oracle Real Application Cluster (RAC) database?

A.    Workload capture is per instance.
B.    You only need to restart one instance to begin workload capture.
C.    Specifically in RAC, you shut down all instances, restart them individually, and begin workload capture
with the last instance started.
D.    RAC does not support workload capture, but it does support workload replay.
E.    None of the above.

Answer: E

QUESTION 312
Performance divergence indicated in the Workload Replay report is most likely due to what?

A.    DML and SQL statement results that do not match between the capture and replay systems
B.    When errors that occur in the capture system dont occur in the replay system
C.    Top SQL statements
D.    Infrastructure or system-configuration differences
E.    Time-of-day differences between capture and replay systems

Answer: D

QUESTION 313
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

Answer: D

QUESTION 314
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

Answer: C

QUESTION 315
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

Answer: D

QUESTION 316
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

Answer: ABCD

QUESTION 317
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

Answer: E

QUESTION 318
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

Answer: AB

QUESTION 319
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

Answer: B

QUESTION 320
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

Answer: ABCD

If you want to pass Oracle 1Z0-053 successfully, donot missing to read latest lead2pass Oracle 1Z0-053 exam questions.
If you can master all lead2pass questions you will able to pass 100% guaranteed.

http://www.lead2pass.com/1Z0-053.html

Lead2pass Testking Pass4sure Actualtests Others
$99.99 $124.99 $125.99 $189 $29.99-$49.99
Up-to-Dated
Real Questions
Error Correction
Printable PDF
Premium VCE
VCE Simulator
One Time Purchase
Instant Download
Unlimited Install
100% Pass Guarantee
100% Money Back