READ Free Dumps For Oracle- 1z0-023
| Question ID 8817 | When you created a tablespace, you overestimated the size of one of the datafiles. Several objects 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?
|
| Option A | To zero
|
| Option B | To the size of the datafile header.
|
| Option C | To the last block of the last object.
|
| Option D | It is not possible to decrease the size of the datafile.
|
| Correct Answer | C |
Explanation Explanation/Reference: 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 ID 8818 | Be default, a tablespace is _________ -managed and can contain_____
|
| Option A | Locally; only permanent segments.
|
| Option B | Dictionary; only data dictionary information.
|
| Option C | Locally; both permanent and temporary segments.
|
| Option D | Dictionary; both permanent and temporary segments.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct. Tablespace is dictionary-managed and can contain both permanent and temporary segments. Incorrect Answers: A: Tablespace is dictionary-managed, not locally-managed by default. B: By default tablespace can contain not only data dictionary information. C: Tablespace is dictionary-managed, not locally-managed by default. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 345-355 Chapter 7: Managing the Physical Database Structure