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 ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.