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
Explain the functionalities that views support?
What is the command to change the recovery model?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
Why do we need normalization?
List some major differences between triggers and stored procedures?
Can a synonym name of a table be used instead of a table name in a select statement?
How to create and drop temp table in sql server?
What is normalization and its types?
What are the advantages to use stored procedures?
Explain what are various ways to enhance the ssrs report?
Why would you use sql agent?
What is the need for indexing?
List out the differences between the clustered index and non-clustered index in sql server?
What is difference between equi join and inner join?
Explain how would you store your query in an SSRS report or a Database server?