Exam Prep Questions
|1:||Which data dictionary view would you use to get a list of all tablespaces and their associated data files?
|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 __________________.