QUESTION: 1
You observe that a database performance has degraded over a period of time. While
investigating the reason, you find that the size of the database buffer cache is not large enough
to cache all the needed data blocks. Which advisory component would you refer to, in order to
determine that required size of the database buffer cache?

A. Memory Advisor
B. Segment Advisor
C. SQL Tuning Advisor
D. SQL Access Advisor
E. Automatic Database Diagnostic Monitor (ADDM)

Answer(s): A
QUESTION: 2
Exhibit

In your production database, the total waits and the time waited for log file parallel write are
significantly high. While investigating the reason, you find that there are three redo log groups
with two members in each group, and all redo log members are places on a single physical disk.
What action would you take to minimize the waits?

A. start the log writer slave processes
B. increase the number of redoes log files
C. increase the size of the redo log buffer
D. place the redo log files on the different disks
E. increase the number of log writer processes

2

Free Oracle 1Z0-043 Exam Braindumps

Exam Code: 1Z0-043 Exam Title: Oracle Database 10g: Administration II
Exam Provider: Oracle

Pass your Oracle Database 10g: Administration II exam with these free Actual Questions and Answers

1Z0-043 Exam Discussions & Posts