Yes c only when using the dba role d only when the

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: hen using the DBA role D. Only when the tablespace is online Answer: D Explanation: Answer D is correct. You can drop objects from a read-only tablespace when it is online. Incorrect Answers: 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 QUESTION 69: 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.

Ask a homework question - tutors are online