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?

1120

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

990

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

1087

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

1175

What is xdr?

1041

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

1049

Which table keeps information about stored procedures?

981

How is a full-text index updated?

1000

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?

1001

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

1081

What does the automatic recovery do?

1 2814

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

986

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?

1075

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

1028

How many full-text indexes can a table have?

1022

Un-Answered Questions { SQL Server }

What types of replication are supported in sql server?

1111

How many partitions a clustered index has by default in sql server 2012?

1137

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1224

What is global temp table?

1045

How do I determine how many instances of sql server are installed on a computer?

1054

What are the different authentication modes in sql server?

1165

How to connect Azure federated root database and apply federation in entity framework?

109

Explain iaas, paas and saas?

What is onf in normalization form?

1111

How to delete duplicate records based on single column from a table?

1102

How to create stored procedures with parameters in ms sql server?

1150

Can group functions be used in the order by clause in ms sql server?

1064

What is difference between index seek vs. Index scan?

1199

How do you run a trace?

946

How do clustered indexes store data?

1150

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