READ Free Dumps For Oracle- 1z0-023
| Question ID 8759 | What is a default role?
|
| Option A | A role that requires a password.
|
| Option B | A role that requires no password.
|
| Option C | A role automatically enabled when the user logs on.
|
| Option D | A role automatically assigned when the user is created.
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct. A user may have several roles granted when he or she logs on. Some, all, or none of these roles can be set as a DEFAULT role, which means that the privileges given via the role will be available automatically when user logs on to Oracle Incorrect Answers: A: A default role may have a password, but it does not require it. B: A default role may have a password or may not have it. D: There is no role automatically assigned to the user when it was created, you need to assign roles to user after account creation. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 492 Chapter 10: Managing Database Use
| Question ID 8760 | Who is the owner of a role?
|
| Option A | SYS
|
| Option B | Nobody
|
| Option C | SYSTEM
|
| Option D | The creator
|
| Option E | The grantee
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct. Nobody owns a role in Oracle. Incorrect Answers: A: SYS user does not own any role in Oracle. C: SYSTEM user does not own any role in Oracle. D: The creator does not own a role he/she created. E: The grantee does not own a role he/she have been granted. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 490-495 Chapter 10: Managing Database Use