Interview Question

What is database schema?

A schema names and organizes related database objects.

💡 Concept ✅ Quick Revision 🗃️ SQL

Answer

A database schema is a named namespace that contains database objects. • Schemas can contain tables, views, functions, and other objects. • The same object name can exist in different schemas. • A qualified name such as sales.orders identifies both schema and object.

💡 SQL Example

CREATE SCHEMA sales;

Result

CREATE SCHEMA

⚡ Quick Revision

A schema names and organizes related database objects.