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 are the different types of tables in sql?

1063

---

What is %type in pl sql?

1008

---

Where not exists in sql?

1032

---

how to use regular expression in pattern match conditions? : Sql dba

1086

---

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1072

---

What does subquery mean in sql?

1112

---

How does pl sql work?

1005

---

What is the difference between a subquery and a join?

1170

---

what is try_catch block in procedure

1808

---

Explain ddl statements in pl/sql?

1051

---

What is a temp table?

1072

---

Explain the structure of pl/sql in brief.

1138

---

Is sql microsoft?

1105

---

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

1044

---

what are the 'mysql' command line arguments? : Sql dba

1190

---