Answer Posted / rao

Normalization is process for reducing the redency of the
data.there 5 normal forms mainly used in 3 forms
4th one boyesscoded normal form

Why is stored procedure faster than query?

498

---

What is the primary use of normalization?

533

---

What is the use of sqlerrd 3?

529

---

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

598

---

How long does it take to learn pl sql?

614

---

---

what is the difference between a local and a global temporary table? : Sql dba

560

---

What is substitution variable?

589

---

How can get second highest salary in sql?

513

---

explain the difference between myisam static and myisam dynamic. : Sql dba

520

---

What is a .db file?

546

---

What is normalization? How many normalization forms are there?

562

---

What are the advantages of stored procedure?

547

---

Can delete statement be rollbacked?

531

---

Explain select statements in sql?

595

---

What is sql query limit?

512

---