Saturday, December 25, 2010

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.


No comments:

Post a Comment