What are the types of SQL Statement?

Question Posted / guest

3 Answers
21041 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are the types of SQL Statement?..

Answer / swapnareddy

Type of sql statments are:
DDL:Data Defintion Language:create,alter,drop,truncate & rename
DML:Data Manipulation Language:insert,update,delete & merge
DRL/DQL:Data retrive/query Language:select
DCL:Data Contol Language:grant,revoke
DTL:Data Transition Language:commit,savepoint & rollback

Is This Answer Correct ?

55 Yes

9 No

What are the types of SQL Statement?..

Answer / sam kolta

SQL statements are classified into 6 categories:
1. Data Definition Language (DDL) Statements are:
- ALTER
- ANALYZE
- ASSOCIATE STATISTICS
- AUDIT
- COMMENT
- CREATE
- DISASSOCIATE STATISTICS
- DROP
- FLASHBACK
- GRANT
- NOAUDIT
- PURGE
- RENAME
- REVOKE
- TRUNCATE
- UNDROP
2. Data Manipulation Language (DML) statements are:
- CALL
- DELETE
- EXPLAIN PLAN
- INSERT
- LOCK TABLE
- MERGE
- SELECT
- UPDATE
3. Transaction Control Language (TCL) statements are:
- COMMIT
- ROLLBACK
- SAVEPOINT
- SET TRANSACTION
4. Session Control Language (SSCL) statements are:
- ALTER SESSION
- SET ROLE
5. System Control Language (SCL) Statements are:
- ALTER SYSTEM

6. EMBEDED SQL STATEMENTS

Is This Answer Correct ?

26 Yes

9 No

What are the types of SQL Statement?..

Answer / anil_abbireddy

DDL :data definition language
DML :data manuplation language
DCL :data control language
TCL :transaction control language
SCL :session control language

Is This Answer Correct ?

22 Yes

15 No

Post New Answer

More SQL PLSQL Interview Questions

How to find only %th Highest Sal

6 Answers Infogain, Symphony,

How many types of tables are there?

0 Answers

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers Sonata,

Which function is used to return remainder in a division operator in sql?

0 Answers

Why we use cross join?

0 Answers

How sql query is executed?

0 Answers

How do I access sql anywhere database?

0 Answers

How to run sql commands in sql*plus?

0 Answers

What are the differences between implicit and explicit cursors?