Database Architecture   «Prev  Next»

Tables and Datafiles - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. You are connected to an open PDB and have permission to query the following views. Which two SELECT statements list the names of its datafiles, excluding temporary tablespace files?
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. While inspecting an open PDB, you query V$DATAFILE. What does SYSTEM in the STATUS column indicate?
Please select the best answer.
  A. The datafile belongs to the SYSTEM tablespace, which must be online for the PDB to remain open.
  B. The datafile belongs to the SYSTEM tablespace and is offline.
  C. The datafile stores temporary query work areas.
  D. The operating system manages the datafile without Oracle involvement.

3. Which statement best describes an Oracle tablespace?
Please select the best answer.
  A. A physical file that can store only table rows.
  B. A logical storage container for segments, backed by datafiles or tempfiles according to its type.
  C. Unused space within a table reserved for operating system files.
  D. A subdivision of a datafile, with each datafile containing several tablespaces.

4. Which view directly provides both datafile names and their corresponding tablespace names for the current container, excluding tempfiles?
Please select the best answer.
  A. V$TABLESPACE
  B. DBA_DATA_FILES
  C. DBA_TABLESPACES
  D. V$DATAFILE

5. You need to list tempfile names and their temporary tablespace names in the current PDB. Which query should you use?
Please select the best answer.
  A. SELECT tablespace_name, file_name FROM dba_data_files;
  B. SELECT tablespace_name, file_name FROM dba_temp_files;
  C. SELECT tablespace_name, file_name FROM dba_tablespaces;
  D. SELECT tablespace_name, file_name FROM user_tables;