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 is data stored in dbms?

0 Answers  

---

What is an application role and explain a scenario when you would use one?

0 Answers  

---

How to generate OIDS

0 Answers  

---

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

1 Answers   Flextronics, Hexaware, SQL Star,

---

---

Write the fastest query to find out how many rows exist in a table?

0 Answers  

---

What are defaults? Is there a column to which a default can't be bound?

2 Answers  

---

Explain about the storage and physical database design?

0 Answers  

---

What is an extended stored procedure?

1 Answers  

---

Explain the family trees and connection by clause.

1 Answers  

---

Explain about normal forms?

0 Answers  

---

how will I find the duplicate rows count from employees tablein oracle.

2 Answers  

---