Answer Posted / sohail

Normalization is a rule applied on the database table in
order to remove redundancy of data.

what is sub-query? : Transact sql

837

---

Do we need commit after truncate?

811

---

How can triggers be used for the table auditing?

750

---

what are the differences among rownum, rank and dense_rank? : Sql dba

735

---

What is difference between db2 and sql?

721

---

---

How run sql*plus commands that are stored in a local file?

711

---

How do you delete duplicates in sql query using rowid?

720

---

How do I view tables in mysql?

720

---

What is the maximum number of triggers, you can apply on a single table?

732

---

what is the different between now() and current_date()? : Sql dba

701

---

What is scope of pl sql developer in future?

744

---

what is bdb (berkeleydb)? : Sql dba

751

---

What is recursive join in sql?

752

---

What are inner and outer joins examples of both?

691

---

Which join condition can be specified using on clause?

702

---