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.

agregator gives one to many records or many to one record

1 Answers   IBM,

---

What are data modelling techniques?

0 Answers  

---

What is dbms explain in brief?

0 Answers  

---

Explain about a primary key?

0 Answers  

---

what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me

1 Answers   IBM,

---

Which four data types cannot be used as a return type from a user-defined function?

0 Answers  

---

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

0 Answers  

---

What are the main phases of database development?

0 Answers  

---

What is the difference between a primary index and a secondary index? What is a duplicate data entry in an index? Can a primary index contain duplicates?

5 Answers   IBM,

---

Explain the role of indexing in databases?

0 Answers  

---

What are the three basic rules which are to be followed for the relational model of the database?

0 Answers  

---

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

0 Answers  

---