The top level of the hierarchy consists of ________ each of which can contain ________.

Asked In: BPSC TRE 3.0

Options

  • A. schemas, catalogs
  • B. schemas, environment
  • C. catalogs, schemas
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

C. catalogs, schemas

Detailed Explanation

  • Catalog: Represents the top-level grouping in the database hierarchy.
  • Schema: A catalog can contain multiple schemas.
  • Hierarchy: Catalogs contain schemas, and schemas contain database objects such as tables and views.