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

0 Answers  

---

How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?

2 Answers   Infosys,

---

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

0 Answers  

---

difference between truncate and delete ,drop?

3 Answers  

---

What is merge statement used for?

0 Answers  

---

When does a Transaction end ?

2 Answers  

---

What is an oracle user role?

0 Answers  

---

What is java oracle used for?

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,

---

What are temporal data types in oracle?

0 Answers  

---

Query to get max and second max in oracle in one query ?

34 Answers   CTS, Keane India Ltd, TCS, Wipro,

---

How to revoke create session privilege from a user in oracle?

0 Answers  

---