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

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

#81. You want to unload data from the ORDERS, ORDER_ITEMS, and PRODUCTS database tables to four os flat files by using the External Table Population methods. To achieve this objective, you execute the following command:

 CREATE TABLE orders_ext 
 (order_id, order_date, product_id, product_name,quantity) 
 ORGANIZATION EXTERNAL 
 ( 
 TYPE ORACLE_DATAPUMP 
 DEFAULT DIRECTORY ext_dir 
 LOCATION (‘orders1.dmp’,’orders2.dmp’,’orders3.dmp’,’orders4.dmp’) 
 ) 
 PARALLEL 
 AS 
 SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quanity 
 FROM orders o,products p,order_items i 
 WHERE o.order_id = i.order_id AND i.product_id = p.product_id;

After successful execution of the command, you find that only two files have been created and not four. Which option do you need to change to achieve your objective?

#82. Which two statements are correct regarding renaming a tablespace? (Choose two)

#83. You want to have a compatible audit trail of everything that has happened to the jobs in the job class named JOB_CLASSA. What should the logging level be for JOB_CLASSA?

#84. The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this?

#85. While observing database statistics, you found that the Automatic Workload Repository (AWR) snapshots are being purged after each day. You want the snapshots to be purged on a weekly basis. Which two options would you use to increase the purge interval? (Choose two)

#86. Consider the following configuration:
/devices/D1 is a member of disk group dgroupA.
/devices/D2 is a member of disk group dgroupA.
/devices/D3 is a member of disk group dgroupA.
You plan to add a new disk, /devices/D4, to the disk group dgroupA and execute the following command:

 SQL> ALTER DISKGROUP dgroupA ADD DISK ‘/devices/D4’;

Which task would be accomplished by the command?

#87. Which task would you perform to convert little-endian CLOB data to the big endian format while transporting from a database created in an earlier version of Oracle to an Oracle 10g database?

#88. The system was running a normal workload during the last 24 hours. You need to ensure that with the same workload you should be able to flashbash tables by three hours. What would you do to find the system recommendations for the undo retention period and the undo tablespace size?

#89. To which three elements is the size of the block change tracking file proportional? (Choose three)

#90. You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:

 ALTER TABLE employees SHRINK SPACE CASCADE;

Which statement is correct in this scenario?

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

gen. 0.079

Server date 06:05 02-12-2008

Oracle 1z0-040

Forum

Start online exam simulation

Master braindump

User braindumps