1.

What Are The Types Of Sql Statement?

Answer»

Data Definition LANGUAGE: CREATE, ALTER, DROP, TRUNCATE, REVOKE, NO AUDIT & COMMIT.
Data Manipulation Language: INSERT, UPDATE, DELETE, LOCK TABLE, EXPLAIN PLAN & SELECT.

Transactional CONTROL: COMMIT & ROLLBACK.

Session Control: ALTERSESSION & SET ROLE.

SYSTEM Control: ALTER SYSTEM.

Data Definition Language: CREATE, ALTER, DROP, TRUNCATE, REVOKE, NO AUDIT & COMMIT.
Data Manipulation Language: INSERT, UPDATE, DELETE, LOCK TABLE, EXPLAIN PLAN & SELECT.

Transactional Control: COMMIT & ROLLBACK.

Session Control: ALTERSESSION & SET ROLE.

System Control: ALTER SYSTEM.


Discussion

No Comment Found

Related InterviewSolutions