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 |
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
Explain in brief how sql server enhances scalability of the database system?
Difference between Cluster and Non-cluster index?
32 Answers Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,
Questions regarding Raiseerror?
What are the different SQL Server Versions you have worked on?
Explain a join?
what are database files and filegroups? : Sql server database administration
What are different types of table joins?
What are the steps to follow to configure SQL*Net?
what is a transaction and what are acid properties? : Sql server database administration
what are three different authentications to connect linked servers?
what is a self join? Explain it with an example? : Sql server database administration
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)