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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

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

#41. The Dynamic SGA feature allows the SGA to grow and shrink dynamically according to an ALTER SYSTEM command.
This avoids the previous need of shutting down the instance in order to modify the components of the SGA, namely the buffer cache and shared pool components.
Which three statements are true for the Dynamic SGA feature? (Choose three.)

#42. What is true about version-enabled tables?

#43. Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature? (Choose three.)

#44. Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically, and to perform a switch to a low priority consumer group before they are initiated? (Choose three.)

#45. There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice if you want to reduce the impact of long running operations on other users without aborting the long running operations?

#46. What do you need to do in order for the Database Resource Manager to estimate, in advance, the execution time of a statement?

#47. Online index rebuild functionality has been extended to include which four index structures? (Choose four.)

#48. The database was started up using a text parameter file.
What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement?

#49. Examine the statement:

 ALTER TABLE sales 
 EXCHANGE PARTITION q1_2000 
 WITH TABLE sales q1_2000 
 UPDATE GLOBAL INDEXES 
 PARALLEL (DEGREE 4);

What is the result of the statement?

#50. Which command can you use to alter the active size of the SGA dynamically, where the entered value differs from the current one?

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

ген. 0.081

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

Oracle 1Z0-030