1) What are Isolation levels in SQL? 2) What happens if same SP is modified by multiple users at same time, how do u capture the details of each user's changes? 3) What are ACID properties? 4) What are triggers & its types? 5) What is fragmented index? 6) how to read Explain Plan? 7) what is the default index created on a table(clustered or non-clustered)?

Question

Accepted Answer

Technical interview questions for a Project Manager role

Isolation levels in SQL determine the degree to which one transaction must be isolated from resource or data modifications made by other transactions
If the same stored procedure is modified by multiple users at the same time, the changes made by each user can be captured using version control tools such as Git or SVN
ACID properties are a set of properties that ensure database transactions are processed reliably
Triggers are database objects that are automatically executed in response to certain events or changes in the database
A fragmented index is an index that has become fragmented over time due to data modifications and deletions
To read an Explain Plan, you need to execute a query and then use the EXPLAIN PLAN statement to display the execution plan for the query
The default index created on a table depends on the database management system being used. In SQL Server, the default index is a clustered index.

Popular interview questions of Technical Project Manager