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 char_length and length? : Sql dba

1050

---

Is left join same as join?

999

---

What is sql in oracle?

1068

---

How to place comments in pl/sql?

1168

---

What is number function in sql?

980

---

Is pl sql different from sql?

1005

---

How do you bind variables in pl sql?

1104

---

What is sequence in sql?

1030

---

What is the purpose of a secondary key?

979

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2021

---

How do I turn a list into a table?

964

---

Can we rollback after truncate?

1035

---

What is a ddl command?

1093

---

How many disk partitions should I have?

991

---

Why do we need sharding?

1001

---