MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Match SQL language with SQL commands1)DDL i)Revok, Grant2)DML ii)rename a table3)TCL iii)insert, update4)DCL iv)rollback, commit
A
1-iii, 2-i, 3-ii, 4-iv
B
1-iii, 2-ii, 3-iv, 4-i
C
1-ii, 2-iii, 3-iv, 4-i
D
1-i, 2-iii, 3-ii, 4-iv
Explanation: 

Detailed explanation-1: -DDL stands for Data Definition Language, which defines the structure or schema of the database. DML, or the Data Manipulation Language, helps us deal with managing and manipulating data in the database. DCL, or the Data Control Language, helps us deal with controls, rights, and permission in the database system.

Detailed explanation-2: -DDL – Data Definition Language. DQL – Data Query Language. DML – Data Manipulation Language. DCL – Data Control Language.

Detailed explanation-3: -Based on functionalities performed by them, there are five types of SQL Commands-DDL(Data Definition Language), DML(Data Manipulation Language), DQL(Data Query Language), TCL(Transaction Control Language), DCL(Data Control Language).

There is 1 question to complete.
Previous
Next