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

What is the difference between a database and a relational database?

1094

---

Why are sql stored procedures used?

1051

---

what is offset-fetch filter in tsql? : Transact sql

941

---

Which language is used in sql?

1049

---

What is meant by cursor in sql?

984

---

how many columns can be used for creating index? : Sql dba

940

---

Can we use commit inside a trigger?

1080

---

How many types of triggers exist in pl/sql?

1063

---

Does sap use sql?

977

---

What is clustered index sql?

982

---

What is the difference between rename and alias?

1336

---

how can we destroy the cookie? : Sql dba

1007

---

how do you know the version of your mysql server? : Sql dba

1000

---

What is pl/sql table? Why it is used?

1030

---

Can you skip header records while loading? : aql loader

1047

---