1z0-042 Oracle - Braindumps.com.ua: список вопросов для "Oracle Database 10g: Administration I", страница: 9

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

Oracle 1z0-042: Oracle Database 10g: Administration I

#81. You work as a database administrator for Company.com. You added a tablespace to your database.
Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure.
How would you proceed to recover the database?

#82. You work as a database administrator for Company.com. You received the following error while working on your database:
ORA-01555: snapshot too old
In which situation would you receive such an error?

#83. Exhibit #1, structure

Exhibit #2, insert command

You work as a database administrator for Company.com. Use exhibit #1 to see the structure of the EMPLOYEES, DEPARTMENTS and EMP_DEP tables.
User Company C wants to insert rows from EMPLOYEES and DEPARTMENTS table into EMP_DEP table by using the code in exhibit #2.
While user CompanyC executes the command, it errors out, displaying the following error message:
ERROR at line 1:
ORA-01653: unable to allocate extent table A.EMP_DEP by 8 in tablespace USERS
What would have caused the error?

#84. Exhibit :

You work as a database administrator for Company.com. Use the exhibit to see details about existing table spaces in the Oracle 10g database. You want to add a new table space to your database. Which three statements regarding a new table space are true? Choose three.

#85. Exhibit :

You work as a database administrator for Company.com. While trying to access Enterprise Manager Database Control by using a browser, you get an error. See exhibit. On further investigation, you find that the Oracle database 10g installation has just finished and your colleague, Company who installed the software, has not noted down all the port numbers. How do you determine the port number of the HTTP listener that is being used by Enterprise Manager Database Control?

#86. Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?

#87. Consider the following scenario: You have a directory, data, under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following command:

 ALTER DISKGROUP tdgroupA 
 ADD ALIAS '+tdgroupA/data/datafile.dbf' 
 FOR '+tdgroupA.231.45678';

Which task would be accomplished by the command?

#88. Exhibit :

One the evening of April 22, you are working on a database created using Oracle Database 10g. This database operates in the ARCHIVELOG mode. You discover that you need crucial data that was dropped from the database at 8:00 a.m. No full backup has been taken after April 15. What would you do?

#89. You are unable to move the Unified Job Scheduler occupant from the SYSAUX table space to the USERS table space. What could be the reason?

#90. You want to enforce a company's business policy on several objects by using a single policy function.
Which two types of policies can be assigned to the policy_type argument in the dbms_rls.add_policy procedure to achieve the above objective? (Choose two.)

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

ген. 0.053

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

Oracle 1z0-042