Several objects were stored in the datafile some but

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: s were stored in the datafile. Some, but not all of the objects were dropped subsequently. To which point will you be able to decrease the size of the datafile? A. To zero. B. To the size of the datafile header. C. To the last block of the last object. D. It is not possible to decrease the size of the datafile. Answer: C Actualtests.com - The Power of Knowing 1Z0-023 Explanation: Answer C is correct. You can decrease the size of the datafile only to the highwatermark level: to the last block of the last object. Incorrect Answers: A: You cannot decrease size to zero, because not all of the objects were dropped subsequently. B: You cannot decrease size to the size of the datafile header, only to the highwatermark level. D: It's possible to decrease the size of the datafile using command ALTER TABLESPACE. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 353-355 Chapter 7: Managing the Physical Database Structure QUESTION 72: The database is the highest-level structure in the hierarchy. Arrange the logic...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online