What are the types of SQL Statement?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
what is the difference between myisam static and myisam dynamic? : Sql dba
Can a table contain multiple foreign key’s?
What is trigger in sql?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
write a query to find 4th max salary
What is Referential Integrity?
What is implicit cursor in pl sql?
What is difference between stored procedures and application procedures?
What are sql functions? Describe the different types of sql functions?
Do view contain data?
what is d diff between grant,commit,rollback n savepoint
What is nested table in pl sql?