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

what is web server?

Satyam,

3 25689

What are functions

3 22891

how to get the automatic backup of the database in the sql server

4 36191

What command do we use to rename a db?

IBM,

5 13936

What are the four main query statements?

Wipro,

7 22254

Which command using Query Analyzer will give you the version of SQL server and operating system?

3 16153

What is the STUFF function and how does it differ from the REPLACE function?

2 20736

What is SQL server agent?

HCL, SAP Labs,

2 9971

What is the purpose of UPDATE STATISTICS?

2 13913

What is de-normalization and when do you do it?

3 9058

Difference between Function and Stored Procedure?

C1 India, NA,

9 22189

What is data integrity? Explain constraints?

Thinksoft,

1 26107

Explain some DBCC commands?

6 20200

What are tasks?

Wipro,

3 13383

What is the purpose of using COLLATE in a query?

1 18847

Un-Answered Questions { SQL Server }

How many servers can we create in a single subscription?

162

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

2493

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1192

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

923

Which are new data types introduced in sql server 2008?

1050

What is store procedure? How do they work? When do you use?

944

Does a sql server 2005 select statement require a from?

1024

What is query optimization process?

1015

What are the restrictions that views have to follow? : SQL Server Architecture

1002

Explain nested trigger in sql?

1080

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1164

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1012

Write SQL queries on Self Join and Inner Join.

1158

What is forward - only cursors / read only cursor?

1091

What is function of ROLLUP ?

1086

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