1.

Explain the DDL (Data Definition Language), DML (Data Manipulation Language) and DCL (Data Control Language) statements in SQL.

Answer»
  • DDL: The Data Definition Language is a set of SQL queries that are used to specify the database and schema structure, such as CREATE, ALTER, TRUNCATE, DROP, and RENAME.
  • DCL: The Data Control Language is a set of SQL INSTRUCTIONS that are used to control USER access to the database. It INCLUDES operations like GRANT and REVOKE.
  • DML: Data Manipulation Language is used to manage data using SQL queries such as SELECT, INSERT, DELETE, and UPDATE.


Discussion

No Comment Found

Related InterviewSolutions