using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

4 Answers   Fidelity,

---

In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 Answers  

---

How will you a activate/deactivate integrity constraints?

2 Answers  

---

How can you load multi line records? : aql loader

0 Answers  

---

State the advatage and disadvantage of Cursor's?

2 Answers  

---

---

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

12 Answers   Oracle,

---

Can a procedure in a package be overloaded?

0 Answers   EXL,

---

What are primary key and foreign key and how they work?

0 Answers  

---

Is sql a case sensitive language?

0 Answers  

---

which tcp/ip port does sql server run on? : Sql dba

0 Answers  

---

What is a sql select statement?

0 Answers  

---

What are packages in pl sql and also explain its advantages?

0 Answers  

---