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

‘Order by’ is not allowed in a view how can you sort information from a view?

1126

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

995

How do you use a subquery to find records that exist in one table and do not exist in another?

1094

Can a cursor be updated? If yes, how you can protect which columns are updated?

1179

What is xdr?

1045

How can you set the threshold at which sql server will generate keysets asynchronously?

1052

Which table keeps information about stored procedures?

986

How is a full-text index updated?

1003

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

1006

How can you find out how many rows returned in a cursor?

1090

What does the automatic recovery do?

1 2842

What is the difference between writing data to mirrored drives versus raid5 drives

990

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

1078

Give an example of why you would want to denormalize a database

1035

How many full-text indexes can a table have?

1026

Un-Answered Questions { SQL Server }

What is the name of reporting services config file and what’s it’s used for?

153

what are constraints? : Sql server database administration

1135

What are the benefits of normalization?

1161

How can windows applications connect to sql servers via odbc?

1184

How to start and end transact-sql statements?

1090

What is the maximum size of sql server database?

1066

What is the default value of an integer data type in sql server 2005?

1000

What is resource db in sql server?

1058

What is an entity-relationship diagram (erd)?

1317

How to remove duplicate rows from table?

1316

What is nonclustered index with included columns ?

1019

How to send email from database?

1074

What are the differences between having and where clause.

1023

What is raid, and how it can influence database performance?

1102

Which Model uses the SET concept

1046

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