Couchman p 531 534 chapter 7 managing the physical

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: Managing the Physical Database Structure QUESTION 92: Which two data dictionary views display information about direct load in SQL*Loader in a tablespace? (Choose two) A. DBA_TABLES B. DBA_EXTENTS C. DBA_TABLESPACE D. DBA_FREE_SPACE E. DBA_SPACE_USAGE Answer: B, D Explanation: Answers B and D are correct. DBA_EXTENTS and DBA_FREE_SPACE can be used to monitor changes in a tablespace during direct data load. Incorrect Answers: A: DBA_TABLES view provides only information about tables. C: DBA_TABLESPACES view shows the default storage settings for the tablespaces in the database. It will not show changes happened during direct load. E: There is no DBA_SPACE_USAGE view in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 531-534 Chapter 7: Managing the Physical Database Structure QUESTION 93: - The Power of Knowing 1Z0-023 The table should be _____ and _______ used to allow usage of the CACHE clause. A. Big, rarely B. Small, rarely C. Big, frequently D. Small, frequent...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online