Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

0 Answers  

---

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 Answers   IBM, TCS,

---

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

---

Can we use out parameter in function?

4 Answers   Infosys,

---

Is pl sql useful?

0 Answers  

---

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

---

What is the sql case statement?

0 Answers  

---

Explain the steps needed to create the scheduled job?

0 Answers  

---

Mention what is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  

---

Why do we use function in pl sql?

0 Answers  

---

How bulk collect improves performance?

0 Answers  

---

What is a schema? How is it useful in sql servers?

0 Answers  

---