What is recovery manager(rman) backup in Oracle?

0 Answers   MCN Solutions,

---

What are the most common interview questions on ETL Testing for experience?

0 Answers  

---

What is an UTL_FILE.What are different procedures and functions associated with it?

1 Answers  

---

What is the maximum number of triggers that can be applied to a single table?

0 Answers  

---

What is the disadvantage of User defind function?

0 Answers   CybAge,

---

what is load balancing and what u have used to do this?(sql loader)

3 Answers  

---

What is save point in oracle database?

0 Answers  

---

I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it

2 Answers  

---

Explain about integrity constraint?

0 Answers  

---

Describe the different type of Integrity Constraints supported by ORACLE ?

2 Answers  

---

Explain the use of owner option in exp command.

0 Answers  

---

What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?

1 Answers   HDFC,

---