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

How to insert multiple rows with one insert statement in ms sql server?

1176

How to drop existing views from a database in ms sql server?

1143

What is open database communication (odbc)?

1110

What are the underflow and overflow behaviors on float literals?

1163

How to create new tables with "select ... Into" statements in ms sql server?

1043

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

1064

Can you pass expressions to stored procedure parameters?

1081

How to return the top 5 rows from a select query in ms sql server?

1205

How to add more data to the testing table in ms sql server?

1161

How to declare and use cursor variables?

1248

How to use "begin ... End" statement structures in ms sql server?

1115

How to create a simple stored procedure in ms sql server?

1083

How to execute a stored procedure in ms sql server?

1248

What is a select query statement in ms sql server?

1127

How to rename an existing column with sql server management studio?

1044

Un-Answered Questions { SQL Server }

Can you force a query to use a specific index?

985

explain different types of constraints? : Sql server database administration

998

What are the different type of replication in sql server?

1013

Define msdb database?

1075

Explain log shipping?

1076

Can we use where and having clause together?

1097

What is clustered vs nonclustered index?

998

Do you know what is normalization of database? What are its benefits?

1200

How to recreate an existing index in ms sql server?

1113

What are the elements of dbms?

1008

If a stored procedure is taking a table data type, how it looks?

6516

What do you understand by recursive stored procedure?

984

do you know how to configure db2 side of the application? : Sql server database administration

1090

Explain log shipping and mention its advantages.

1085

Explain sql server service broker?

1023

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