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

How connect excel to sql server?

0 Answers  

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

0 Answers   TCS,

Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

0 Answers  

Explain how many types of relationship?

0 Answers  




Differentiate between a local and a global temporary table?

0 Answers  

How you would rewrite the sql query to return the customerid sorted numerically?

0 Answers  

What is explicit mode in sql server?

0 Answers  

How to find the last update record in SQL Server?

4 Answers  

Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,

what is mean by crystal repoart? ahere we will mainly use that?

1 Answers  

Explain what are magic tables in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories