Answer Posted / arun balaji.n

schema is collection of objects and its overall design of
database.

is there a tool to trace queries, like profiler for sql server?

1139

---

What privilege is needed for a user to create views in oracle?

1042

---

How do you tell what your machine name is and what is its IP address?

2094

---

What are the types of trigger in oracle?

974

---

What is the oracle implicit cursor?

1058

---

What is index-organized table in Oracle?

1067

---

What is the difference between hot backup and cold backup in oracle?

1008

---

Can we call procedure inside function in oracle?

1082

---

Briefly explain what is literal? Give an example where it can be used?

1026

---

What are the original export and import utilities?

1164

---

How to define an explicit cursor in oracle?

1034

---

Explain an index segment?

1116

---

Explain coalesce function?

1201

---

How to convert times to characters in oracle?

1025

---

How to define a specific record type?

1084

---