Define Check points and End Points?
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 |
WHAT IS UNIQUE IDENTIFIER DATA TYPE?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
What are the types of constraints?
In which files does sql server actually store data?
What is the meaning of resultset type_scroll_insensitive?
Define constraints and give an example of their use?
what stored procedure can you use to display the current processes? : Sql server administration
Please tell me some knowledge about Clustering and how to add clustering?
What according to you is the difference between mysql and sql server performance?
Explain about SQL server 2005?
What is meant by indexing files?
What are the results of running this script?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)