Oracle 1z0-042 Exam

Oracle 1z0-042: oracle database 10g:administration i, these are some exam study guides which you will cover every field and category in 10g DBA helping to ready you for your successful Oracle Certification

Oracle 1z0-042 Exam Demo

1.The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct?

A: Undo data becomes obsolete after 1,000 seconds.

B: Undo data gets refreshed after every 1,000 seconds.

C: Undo data will be stored permanently after 1,000 seconds.

D: Committed undo data would be retained for 1,000 seconds if free undo space is available.

E: Undo data will be retained in the UNDO tablespace for 1,000 seconds, then it gets moved to the TEMPORARY tablespace to provide read consistency.

Correct Answers:  D

2.While granting a role, SELECT_CATALOG_ROLE, to a user, SCOTT, using Oracle Enterprise Manager 10g Database Control, you have cleared the DEFAULT check box. What will be the result?

A: The user cannot use the role at all.

B: The role would not be granted to the user.

C: The user needs to enable the role explicitly.

D: The user can start using the role immediately.

E: The user would have the admin option for the role.

Correct Answers:  C

3.In your database, the users SYS and SYSTEM have been assigned the profiles, ADMIN_PROF1 and ADMIN_PROF2, respectively. The rest of the database administrators are assigned the profile  ADMIN_PROF3.

You create a profile, USER_PROF, and assign it to the application user, Adams. After a week you realize that the profile is no longer required and you decide to drop it.

What will Adam's profile be after the USER_PROF profile has been dropped?

A: no profiles

B: the default profile

C: same as the profile of SYS user

D: same as the profile of SYSTEM user

Correct Answers:  B

4.Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true? (Choose two.)

A:The destination must be global only.

B:A maximum of five destinations can be assigned.

C:A maximum of ten different destinations can be assigned.

D:All the destinations are determined by the server automatically.

E:The destination may be local or remote for a Standby Database.

F:The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.

Correct Answers:  C, E

More information:CompTIA 220-601 Symantec 251-365 Cisco 640-816 Cisco 640-822 Cisco 642-105 Cisco 642-373 Cisco 642-426 Cisco 642-523 Cisco 642-552 Cisco 642-892 Cisco 642-973 Cisco 646-230