Answer Posted / lak

SELECT fn1,fn2,fn3 BULK COLLECT INTO t3 FROM tname;

FORALL i IN 1 .. t3.COUNT
INSERT INTO tname1 VALUES T3(i);

What is cold backup, hot backup, warm backup recovery?

467

---

How does a database partition work?

509

---

What is variable dbms?

526

---

What do you understand by clause in sql?

524

---

What is a string in database?

479

---

---

Why is the use of dbms recommended? Explain by listing some of its major advantages.

1239

---

Can you explain insert, update and delete query?

530

---

does pl/sql support “overloading”? Explain

552

---

What is a clustered database?

496

---

What are the various types of relationships in database? Define them.

465

---

What is tabular form?

537

---

What is 3nf in dbms?

491

---

What is index hunting?

738

---

What is the difference between horizontal and vertical partitioning?

541

---

What is the importance of a database?

478

---