Answer Posted / krish

triggers of 4 types
1.row & statement triggers
2.before & after triggers
3.instead of triggers
4.trigger on system event & user event

List out the acid properties and explain?

563

---

How to add, remove, modify users using sql?

563

---

What is the mutating table and constraining table?

563

---

What are the types of join and explain each?

582

---

How to install oracle sql developer?

571

---

---

What is dml statement?

519

---

Why query optimization is needed?

521

---

Can you select everything, but 1 or 2 fields, without writer's cramp?

500

---

Does execute immediate commit?

700

---

What do you understand by pl/sql packages?

573

---

What are the dml statements?

689

---

What are the types of operators available in sql?

554

---

What are the ddl commands?

539

---

How many commands are there in sql?

551

---

What are the possible values for the boolean data field?

527

---