oracle database 10g:administration i
Exam Number/Code : 1z0-042
Exam Name : oracle database 10g:administration i
Questions and Answers : 148 Q&As
Update Time: 2010-03-18
1z0-042 Price: $ 63.00

3. In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05:00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected? (Choose three.)
A. average row size
B. last analyzed date
C. size of table in bytes
D. size of table in database blocks
E. number of free blocks in the free list
F. number of extents present in the table
Answer: ABD

4. You executed the following command to export the EMPLOYEES table from a remote machine:
$ EXPDP hr/hr@data.us.oracle.com
DUMPFILE=my_dir:exp_hr.log
LOGFILE=data_pump_dir:log_hr.log
TABLES=employees
What would be the outcome of this command?
A. The command would execute successfully and the export dump file would be created in the destination of the directory object MY_DIR.
B. The command would execute successfully. But log file would not be created as DATA_PUMP_DIR directory is only accessible to user with SYSDBA privilege.
C. The command fails with an error because DATA_PUMP_DIR directory have higher precedence over the per-file directory.
D. The command fails with an error because no absolute path is specified for log file and dumpfile.
Answer: A

5. You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database.
Which type of script does the backup scheduler generate?
A. SQL script
B. PL/SQL script
C. Operating System (OS) script
D. Enterprise Manager (EM) script
E. Recovery Manager (RMAN) script
Answer: E

Oracle 1z0-042 exam is very important in your future work. Exam4test Oracle 1z0-042 Training Tools help you pass your 1z0-042 Exam in your first attempt. Just download the Exam4test Oracle 1z0-042 Practice Questions & Answers, Oracle 1z0-042 Practice Testing Software.

We offering Free Download Exam4test 1z0-042 braindumps as well Latest Exam4test 1z0-042 in PDF format and Testing Engine exam simulator, we claims that we are helping 10 of thousand student around the wrold to get free Exam4test 70-540csharp study materials.

Pass Oracle 1z0-042 exam is easy. Professionals interviewed noted chiefly the use of 1z0-042 study materials and practice exams. Therefore to pass an examination you need to have some 1z0-042 exam notes, Oracle 1z0-042 study guide, which will help you, pass your certification. This kind of help is provided by 1z0-042 Exam4test, this site is fully equipped with 1z0-042 exam review, 1z0-042 practice papers, 1z0-042 braindumps, 1z0-042 study guide, 1z0-042 exam answers, 1z0-042 practice test and many more preparation tools or exam resources making it easier for a candidate to pass 1z0-042 exam.

Related Exams:
310-230 Sun Certified Developer for Java Web Services
310-302 Sun Certified Network Administrator for Solaris 10 OS
310-345 Sun Certified System Administrator for Sun Cluster 3.2
312-50 Ethical Hacking and Countermeasures (CEHv6)
350-001 CCIE Cisco Certified Internetworking Expert