1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Define Check points and End Points?

Question Posted / vamsimadineni


Define Check points and End Points?..

Answer / veeresh kethari

CheckPoints:Whenever we perform any DML operations in the
database,it will go to the checkpoint and then commit in
the database.If we don't have checkpoints,the data will get
store in transaction log file,once it got fill full,it will
make the database performance issues.
Endpoints:Endpoints are objects that represent a
communication point between the server and a client.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is Deadlock?

4 Answers   Satyam,

How will you know when statistics on a table are obsolete?

0 Answers  

What is the purpose of update statistics and scope_identity() function?

0 Answers  

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

0 Answers  

what is diffence between replicaion and logshipping?

1 Answers  




What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

What is the difference between 2-Tier architecture and 3-Tier architecture

15 Answers   CTS, MCN Solutions, Oracle,

What is a job?

3 Answers  

what is the main difference between after trigger and instead trigger.

2 Answers  

What’s the use of custom fields in report?

0 Answers  

Explain syntax for viewing, dropping and disabling triggers?

0 Answers  

List out some of the requirements to set up a sql server failover cluster?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories