Answer Posted / reddy hanuma kishore

A pointer is a variable that stores the addrss of another
variable.

What is the difference between count (*), count (expression), count (distinct expression)?

550

---

What are the set operators union, union all, minus & intersect meant to do?

554

---

Explain mutating triggers.

563

---

What is recovery manager(rman) backup in Oracle?

616

---

What is a nvl function?

557

---

---

What is parameterized cursor in oracle?

566

---

Will you be able to store pictures in the database?

629

---

What is a static data dictionary in oracle?

559

---

What are the uses of linked server and explain it in detail?

580

---

How to invoke the data pump export utility?

554

---

What are the different types of modules in oracle forms?

546

---

Explain the difference between sql and oracle?

574

---

What are the advantages of oracle 12c?

548

---

Explain the use of parfile option in exp command.

511

---

How many types of tables supported by oracle?

570

---