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

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

Answer / anil_abbireddy

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

What is normalization ?

9 Answers   BirlaSoft, CTS, HCL,

---

What is on delete restrict?

0 Answers  

---

What are the types of functions in sql?

0 Answers  

---

How do you copy a table in sql?

0 Answers  

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

how can we find the select statement is indexed or not?

3 Answers   CTS,

---

can i use global variables in stored procedure or function

1 Answers   L&T,

---

Is delete faster than truncate?

0 Answers  

---

How you will create Toad Function?

1 Answers  

---

What is a sql select statement?

0 Answers  

---

What is the difference between alter trigger and drop trigger statements?

0 Answers  

---

Enlist the advantages of sql.

0 Answers  

---