What is Primary key and foreign key? Give an example
- 4 Answers
- 10021 Views
- TCS, I also Faced
- E-Mail Answers
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 spatial nonclustered index
What are the kinds of subquery?
Can sql servers link to other servers like oracle?
What is in place upgrade in sql server?
Can we do dml on views?
What are the properties of the transaction?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is sql server query analyzer?
Disadvantages of the indexes?
What is temporary table in sql server? Why we use temp table?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Can we shrink data file in sql server?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is normalization and what are the advantages of it?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
