This preview shows page 1. Sign up to view the full content.
Unformatted text preview: hen using the DBA role
D. Only when the tablespace is online
Answer D is correct. You can drop objects from a read-only tablespace when it is online.
A: You can drop objects from a read-only tablespace if it's online.
B: Answer is correct only if tablespace is online.
C: Not only user with DBA role can drop objects from a read-only tablespace.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 340-341
Chapter 7: Managing the Physical Database Structure
You are responsible for managing disk space used for large sort operations. You are
willing to allocate this space as needed and not de-allocate until the database is shutdown.
You would like to reduce contention on data dictionary tables when this space is allocated.
Where possible, you would like to avoid the overhead of generating rollback information
when this space is allocated. What kind of tablespace is appropriate?
A. A locally-managed temporary tablespace.
B. A locally-...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09