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

How to add new employee details in an employee_details table with the following details

1043

---

Is sql scripting language?

973

---

Is primary key a clustered index?

910

---

What are the parts of a sql statement?

1027

---

what is the difference between join and union? : Sql dba

1027

---

Is it possible to pass parameters to triggers?

1029

---

What is difference between sql function and stored procedure?

941

---

Can we use pl sql in mysql?

959

---

Is left join same as inner join?

1020

---

Explain normalization and what are the advantages of it?

890

---

What is dialect in sql?

887

---

How do I install sql?

939

---

What are the types of sql commands?

1018

---

Can delete statement be rollbacked?

930

---

What is the default isolation level in sql server? : Transact sql

961

---