D there is no creator column in the dbaobjects table

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: acle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 401 Chapter 8: Managing Database Objects I QUESTION 123: When creating a table, you must place the table in which tablespace? Actualtests.com - The Power of Knowing 1Z0-023 A. One that holds temporary segments. B. One that has no rollback segments in it. C. One that hold the indexes of the table. D. One together with other tables of the same user. Answer: D 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 124: How do you temporarily revoke a role from a user? A. Drop the table. B. Disable the role. C. Revoke the role from the user. D. Remove all privileges from...
View Full Document

Ask a homework question - tutors are online