Solution
The correct answer is option (2)
Concept:-
DDL (Data Definition Language) statements are used for creating and defining the Database Schema. For example, CREATE, ALTER, DROP statements.
Key Points
- A database schema is a skeleton structure that represents the database's logical view. A database schema can be created using SQL instructions. DDL, DML, DCL, and TCL are the four subgroups of SQL commands.
- DML (Data Manipulation Language) statements are used for managing data within the database. For example, SELECT, UPDATE, INSERT statements.
- The schema is the database's overarching description. Schema refers to the fundamental structure of how data will be stored in a database. Logical Schema, Physical Schema, and View Schema are the three sorts of schemes.
Additional InformationHTML:- HTML (Hypertext Markup Language) is the coding that organizes a web page's structure and content. Content could be organized using paragraphs, a list of bulleted points, or graphics and data tables, for example.
XML:- XML (Extensible Markup Language) is a markup language that is similar to HTML but does not have any predefined tags. Instead, we create our own tags that are tailored to our specific requirements. This is an effective method of storing data in a format that can be searched, stored, and shared.