Database contain a relation student if DROP TABLE student is used to remove…
2023
Database contain a relation student if DROP TABLE student is used to remove the student relation from the database then the used SQL statement is example of:
- A.
Data Definition Language
- B.
Data Manipulation Language
- C.
Data Control Language
- D.
Transaction Control Language
Attempted by 788 students.
Show answer & explanation
Correct answer: A
Ans : A
Solution
A database system provides a data-definition language (DDL) to specify the database schema
Example of DDL commands: CREATE, DROP etc.
A data-manipulation language (DML) is a language that enables users to access or manipulate data as organized by the appropriate model
Example of DML commands: INSERT, DELETE etc.
A data control language (DCL) is used to control access (Authorization) to data stored in a database
Example of DCL commands: GRANT and REVOKE
A transaction control language (TCL) is used to control transactional processing in a database
Example of TCL commands: COMMIT, SAVEPOINT etc.