Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.
Help Braindumps.com.ua to be introduced.

Oracle 1z0-024: Oracle 8i: Performance Tuning

#1. When performing a sort operation, you notice that there are a large number of sorts requiring I/O to the disk. Which parameter could be increased to allow more sorts to be performed in memory?

#2. Which statement could require a sort?

#3. Which two views can be sued to detect lock contention? (Choose two)

#4. The database includes tables with static data, which are used for queries only. To which size should you set PCTFREE for this type of table?

#5. Which action could potentially cause checkpoints to take longer?

#6. When a deadlock shutdown is detected by Oracle, where is the trace file generated?

#7. If a willing-to-wait latch request is satisfied on the first attempt, which statistic gets incremented?

#8. For which reason would you query V$SYSSTAT?

#9. Which two statements about plan stability and stored outlines are true? (Choose two)

#10. What does this statement do?
SQL> ANALYZE INDEX index_name VALIDITY STRUCTURE;

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10]

gen. 0.054

Server date 11:53 14-03-2010

Oracle 1z0-024

1z0-024 certification