Nomisma Solution MS SQL DBA Interview Questions and Answers

Deadlock is a situation where two or more transactions are waiting for each other to release locks, causing them to be stuck indefinitely.

• Occurs when two or more transactions are waiting for each other's locks

• Can lead to a standstill in the database operations

• Commonly resolved by setting proper transaction isolation levels

• Example: Transaction A holds a lock on Table X and waits for Table Y, while Transaction B holds a

DDL stands for Data Definition Language and is used to define the structure of database objects. DML stands for Data Manipulation Language and is used to manipulate data within the database.

• DDL is used to create, modify, and delete database objects like tables, indexes, etc.

• DML is used to insert, update, delete, and retrieve data from tables.

• Examples of DDL statements include CREATE TABLE, ALTER TABLE, DROP TABLE.

• Examp...read more