Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What are the types of SQL Statement?

Question Posted / guest

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

What is sql profiler in oracle?

0 Answers  

What is application trigger?

0 Answers  

Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?

3 Answers  

What is the difference between microsoft sql and mysql?

0 Answers  

table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  

How show all rows in sql?

0 Answers  

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

0 Answers  

Can we write dml inside a function in sql server?

0 Answers  

How do I count records in sql?

0 Answers  

What is the difference between local variables and global variables?

0 Answers  

What is a pragma statement?

0 Answers  

How to execute a stored procedure?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories