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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

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

#61. What are three benefits of performing data definition language (DDL) statements against a partitioned table with the UPDATE GLOBAL INDEXES clause? (Choose three.)

#62. What does the Metadata Application Programming Interface (API) allow you to do?

#63. Which two are true regarding a list-partitioned table? (Choose two.)

#64. Which two are true regarding automatic space management segments? (Choose two.)

#65. Which three parameters are ignored when creating an automatic space management segment? (Choose three.)

#66. A bitmap join index is defined as __________.

#67. What is true regarding fact tables having bitmap join indexes defined on them?

#68. Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR, cursors are shared for safe literals only. What is meant by 'safe literals only'?

#69. When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view?

#70. The CURSOR_SHARING parameter is set to SIMILAR at the instance level and you issue these SELECT statements in the order shown below:

 SELECT * FROM employees WHERE department _id=50; 
 SELECT * FROM employees WHERE department_id=70;

There is an index on the DEPARTMENT ID column of the 1,000,000 row EMPLOYEES table.
Ninety percent of the employees are part of DEPARTMENT_ID 50.
In which two scenarios will Oracle9i share the corresponding cursors for the two statements? (Choose two.)

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

ген. 0.065

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

Oracle 1Z0-030