engineering computer science MCQ #783

What is the difference between a database schema and a database instance?

engineering computer science MCQ #783

  1. Question 1

    Q1. What is the difference between a database schema and a database instance?

    • A) Schema is the structure, instance is the data
    • B) Schema is the data, instance is the structure
    • C) Schema is used for data security, instance is used for query performance
    • D) Schema is used for query performance, instance is used for data security

    Answer: Schema is the structure, instance is the data

    Explanation: A database schema defines the structure of the database, while a database instance is a snapshot of the data at a particular point in time.