SQL Server Interview Questions and Answers : Series 6

Question: What are dynamic queries?

Answer: Dynamic Queries are the query in which logic can be change at run time. These queries are created by using the variables.

Question: What is distinct clause? How it works?

Answer: Distinct clause is used to filter unique records in the result set. If you are putting distinct on more than one column it will provide data for distinct row.

Question: What is isolation level in SQL Server?

Answer: Isolation levels are used to handle transaction in SQL Server. I.e. to implement concurrency across the transactions.

Question: What is default isolation Level for SQL Server?

Answer: Read committed is the default isolation for SQL Server.

Question: What are indexes in SQL Server?

Answer: Indexes are used to search the data in the database in well-mannered approach. Data can be searched by user without going into entire database.

Question: What are the different types of indexes in SQL Server?

Answer: Indexes are two types

1.       Clustered index

2.       Non Clustered Index.


GO BACK TO MAIN QUESTIONS LIST