Answer Posted / shweta

1 exclusive and any number of shared ones.

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

1091

---

What is an oracle wallet?

988

---

What is a read write transaction in oracle?

1131

---

what are the default admin accounts in Oracle 10g ?

1021

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2385

---

What is a trace file and how is it created in oracle?

1144

---

Explain cascading triggers.

1121

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

2054

---

How to retrieve data from an explicit cursor?

1107

---

What do you mean by merge in oracle?

1029

---

how the indexes are stored in the Oracle Database?

2333

---

What is bulk load in oracle?

1125

---

What are the different windows events activated at runtime ?

2945

---

Explain the use of inctype option in exp command.

1081

---

Compare and contrast between sql and sql server and explain its various functions?

1017

---