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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

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

#51. When querying the new v$spparameter view, the column ISSPECIFIED displays the value TRUE for a number of parameters. What does this mean?

#52. You are using automatic space-managed segments, and you wish to change the value of PCTFREE for a given table.
What can you do to ensure the change is made in the bitmap structure?

#53. How can you make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database?

#54. Oracle9i provides a database package called dbms_redefinition to perform an online rebuild of a table. Which two steps are you recommended to do prior to issuing the dbms_redefinition_start_redef table procedure call? (Choose two).

#55. An index-organized table (IOT) called SPARSE has had many records deleted.
Which command reorganizes the IOT so that the empty space is removed, while minimizing the impact for users?

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

#57. Which three table transformations can be done using online redefinition of tables? (Choose three.)

#58. Which is a restriction on a list partitioned table?

#59. Consider this syntax:

 MERGE INTO tl 
 USING t2 ON (join predicate).....

What does the MERGE syntax do?

#60. You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table, or for updates to its existing rows.
Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible?

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

ген. 0.087

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

Oracle 1Z0-030