Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Define Check points and End Points?



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

How to encrypt Strored Procedure in SQL SERVER?

0 Answers  


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

0 Answers  


How does a profiler work?

0 Answers  


How do you create a clustered index?

0 Answers  


Difference between server.transfer and server.execute method?

2 Answers  






Name few of the dcl commands in sql?

0 Answers  


What protocol does sql server use?

0 Answers  


What does executeupdate return?

0 Answers  


Can we insert data into view sql server?

0 Answers  


What are the system database in sql server 2008?

0 Answers  


Where in ms sql server is ’100’ equal to ‘0’?

0 Answers  


Which table keeps the locking information?

0 Answers  


Categories