Which of the following is used to create a database schema?

Correct option is B

The Data Definition Language (DDL) is used to create, modify, and delete database schemas and objects such as tables, indexes, and constraints. It forms the foundation of database structure and organization.
Information Booster
1. Data Definition Language (DDL): DDL commands define and manage the structure of the database. Common DDL commands include:
· CREATE: Used to create a database schema or objects like tables, views, and indexes.
· ALTER: Used to modify an existing schema.
· DROP: Used to delete schema objects.
2. Example of a DDL Command:

This command defines the structure of the "Students" table.
Additional Knowledge
· Schema: Logical structure that defines the organization of data, including tables, columns, and relationships.
· DDL Execution: Changes made by DDL commands are automatically committed, meaning they are permanently saved to the database.
· DML (Data Manipulation Language):
· Used for querying and manipulating data in a database.
· Commands include SELECT, INSERT, UPDATE, and DELETE.
· DML operates on the data within the schema but does not define the schema itself.
· HTML (HyperText Markup Language):
· Used for structuring and presenting content on the web.
· Not related to database schema creation.
· XML (eXtensible Markup Language):
· A markup language used for storing and transporting data.
· While XML can represent data structures, it is not used to define database schemas.