1Z0-030 Oracle - Braindumps.com.ua: список вопросов для "Oracle 9i: New Features For Administrators", страница: 8

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

Oracle 1Z0-030: Oracle 9i: New Features For Administrators

#71. The DBMS_STATS.GATHER_SYSTEM_STATS routine collects system statistics in a userdefined time frame.
Which four statements are true of the GATHER_SYSTEM_STATS routine? (Choose four.)

#72. Examine this fragment from a SQL*Plus session:

 SQL> SELECT name, VALUE FROM v$sysstat 
 2> WHERE name LIKE 'work area executions%';

 NAME                                VALUE 
 work area executions - optimal      1544 
 work area executions - onepass      11 
 work area executions - multipass    1038

What can you conclude about the setting of the PGA_AGGREGATE_TARGET initialization parameter?

#73. Which operation causes an index to be considered "used" while monitoring is turned on for that particular index?

#74. Consider the following statement:

 SQL> EXECUTE DBMS _STATS.GATHER_SCHEMA_STATS (- 
 2> ownname => 'OE', - 
 3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, - 
 4> method opt => 'for all columns size AUTO');

What is the effect of 'for all columns size AUTO' of the METHOD_OPT option?

#75. Using a bitmap structure to manage database object space has several benefits over using freelist structures.
Which three are benefits of managing space using automatic segment-space managed objects? (Choose three)

#76. The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether t has been used by an execution plan?

#77. What is the benefit of the Cached Execution Plan feature?

#78. For the best performance, what should be done with blocks transferred using the Cache Fusion algorithm in a Real Application Clusters database?

#79. Which statement correctly describes the function of the Oracle9i Cache Fusion feature?

#80. You start a multithreaded heterogeneous service agent with this initialization parameter:
MAX_DISPATCHERS = 10
What is the result?

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

ген. 0.071

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

Oracle 1Z0-030