READ Free Dumps For Oracle- 1z0-023
| Question ID 8843 | Which statement is incorrect?
|
| Option A | CREATE ROLE sales_clerk;
|
| Option B | CREATE ROLE sales_clerk NOT IDENTIFIED;
|
| Option C | CREATE ROLE sales_clerk IDENTIFIED BY bonus;
|
| Option D | CREATE ROLE sales_clerk IDENTIFIED EXTERNALLY;
|
| Option E | CREATE ROLE sales_clerk IDENTIFIED INTERNALLY;
|
| Correct Answer | E |
Explanation Explanation/Reference: Explanation: Answer E is correct. Command CREATE ROLE sales_clerk IDENTIFIED INTERNALLY is incorrect. Incorrect Answers: A: You can use this command to create role sales_clerk. B: You can use this command to create role sales_clerk without password. C: You can use this command to create role sales_clerk with password. D: You can use this command to create role sales_clerk with password identified by operation system. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 490-492 Chapter 10: Managing Database Use
| Question ID 8844 | What does the command ALTER USER scott DEFAULT ROLE NONE do?
|
| Option A | It revokes all default roles from Scott.
|
| Option B | It makes all of the roles granted to Scott default roles.
|
| Option C | It makes all of the roles granted to Scott nondefault roles.
|
| Option D | It enables Scott's currently-disabled roles for the duration of this session.
|
| Option E | It disables Scott's currently-enabled roles for the duration of this session.
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct. Clause DEFAULT ROLE NONE of ALTER USER command makes all of the roles granted to Scott nondefault roles. Incorrect Answers: A: All roles become nondefault, but they will not be revoked from Scott. C: Command ALTER USER scott DEFAULT ROLES ALL make all of the roles granted to Scott default roles. D: A role can be enabled or disabled for use with SET ROLE, not ALTER USER command. E: A role can be enabled or disabled for use with SET ROLE, not ALTER USER command. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 492-493 Chapter 10: Managing Database Use