READ Free Dumps For Oracle- 1z0-023
Question ID 8878 | When creating a table, you must place the table in which tablespace?
|
Option A | One that holds temporary segments.
|
Option B | One that has no rollback segments in it.
|
Option C | One that hold the indexes of the table.
|
Option D | One together with other tables of the same user.
|
Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct. All tables for the same user must be placed in the same tablespace. Incorrect Answers: A: Do not put permanent tables into temporary tablespace. B: Do not put any object into rollback tablespace. C: Do not mix data tables and indexes in the one tablespace. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 353-355 Chapter 7: Managing the Physical Database Structure
Question ID 8879 | How do you temporarily revoke a role from a user?
|
Option A | Drop the table.
|
Option B | Disable the role.
|
Option C | Revoke the role from the user.
|
Option D | Remove all privileges from the role.
|
Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct. To revoke temporarily a role from a user, just disable the role. Incorrect Answers: A: Dropping table have nothing to do with revoking a role from a user. C: By revoking the role from the user you will revoke it permanently, not temporarily. D: You don't need to remove all privileges from the role to revoke temporarily a role from a user, just disable role for user. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 492-493 Chapter 10: Managing Database Use