Correct option is D
DDL (Data Definition Language) is a subset of SQL used to define, create, and delete database objects such as tables, views, and indexes. It includes commands like CREATE, DROP, and ALTER.
Important Key Points:
1. CREATE: Defines new database structures like tables and views.
2. DROP: Deletes objects such as tables and views permanently.
3. ALTER: Modifies the structure of an existing table.
Knowledge Booster:
· Data Mining: Refers to extracting patterns from data, unrelated to SQL commands.
· Data Audit: Ensures the integrity and quality of data.
· Referential Integrity: Ensures consistency in relationships between tables but is not part of DDL.
Important Key Points:
1. CREATE: Defines new database structures like tables and views.
2. DROP: Deletes objects such as tables and views permanently.
3. ALTER: Modifies the structure of an existing table.
Knowledge Booster:
· Data Mining: Refers to extracting patterns from data, unrelated to SQL commands.
· Data Audit: Ensures the integrity and quality of data.
· Referential Integrity: Ensures consistency in relationships between tables but is not part of DDL.