Answer Posted / kotravel. b

1 inpilicite cursors
2 expilicite cursors

What is the main reason behind using an index?

562

---

How does rowid help in running a query faster?

978

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

548

---

How do I run a sql trace?

534

---

What is denormalization in a database?

601

---

---

What is a system versioned table?

546

---

What does <> sql mean?

548

---

What is db journal file?

528

---

what is sql? : Sql dba

566

---

what is the difference between undefined value and null value? : Sql dba

574

---

Is sql harder than python?

619

---

What is union and union all keyword in sql and what are their differences?

590

---

what is the difference between truncate and delete statement? : Transact sql

560

---

What are the advantages of normalization?

565

---

what is sp_pkeys? : Transact sql

713

---