1z0-042 试题的质量和价值

daikao5 模拟测试题具有最高的专业技术含量，只供具有相关专业知识的专家和学者学习和研究之用。

100% 保证您通过 1z0-042 的考试

如果你使用 daikao5 模拟测试，我们将保证你的第一次参加考试即取得成功，否则，我们将全额退款！

试用后再购买

daikao5 提供每种产品免费测试。在您决定购买之前，请检测联接，可能存在的问题及试题质量和适用性。

daikao5认证考试题库专业提供Oracle 1z0-042 最新题库，完全覆盖 1z0-042 考试原题。

1z0-042由我们自己考场及合作考场的专业讲师，亲自为你操作

保证你1周内通过考试，得到通过1z0-042考试成绩单，可以到PRO或VUE官方网站确认！

全面接受支付宝支付，考试通过后，确认付款，安全，方便，快捷！

部分-1z0-042认证题库展示（非即时更新） 　
　
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