1z0-040 Oracle - Braindumps.com.ua: список вопросов для "Oracle Database 10g: New Features for Administrators", страница: 3

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

Oracle 1z0-040: Oracle Database 10g: New Features for Administrators

#21. Which four statements regarding the Clone Database tool are correct? (Choose four.)

#22. The ______ procedure is used to determine which statements are needed to make your materialized view eligible for fast refresh and usable for general rewrite.

#23. The ______ identifies and helps to resolve performance problems relating to the execution of SQL statements by recommending which indexes, materialized views, or materialized view logs to create, drop, or retain.

#24. You need to create a schedule that will run a job on the second Friday of each month. What should the repeat interval of the schedule be set to?

#25. Which three file types are managed by Data Pump jobs? (Choose three.)

#26. You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in the parameter file of the database.
INSTANCE_TYPE = RDBMS
LARGE_POOL_SIZE = 8MB
BD_BLOCK_SIZE = 4K
LOG_ARCHIVE_DEST = +dgroupA
LOG_ARCHIVE_FORMAT = “$ORACLE_SID_%s_%t.%t”
DB_CREATE_FILE_DEST = +dgroupA
COMPATIBLE = 10.1.0.2.0
CONTROL_FILES = +dgroupA
Which parameter would be ignored while starting up the instance?

#27. Which statement regarding the implementation of shared policy functions is correct?

#28. Tom is the DBA of DNX Bank. The users of the banking system are complaining that all debit transactions are taking too long to execute. The details of the application used for this purpose are listed below:
Application – Bank_DNX to access banking accounts
Module – CUSTLEDGER
Action DEBIT_ENTRY
Which command should Tom execute in order to gather static for the states problem?

#29. You created a database (using Database Configuration Assistant [DBCA]) by using one of the default templates. The default permanent tablespace for the non-system users, excluding DBSNMP and OUTLN users, will be set to ________.

#30. Examine the following command to create an external table from EMPLOYEES and DEPARTMENTS database tables.

 1. CREATE TABLE employee_ext 
 2. (employee_id, first_name, department_name) 
 3. ORGANIZATION EXTERNAL 
 4. ( 
 5. TYPE ORACLE_LOADER 
 6. DEFAULT DIRECTORY ext_dir 
 7. LOCATION (‘emp1.dmp’) 
 8. ) 
 9. PARALLEL 
 10. AS 
 11. SELECT e.emplyee_id, e.first_name, e.last_name, d.department_name 
 12. FROM employees e, departments d;

Which line of the command would cause an error?

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

ген. 0.057

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

Oracle 1z0-040