Answer / Budheshwar Singh

Oracle Corporation is an American multinational computer technology company that specializes in developing and marketing database software, cloud engineered systems, and enterprise software products.

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

3 Answers   Amazon, HCL,

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

1 Answers   TCS,

---

What do you know about normalization? Explain in detail?

1 Answers  

---

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

2 Answers   IBM,

---

How would you design a database for an e-commerce website?

1 Answers  

---

what is insert all statement in sql

3 Answers   CGI, TCS,

---

7. Repeat query (7) but also display all clients who have never ordered anything.

1 Answers   Wipro,

---

SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.

2 Answers   Cognizant,

---

Can you have more than one content canvas view attached with a window ?

1 Answers   Oracle,

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

1 Answers   IBM,

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

1 Answers   EDC,

---

wirte the syntax of update query?

3 Answers   IBM,

---