what are primary key and foreign key ?

Answer Posted / neo devan

Primary key is the attribute which satisfies both
uniqueness and Not null constraints.
The foreign key is a attribute that points to a valid
column in a parent table.
its used for referencing primary key.

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by clause in sql?

528


What are the main characteristics of database approach?

504


Is there a way to detect whether fbclient.dll or fbembed.dll is loaded?

510


What do you understand by query optimization?

509


How do you start a database?

489






What do you understand by data independence? What are its two types?

623


How to export data from database and import into another?

465


What is data model in database?

477


Which database is best for storing large data?

455


1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?

1344


How to load a file into database column?

521


What is the difference between delete and truncate command in dbms?

495


What is network database?

522


What is netlib for clipper?

507


Operators used in select statements are?

491