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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

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

#81. You discover that a disk failure occurred on DISK3 where the data file belonging to the USER_DATA table space is stored. The database is currently open and you need to recover the data file. You will restore the data file from the backup on DISK5 to DISK2. What is the correct sequence of commands to restore and recover the data file?

#82. In this scenario, assume that you archive logs 101 to 104 to two archiving destinations, /log1 and /log2. The control file contains archived log records as follows:
Sequence Filename
101 /log1/log_1_101.arc
101 /log2/log_1_101.arc
102 /log1/log_1_102.arc
102 /log2/log_1_102.arc
103 /log1/log_1_103.arc
103 /log2/log_1_103.arc
104 /log1/log_1_104.arc
104 /log2/log_1_104.arc
You accidentally delete logs 102 and 104 from log 1.
You run this command:

 BACKUP ARCHIVE LOG FROM SEQUENCE 101 UNTIL SEQUENCE 105;

What happens?

#83. You have just run this syntax to start the listener from the Listener Control utility:
LSNRCTL>START
Starting /mstgelai/oracle/bin/tnslsnr: please wait…
System parameter file is /u01/oracle/network/admin/listener.ora
Log messages written to /u01/oracle/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stc-sun01-
server)(PORT=1521)))
Connecting to…
The command completed successfully
What is the name of the Listener you started?

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

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

#86. You can use Oracle Flashback to look at past activity in your database.
What are two other characteristics of Oracle Flashback? (Choose two)

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

#88. Click the Exhibit (missing) button and examine the extract from a SQL*Plus session

Assuming that there is at least one row for each value shown in the HIGH VALUE column, what is the result of the ALTER TABLE statement?

#89. What should you look at first to compute the number of undo blocks written per second to disk?

#90. The EMPLOYEES table is stored in the SAMPLE table space.
The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX table space.
Out of 12 partitions, only partition P1 of the SALES table is stored in the SAMPLE table space. Which object will be exported by this command? exp system/manager table spaces=SAMPLE

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

ген. 0.072

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

Oracle 1z0-032