5
Structured Query Language
1. What is SQL? What are the two major categories of SQL commands? Explain them.
Ans: SQL stands for structured query language. It is a language that can be used for retrieval and management of data stored in relational database. It is a non-procedural language as it specifies what is to be retrieved rather than how to retrieve it. It can be used for defining the structure of data, modifying data in the database and specifying the security constraints.
The two major categories of SQL commands are Data Definition Language (DDL) and Data Manipulation Language (DML). DDL provides commands that can be used to create, modify and delete database objects. DML provides commands that can be used to access and manipulate ...
Get Express Learning: Database Management Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
