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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

Oracle 1z0-033: Oracle9i:Performance Tuning

#31. Which two statements are valid regarding index clusters? (Choose two.)

#32. You find a DBA using the DBMS_STATS package to back up statistics before analyzing objects. Which two reasons could trigger this action? (Choose two.)

#33. You executed the following SQL command in your production database. The results of this command are displayed in the Exhibit:

 SQL> SELECT shared_pool_size_for_estimate AS pool_size, 
 estd_lc_size, estd_lc_time_saved FROM v$shared_pool_Advice;

View the Exhibit.

Which statements are true regarding the result? (Choose all that apply.)

#34. You set PGA_AGGREGATE_TARGET to a nonzero value. Which two statements are true regarding this setting? (Choose two.)

#35. Which two statements are true regarding the statistics used by the optimizer to generate an optimal plan? (Choose two.)

#36. You created a mapping table on an index-organized table (IOT). What could be the reason for creating a mapping table?

#37. Which statement is true regarding the TKPROF output when the AGGREGATE=Y option is used?

#38. In your database the SORT_AREA_SIZE and HASH_AREA_SIZE are set to small values. Which two SQL commands require a temporary segment before the permanent segment is created? (Choose two.)

#39. In your production environment
• the database is running in ARCHIVELOG mode
• there are three online redo log groups
• there are two members in each group that are placed on different disks
• the archived redo log files are placed on disks other than the disks where the members of online redo log groups are placed
While performing transactions, users complain that transactions take a long time to complete. On investigation, you find that the STATUS column of the V$LOG data dictionary view shows the value ACTIVE, for two of the online redo log groups, thus causing the performance to be degraded.
Which action would you perform to increase the performance?

#40. View the Exhibit and compare the baseline and current data dictionary cache statistics in statspack reports.

The DBA had collected baseline statistics by using statspack six months ago. For the purpose of performance tuning, the DBA collects the current statistics. The database system does not have a heavy insert load. What recommendation would you make on the basis of the statistics provided in the Exhibit?

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

ген. 0.08

Дата сервера 11:23 09-01-2009

Oracle 1z0-033