READ Free Dumps For Oracle- 1z0-023
| Question ID 8881 | When creating rollback segments, what is considered the value for the OPTIMAL storage parameter?
|
| Option A | 500k
|
| Option B | 10*MINEXTENTS
|
| Option C | Average undo size*4
|
| Option D | This must be calculated by running the longest expected transaction and checking the size of the rollback segment.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct. To calculate the OPTIMAL storage parameter you must use the longest expected transaction, check the size of the rollback segment and use it for OPTIMAL parameter. Incorrect Answers: A: OPTIMAL parameter needs to be calculated, not just set to 500k size. B: This formula does not provide correct size for OPTIMAL parameter. C: This formula does not provide correct size for OPTIMAL parameter. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 374-375 Chapter 8: Managing Database Objects I
| Question ID 8882 | A DBA grants User A the ALTER USER privilege with ADMIN OPTION. User A creates roles and grants the ALTER USER to User B. What will happen to the roles User A created, and also to User B's privileges, if you drop User A with CASCADE option?
|
| Option A | The roles will remain and User B will lose the ALTER USER privilege.
|
| Option B | The roles will remain and User B will not lose the ALTER USER privilege.
|
| Option C | The roles will be removed and User B will lose the ALTER USER privilege.
|
| Option D | The roles will be removed and User B will not lose the ALTER USER privilege.
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct. If you drop User A with CASCADE option, the roles will remain and User B will not lose the ALTER USER privilege. There are no cascading effects when revoking a system privilege related to DDL operations, regardless of whether the privilege was granted with or without the ADMIN OPTION. Cascading effects can be observed when revoking a system privilege related to a DML operation. For example, if SELECT ANY TABLE is granted to a user, and if that user has created any procedures, then all procedures contained in the user's schema must be reauthorized before they can be used again (after the revoke). Incorrect Answers: A: User B will lose the ALTER USER privilege. C: The roles will remain and User B will not lose the ALTER USER privilege. D: The roles will remain. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 485-489 Chapter 10: Managing Database Use