SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 586 Page Views: 

When a table is create with a Primary Key, then what sort of integrity is maintained?



Posted By: Avi Date: 1 October 2010 12:27:08 PM
 Answer:

Entity Integrity. As it defines the row as a unique entity for a particular table which is forced by using Unique Constraint,Primary Key or Identity Property.


Posted By: avibtech

Date: 1 October 2010 12:27:08 PM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image r2TxeG
Related Questions
SQL Server : What is the purpose of SET NOCOUNT ON?

What is the purpose of SET NOCOUNT ON?

Whenever a Select Statement or any DML Statement is executed the server return a value that is the n....
Category: SQL Server Date: 10/1/2010 12:07:08 PM
SQL Server : What are distributed Queries?

What are distributed Queries?

Distributed Queries are the queries which can access multiple hetrogeneous data from different sourc....
Category: SQL Server Date: 10/1/2010 12:06:08 PM
SQL Server : When do the database checkpoints occur?

When do the database checkpoints occur?

Check point will occur in the following cases:- 1. It can be added manually . The Syntax is:- CHEC....
Category: SQL Server Date: 10/1/2010 12:05:08 PM
SQL Server : What is the purpose of the checkpoint?

What is the purpose of the checkpoint?

Whenever an operation is performed in SQL Server it is not committed directly to the database.All th....
Category: SQL Server Date: 10/1/2010 12:04:08 PM
SQL Server : What do you mean by dirty pages in SQL Server?

What do you mean by dirty pages in SQL Server?

Dirty pages in SQL server are the data pages which have been modified and are still lying in the buf....
Category: SQL Server Date: 10/1/2010 12:03:08 PM
 
Signup for our weekly email newsletter
email newsletter
Questions Categories