1z0-040 Oracle - Braindumps.com.ua: question list for "Oracle Database 10g: New Features for Administrators", page: 3

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

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]

gen. 0.105

Server date 05:54 02-12-2008

Oracle 1z0-040

Forum

Start online exam simulation

Master braindump

User braindumps