Date: 2010-10-29 16:49 Author: pass4onside Click: 23
Oracle 1z0-042 is the most important certification from the Oracle. Oracle 1z0-042 describe you the ways, strategies to manage, monitor and implement the Oracle Windows server infrastructure. Oracle 1z0-042 is recommended for the people who want to make the Network administrator in their future.
Each 1z0-042 resource available from Exam4test has been hand crafted by our team of practicing Oracle 1z0-042 IT Professionals. Exam4test is certain that your 1z0-042 Practice Exams, and 1z0-042 braindump are the highest quality, and customized to make the Exam4test learning experience the best choice you can make in preparing for your Oracle 1z0-042 CertificationExam.
Now guaranteed Oracle 1z0-042 exam training is available in various formats to best suit your needs and learning style. Whether you are a hands-on tactile learner, visually or even a textbook training veteran, Exam4test has the 1z0-042 exam resources that will enable you to pass your Oracle 1z0-042 test with flying colors.
Exam4test Oracle 1z0-042 questions and answers make you feel just like you are sitting in the prometric testing center and enjoying your real 1z0-042 exam attempts. It is Exam4test Oracle 1z0-042 exam materials that gives you confidence to pass this certification exam in first attempt and with maximized score.
We value the quality of training you receive through the Oracle 1z0-042 study guide and will never support Oracle 1z0-042 braindumps, or any 1z0-042 brain dump site. Exam4test 1z0-042 braindumps sites cannot compare to the understanding, learning and comprehension you will gain from a non-1z0-042 braindumps site, based on facts and case studies, like Exam4test.
Regardless of how soon you decide to take the actual 1z0-042 examination certification, you will be able to walk into the testing room as confident as the Certification Administrator.Our exams and Oracle 1z0-042 exam questions are constantly being updated and compared to industry standards.Oracle 1z0-042 exam updates are supplied free of charge.
Exam4test 1z0-042 Exam Dumps
Exam : Oracle 1z0-042
Title : Oracle Database 10g: Administration I
1. 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
2. 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
3. You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the instance has shut down before synchronizing all the database files.
Which two statements are true? (Choose two.)
A. On startup, SMON coordinates instance recovery.
B. On startup, CKPT coordinates instance recovery.
C. On startup, use RMAN to perform instance recovery.
D. Uncommitted changes will be rolled back after the database is opened.
E. On startup, perform media recovery and then instance recovery.
F. On startup, all the files will be synchronized and you get both committed and uncommitted data.
Answer: AD
4. 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
5. Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus?
A. The user must be granted the database administrator (DBA) privilege.
B. The user must be listed in the password file for the authentication.
C. No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.
D. Set up a user in the Oracle Application Server Containers for J2EE (OC4J) user manager, and grant the webDba role to the user.
Answer: D