What is the use of placing primary key and foreign key
constrains on columns.
Answer Posted / deepak
1) PRIMARY KEY IS USED AS UNIQUE KEY, FOR AVOID DUPLICATION.
2) FOR VALIDATING DATA FROM PRIMARY KEY TABLE FOREIGN KEY USE.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is difference between count (*) and count column?
What are the system database in sql server 2008?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
How do you implement session management in SQL Server mode?
What is the full form of ddl?
Why the trigger fires multiple times in single login?
Explain the types of indexes.
What is subquery? Explain the properties of a subquery?
What is partition, how will you implement it? : sql server analysis services, ssas
What is the difference between left and right outer join?
What are a scheduled jobs or what is a scheduled tasks?
what are constraints? Explain different types of constraints? : Sql server database administration
How exceptions can be handled in sql server programming?
Explain few examples of RDBMS?
Can you get second highest salary from the table?