Answer Posted / 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 |
Post New Answer View All Answers
what is 'mysqlimport'? : Sql dba
What is primary key secondary key alternate key candidate key?
Where is sql database stored?
Does sql backup shrink transaction log?
How do you define a foreign key?
Explain autonomous transaction.
What is the use of double ampersand (&&) in sql queries? Give an example
what is the functionality of the function htmlentities? : Sql dba
Why do we use sql constraints?
What is offset and limit in sql?
What is the difference between rename and alias?
Explain table and field in sql?
What is sql indexing?
Why use truncate instead of delete?
What are triggers and its uses?
