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