What is the primary purpose of a database schema?

Options

  • A. To define the logical structure of database objects
  • B. To store only backup files
  • C. To execute operating system commands
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

A. To define the logical structure of database objects

Detailed Explanation

  • Database schema: Defines the organization and structure of database objects.
  • It specifies tables, columns, relationships, constraints and other objects.
  • It acts as a blueprint for a database.