What is a database schema? MCQ with Answer and Explanation

What is a database schema?
A. A single table
B. The overall design or structure of the database, including tables, columns, and relationships
C. A query result
D. A backup file
Answer: Option B
Solution (By JKExamLibrary)
A schema is the logical description of the entire database, defining tables, views, indexes, and constraints.

This question belongs to: Computer Database Management System (DBMS)

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1 Report Error
A Primary Key in RDBMS must be:
A. Can have null values
B. Unique and not null
C. Always a foreign key
D. Duplicate values allowed

Correct Answer: Option B


Explanation:
A primary key uniquely identifies each record and cannot contain null values.

This question belongs to: Computer Database Management System (DBMS)
Question #2 Report Error
What value represents missing, unknown, or inapplicable data in a relational database?
A. Zero (0)
B. Blank Space (' ')
C. Void
D. NULL

Correct Answer: Option D


Explanation:
NULL is a special marker used in SQL to indicate the absence of a value or that the data is missing, unknown, or not applicable.

This question belongs to: Computer Database Management System (DBMS)
Question #3 Report Error
What does a database constraint called a 'CHECK' constraint do?
A. It automatically links tables together.
B. It verifies user authentication passwords.
C. It limits the range of values that can be placed in a column based on a specific condition.
D. It checks if the database server is running safely.

Correct Answer: Option C


Explanation:
A CHECK constraint enforces domain integrity by limiting the values accepted by a column to only those that satisfy a specified Boolean predicate.

This question belongs to: Computer Database Management System (DBMS)