What is Primary key and foreign key? Give an example
Answer Posted / vipin
Primary key which enforce the uniqueness in each row og table .
Foreign key win which the existing value in table must be there in other table .
diffrence is that PK does not allow Null Values anf FK allow null values
| Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
What is inline table-value user-defined function?
What is a join in sql? What are the types of joins?
What is a dataset and what are the different types of datasets?
What is a schema in ms sql server 2005?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What is GUID in sql server?
How to maintain a fill factor in existing indexes?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What methods do you follow to protect from sql injection attack?
What is unpivot?
What is built-in function?
Difference between report and query parameter. Why do we need different type of parameter?
What is advantage data architect?
What is meant by indexing files?
Explain having clause?