Sqlserver Interview questions


Total available count: 45
Subject - Databases
Subsubject - Sqlserver

What do you mean by ACID?

ACID stands for (Atomicity, Consistency, Isolation, Durability). It is a quality sought after in a reliable database. Here's the relevance of each quality:
 
1. Atomicity:-  It is an all-or-none proposition
2. Consistency:-  It guarantees that your database is never left by a transaction in a half-finished state
3. Isolation:-  It keeps transactions separated from each other until they are finished
4. Durability:-  It ensures that the database keeps a track of pending changes in a way that the server can recover from an abnormal termination



Next 5 interview question(s)

1
Explain the difference between a Local and a Global temporary table?
2
What is the difference between UNION and UNION ALL?
3
What are the authentication modes in SQL Server?
4
What are the properties and different Types of Sub-Queries?
5
When is the use of UPDATE_STATISTICS command?