Answer / hina khuman

foreginkey is use to have relation between two tables,which
requires primary key in master table and that field can be
use by child table through foregin key.

Answer / jijnasa behera

Foreign key is the primary key of the other table which is
helpful for referential integrity. it is helpful when we
make join to more than one table.

How to combine two function together?

1 Answers  

---

Given an employee table, how would you find out the second highest salary?

9 Answers  

---

How can I detect whether a given connection is blocked?

1 Answers  

---

what is Normalization?

6 Answers   TCS,

---

can you give me the syntax of named procedure??

2 Answers  

---

Explain about normal forms?

1 Answers  

---

Explain the role of indexing in databases?

1 Answers  

---

Can you have a nested transaction?

1 Answers  

---

What is a self join? Explain it with an example?

16 Answers   TCS,

---

Why does this query return 0?

1 Answers  

---

How to replace not in with not exist?

1 Answers  

---

Explain about the hierarchical model of the database?

1 Answers  

---