Most Popular Vendors
- IBM
- Cisco
- HP
- Microsoft
- CompTIA
- Oracle
- Symantec
- Citrix
- SUN
- Juniper Networks
- EMC
- Lpi
- Apple
- Nortel
- Adobe
- EC-COUNCIL
- Network Appliance
- VMWare
- COGNOS
- ISEB
- All Vendors >>
1z0-042 news
> Home > Oracle > 10g DBA > 1z0-042
1z0-042 Exam : oracle database 10g:administration i
Exam Number/Code: 1z0-042
Exam Name: oracle database 10g:administration i
Language(s): English
Price: $ 99.00
Questons and Answers : 287 Q&As
Updated: 2011-03-30
Buy it please click 1z0-042
- Free Demo: 1z0-042 PDF Demo
It is well known that 10g DBA 1z0-042 - 1z0-042 exam test is the hot exam of Oracle certification. pass4onside offer you all the Q&A of the 1z0-042 real test . It is the examination of the perfect combination and it will help you pass 1z0-042 exam at the first time!
The 10g DBA 1z0-042 Questions and Answers as well as our other 10g DBA 1z0-042 exam training tools are not only priced to be easy on your budget - but each one is also backed with our guarantee. pass4onside guarantees that after using our Cisco certification training tools, you will be prepared to take and pass your 10g DBA 1z0-042 exam.
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 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
4. 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
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
Our on-site online training experts create all of the Oracle 1z0-042 exam products available through pass4onside. Our main goal is to get your certified with a firm understanding of the core material. Whereas other online distributors only concern themselves with helping you obtain the paper, we strive to educate the certification candidate and better prepare them for their IT career.
Why choose pass4onside 1z0-042 braindumps
Quality and Value for the 1z0-042 Exam
100% Guarantee to Pass Your 1z0-042 Exam
Downloadable, Interactive 1z0-042 Testing engines
Verified Answers Researched by Industry Experts
Drag and Drop questions as experienced in the Actual Exams
Practice Test Questions accompanied by exhibits
Our Practice Test Questions are backed by our 100% MONEY BACK GUARANTEE.
1z0-042 news
Oracle News
Pass4side is the online Certification Expert recognized by a worldwide audience of IT professionals and executives alike as the definitive source of training materials for the candidate seeking insight, updates and resources for vendor certifications. Known as 1Z0-042 exam, is a Oracle certification.With the complete collection of questions and answers, Pass4side has assembled to take you through 151 questions to your 1Z0-042 Exam preparation. In the 1Z0-042 exam resources, you will cover every … [ more.. ]