SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

Do you know the cursor types?

1156

What is forward - only cursors / read only cursor?

1089

Do you know the capabilities of cursors?

1150

What is cursor in ms sql server?

1145

What is implicit cursors?

1085

What is explicit cursors?

1072

Explain forward - only cursors?

1069

What is scrollable cursor?

1041

Explain the disadvantages of cursors?

1139

What is key set driven?

957

Explain the cursor lock types?

1051

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

953

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

972

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1004

Explain the functionalities that views support?

1114

Un-Answered Questions { SQL Server }

How can I track the changes or identify the latest insert-update-delete from a table?

961

How to check if a table is being used in sql server?

962

What is truncate table?

938

What is the maximum size of a row in sql server?

967

What are the steps to take to improve performance of a poor performing query? : sql server database administration

1050

What is the importance of concurrency control?

1227

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

2036

What is the query and subquery?

1078

In how many ways you can invoke ssrs reports?

139

How to achieve Paging of records in SQL SERVER?

1100

What is rs.exe utility?

156

Explain what is row_number function?

1035

what happens on checkpoint? : Sql server database administration

1101

What is auditing in sql server?

927

Which tcp/ip port does the sql server run on? How can it be changed?

1052

For More Un-Answered { SQL Server } Questions Click Here