1z0-024 Oracle - Braindumps.com.ua: список вопросов для "Oracle 8i: Performance Tuning", страница: 1

Профиль

Бреиндампы

Получить последний дамп

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

Network Appliance (2)

Авторизация

Логин:
Пароль:
запомнить меня:

Контакты
Сайты по тематике
Cсылки

Авторизированые пользователи могут видеть ответы к вопросам.
Пожалуйста, авторизируйтесь или зарегистрируйтесь.

Список вопросов к экзамену:
Показать все комментарии

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]

ген. 0.142

Дата сервера 13:25 20-11-2008

Oracle 1z0-024