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

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

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

#11. Which three types of statistics are reported in report.txt after running UTLESTAT SQL? (Choose three)

#12. What are two main OLTP requirements? (Choose two)

#13. Which table space is used as the temporary table space if 'TEMPORARY TABLESPACE' is not specified for a user?

#14. Which dynamic view is most useful for determining the current number of blocks allocated to a buffer pool?

#15. 15 Which three statements about improving the performance of the database buffer cache by creating multiple buffer pools are true? (Choose three)

#16. In which two ways can you reduce the amount of sorting that is performed? (Choose two)

#17. What will this statement do?

CREATE TABLESPACE temp 
 DATAFILE 'C:\database\emp.dbf' SIZE 10n 
 TEMPORARY;

#18. Which type of transaction should you assign to a specific large rollback segment?

#19. What is the least number of buffers an LRU latch must cover in the database buffer cache?

#20. Which three statements about rebuilding indexes are true? (Choose three)

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

gen. 0.092

Server date 06:46 02-12-2008

Oracle 1z0-024

Forum

Start online exam simulation

Master braindump

User braindumps