1z0-032 Oracle - Braindumps.com.ua: список вопросов для "Oracle 9i: Database Fundamentals II", страница: 1

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

Network Appliance (2)

Авторизация

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

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

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

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

Oracle 1z0-032: Oracle 9i: Database Fundamentals II

#1. When performing incomplete recovery using UNTIL SEQUENCE with RMAN, which two pieces of information are required? (Choose two)

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

#3. Examine the list of variables and their data types:

 NAME         DATA          Type 
 TS, TS1      TIMESTAMP 
 TSZ          TIMESTAMP     WITH TIME ZONE 
 TLZ          TIMESTAMP     WITH LOCAL TIME ZONE 
 IYM          INTERVAL      YEAR TO MONTH 
 IDS, IDSI    INTERVAL      YEAR To SECOND

Which three expressions using the new data and time data types are valid? (Choose three)

#4. Consider the following statement:

 SQL> EXECUTE DBMS_STATS.GATHER_SHEMA_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?

#5. Which two are true regarding external tables? (Choose two)

#6. When does Oracle 9i flag an index as being used in the V$OBJECT_USAGE view?

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

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

#9. You can control instance recover performance by setting parameters to define targets for ______.

#10. Which three statements are true about the privileged connection options available in Oracle 9i? (Choose three)

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

ген. 0.152

Дата сервера 13:20 20-11-2008

Oracle 1z0-032