What are the components of logical database structure in oracle database?

0 Answers  

---

What is difference between Rename and Alias?

1 Answers  

---

What are the differences between a sys and system user and what are the extra privileges available to the sys user?

1 Answers   Wipro,

---

How to select the name of employee who is getting maximum sal with out using subquery

15 Answers  

---

Explain an integrity constrains?

0 Answers  

---

---

Write a trigger example in oracle?

0 Answers  

---

When can Hash Cluster used ?

1 Answers  

---

Explain the concept of the DUAL table.

2 Answers  

---

What is use of oracle?

2 Answers   Satyam,

---

Explain the difference between a procedure and a function?

0 Answers  

---

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.

0 Answers   IBM,

---

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

1 Answers   Wipro,

---