What is the use of placing primary key and foreign key
constrains on columns.

Answer Posted / monal

TO CREATE REFERENTIAL INTEGRITY BETWEEN 2 TABLE.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the functionalities that views support?

701


What is the command to change the recovery model?

573


Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

591


Why do we need normalization?

505


List some major differences between triggers and stored procedures?

528






Can a synonym name of a table be used instead of a table name in a select statement?

585


How to create and drop temp table in sql server?

593


What is normalization and its types?

546


What are the advantages to use stored procedures?

580


Explain what are various ways to enhance the ssrs report?

582


Why would you use sql agent?

740


What is the need for indexing?

504


List out the differences between the clustered index and non-clustered index in sql server?

510


What is difference between equi join and inner join?

486


Explain how would you store your query in an SSRS report or a Database server?

90