Midterm Prep

Question 1

SQL sublanguages

Answer 1

DDL – Data Definition Language.
DML – Data Manipulation Language.
DRL/DQL – Data Retrieval Language/Data Query Language.
TCL – Transaction Query Language.
DCL – Data Control Language.
SCL – Session Control Language.

Question 2

DDL-Data Definition Language

Answer 2

– Used to define Database objects like TABLE,VIEW,SEQUENCE,INDEX,SYNONYM creation or modification or removing.
–CREATE,ALTER,DROP,TRUNCATE,RENAME are the DDL commands

Question 3

DML – Data Manipulation Language

Answer 3

• Used to manipulate the data in Database objects like table, view, index ..etc,.
• INSERT, UPDATE, DELETE are the DML commands.

Question 4

DRL/DQL-Data Retrieval Language/Data Query Language

Answer 4

-used to retrieve information from the database objects. it is for read only purpose.
– SELECT is the DQL or DRL command.

Question 5

TCL – Transaction Control Language

Answer 5

• Transaction control statement are use to apply the changes permanently save into database.
• COMMIT, ROLLBACK, SAVEPOINT, ROLLBACK TO are the TCL commands.

Question 6

DCL – Data Control Language

Answer 6

Data control statements are use to give privileges to access limited data or share the information between users.
-GRANT,REVOKE ,AUDIT,COMMENT, ANALYZE are the DCL commands.

Question 7

SCL- Session Control Language

Answer 7

Session control statement are manage properties dynamically of a user session.
-ALTER SESSION,SET ROLL are the SCL commands.