Answer Posted / rajesh chadalawada

Statspack is an performance evaluation report used for
verifing load on the server,SGA utilization,wait events and
resource consuming SQL

How to store pictures on to the database?

526

---

How to drop an existing view in oracle?

562

---

What is a trigger and what are its types in oracle?

532

---

Explain oracle’s server parameter file.

564

---

What is a directory object?

587

---

---

What is enter substitution variable in oracle?

570

---

How do we create privileges in oracle?

582

---

What is hot backup and logical backup?

604

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4013

---

What is a static data dictionary in oracle?

564

---

Point the difference between translate and replace?

570

---

Is rowid unique in oracle?

523

---

 How to use an oracle sequence generator in a mapping?

563

---

What is SQL access advisor in Oracle?

628

---

What are the differences between char and varchar2 in oracle?

559

---