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 hot backup (in case of oracle)?

473

---

What is hashing in dbms?

553

---

What is management system in dbms?

498

---

What is a system concept?

493

---

Mention the differences between union and union all

493

---

---

What do you understand by proactive, retroactive and simultaneous update?

743

---

How do databases help businesses?

465

---

what are the different integrity rules present in the dbms?

490

---

What is index hunting?

734

---

What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?

466

---

What is db driver?

484

---

Which two statements are true about a foreign key?

515

---

What is normalisation and its type?

538

---

Explain 2nf?

525

---

What is the difference between internal and external schema?

440

---