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)

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