Database Architecture   «Prev  Next»

Tables and Datafiles - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Which two SELECT statements will give you a list of all the datafiles in your database?
Please select all the correct answers.
  A. SELECT file_name FROM dba_data_files;
  B. SELECT file_name FROM dba_ v$datafile;
  C. SELECT name FROM v$datafile_files;
  D. SELECT name FROM v$datafile;

2. Why is the status of some datafiles SYSTEM instead of ONLINE or OFFLINE?
Please select the best answer.
  A. The file belongs to the SYSTEM tablespace, and is always online.
  B. The file belongs to the SYSTEM tablespace, and is always offline.
  C. The file belongs to the SYSTEM tablespace, and is neither offline nor online.
  D. The file is currently opened by the operating system, and not by Oracle.

3. What are tablespaces?
Please select the best answer.
  A. Special datafiles used specifically to store table data
  B. A logical construct that Oracle software uses to link tables with the datafiles used to store their data
  C. Extra space within a table that Oracle makes available for use by datafiles
  D. A logical construct that sits inside of a datafile, many of them making up one datafile

4. You need to see a list of tablespaces and their respective datafiles. Which view do you query?
Please select the best answer.
  A. V$TABLESPACE
  B. DBA_DATA_FILES
  C. DBA_TABLESPACES
  D. V$DATAFILE