Data-Dictionary Storage MCQ

Test your knowledge with important Data-Dictionary Storage MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Data-Dictionary Storage MCQs at Bissoy

• An Oracle object type has two parts the _________ and__________
  ক

  Instance and body

  খ

  Segment and blocks

  গ

  Specification and body

  ঘ

  Body and segment
• A data dictionary is created when a __________ created.
  ক

  Instance

  খ

  Segment

  গ

  Database

  ঘ

  Dictionary
• An Oracle __________ is a set of tables and views that are used as a read-only reference about the database.
  ক

  Database dictionary

  খ

  Dictionary table

  গ

  Data dictionary

  ঘ

  Dictionary
• ________ is the smallest unit of allocation in an Oracle database.
  ক

  Database

  খ

  Instance

  গ

  Tablespace

  ঘ

  Database Block
• __________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth.
  ক

  Tablespace

  খ

  Segment

  গ

  Extent

  ঘ

  Block
• A tablespace is further broken down into ________
  ক

  Tablespace

  খ

  Segments

  গ

  Extents

  ঘ

  Blocks
• A ________ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.
  ক

  Tablespace

  খ

  Segments

  গ

  Extents

  ঘ

  Blocks
• ___________ is the collection of memory structures and Oracle background processes that operates against an Oracle database.
  ক

  Database

  খ

  Instance

  গ

  Tablespace

  ঘ

  Segment
• Relational schemas and other metadata about relations are stored in a structure called the ____________
  ক

  Metadata

  খ

  Catalog

  গ

  Log

  ঘ

  Data Dictionary
• A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called
  ক

  Metadata

  খ

  Catalog

  গ

  Log

  ঘ

  Dictionary