Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)

Exam Prep Questions

1:	Which data dictionary view would you use to get a list of all tablespaces and their associated data files? A. DBA_TABLESPACES B. DBA_DATA_FILES C. DBA_SEGMENTS D. DBA_EXTENTS
A1:	Answer B is correct. DBA_DATA_FILES gives you the TABLESPACE_NAME and its associated FILE_NAME as well as the numbers of bytes and blocks in the file and other useful information. Answer A is incorrect because DBA_TABLESPACES gives you the TABLESPACE_NAME but not the filenames associated with it. Answer C is incorrect because it gives you segment information, and answer D is incorrect because it gives you extent information but not tablespace or data file information.
2:	Extents are collections of __________________. A. Database blocks B. Tablespaces ...