What is Primary key and foreign key? Give an example
- 4 Answers
- 10019 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / brajesh kumar srivastava
Primary key enforce uniqueness of column and deny to allow
null values to this column and enforce referential data
integrity constraint to other table column which is call
foreign key.
Foreign key column may contain null value
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are different types of constraints?
How can we solve concurrency problems?
How do I start sql server 2017?
How can I check that whether automatic statistic update is enabled or not?
What is self contained sub query?
Can sql servers link to other servers like oracle?
When should you use an instead of trigger?
what is the difference between openrowset and openquery?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Why we use the openxml clause?
How can you append an identity column to a temporary table?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is normalization and what are the advantages of it?
Explain “row_number()” in sql server with an example?
