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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

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

#81. What is true regarding a shared, server-side parameter file for a Real Application Clusters database?

#82. You are attempting to create an Oracle-Managed Files (OMF) tablespace in a production database with the following statement and receive the following error message:

 CREATE TABLESPACE tbs1;

ORA-02199: missing DATAFILE/TEMPFILE clause
oerr ora 2199
02199, 00000, "missing DATAFILE/TEMPFILE clause"
*Cause: A CREATE TABLESPACE statement has no DATAFILE/TEMPFTLE clause.
*Action: Specify DATAFILE/TEMPFILE clause.
What is the corrective action to create the OMF based tablespace?

#83. Examine the statement:

 DROP TABLESPACE IND2 
 INCLUDING CONTENTS 
 AND DATAFILES;

What is the result of the statement?

#84. If you create your database using Oracle Managed Files (OMF), what is true?

#85. Examine the following parameter settings from an initialization (init.ora) file:
DB_CREATE_FILE_DEST = '/u01/oradata/'
DB_CREATE_ONLINE_LOG_DEST_1 = '/u02/oradata/'
DB_CREATE_ONLINE_LOG_DEST_2 = '/u03/oradata/'
If you create an Oracle Managed Files (OMF) database using these settings, what is the result?

#86. Examine the statement:

 SQL> CREATE TABLESPACE user_ data 
 2> EXTENT MANAGEMENT LOCAL 
 3> SEGMENT SPACE MANAGEMENT AUTO;

Which two assumptions must be true for this statement to execute successfully? (Choose two.)

#87. You want to drop the TBS1 tablespace from your database.
You also want to delete the corresponding data files automatically, and not have to do it manually. What should you do?

#88. What is true regarding a transaction executed in Automatic Undo Management mode?

#89. What are two key features of Automatic Undo Management? (Choose two.)

#90. Which two are true regarding the Automatic Undo Management feature? (Choose two).

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

ген. 0.081

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

Oracle 1Z0-030