1z0-024 Oracle - Braindumps.com.ua: question list for "Oracle 8i: Performance Tuning", page: 1

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

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

Server date 11:32 08-01-2009

Oracle 1z0-024

Forum

Start online exam simulation

Master braindump

User braindumps