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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

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

#51. How are deadlocks resolved within Oracle?

#52. When a deadlock occurs, what should be used to diagnose the problem and determine how to prevent the deadlock from occurring again?

#53. When the archive process encounters an error, which parameter determines the directory where trace files are written?

#54. To control fragmentation of your shared pool space, when is the best time for you to pin objects with the DBMS_SHARED_POOL package?

#55. Which type of change to an application is most likely to improve the performance of the library cache?

#56. The cost-based optimizer can choose between a nested loops join and a sort merge join operation. All tables are analyzed and the OPTIMIZER_MODE is set to FIRST_ROWS. Which execution plan will be the result?

#57. What is a potential reason for a "snapshot too old" error message?

#58. You are attempting to size the KEEP buffer pool and issue ANALYZE. . . . ESTIMATE STATISTICS commands. Which three data dictionary tables should you query to obtain the total number of blocks required for an object? (Choose three)

#59. The USERS table has thousands of rows and is accessed very often with an index (ISERID_NDX) on a primary key (USER_ID). Where should USERS and USERID_NDX be stored?

#60. You are creating a new rollback segment. Why should you choose the same value for the NEXT and INITIAL attributes?

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

ген. 0.045

Дата сервера 12:18 09-01-2009

Oracle 1z0-024