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

wht is normalization?can u explain me in detail?

TCS,

9 18621

what are the new features of sql server 2005?

HP, Keane India Ltd,

8 13533

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

HP,

1 5391

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

IntraLogic, Oracle,

2278

How many index keys possible for a table

6 12749

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

DELL, i Tech, Infosys, Siemens, TCS,

9 64102

wat will be the sql query to extract only last 3 records from table supose table hving thousands for records

19 30400

How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

Leo Technologies, Mannar Company, Synechron,

15 33066

what is meant by sql injection with example and one more question how to catch the errors in sqlserver

2 11030

What are Magic Table?

3i Infotech, Digiweb, Evalueserve, NIIT, PL,

34 79760

what are file groups?

Evalueserve,

3 10343

what is the cursor life span?

Evalueserve, HG,

5 14695

What is the difference between NOROW and LOCKROW?

Accenture, Honeywell, Satyam,

2907

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

2190

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com

IBM, Symphony,

28 33649

Un-Answered Questions { SQL Server }

Do you know query execution plan?

1273

Is sql server is free?

1023

How can you tell if a database object is invalid?

1121

What are “phantom rows”?

1706

What is isnull() operator?

1092

What is a partition function in sql server?

1225

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5981

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

1062

What is update locks?

942

How to bind a view to the schema of the underlying tables?

1052

What is the temp table?

981

What is sql server replication? : sql server replication

1041

What samples and sample databases are provided by microsoft?

1089

How to retrieve error messages using odbc_errormsg()?

1112

Explain different types of collation sensitivity?

1041

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