Topic : Data Dictionary

When are the base tables of the data dictionary created?


  • When the instance is created
  • When the database is created
  • When the catalog.sql script is executed
  • When the catproc.sql script is executed

Answer :

When the database is created

Show Answer Discuss

Which data dictionary view would you query to retrieve a table's header block number?


  • DBA_TABLE
  • DBA_TABLES
  • DBA_OBJECT
  • DBA_OBJECTS
  • DBA_SEGMENT
  • DBA_SEGMENTS

Answer :

DBA_SEGMENTS

Show Answer Discuss

Which of the following three portions of a data block are collectively called as Overhead?


  • Table directory; row directory and row data
  • Data block header; table diretory and free space
  • Table directory; row directory and data block header
  • Data block header; row data and row header

Answer :

Table directory; row directory and data block header

Show Answer Discuss