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 18204

what are the new features of sql server 2005?

HP, Keane India Ltd,

8 13207

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 5280

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,

2212

How many index keys possible for a table

6 12514

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 63706

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

19 29754

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

Leo Technologies, Mannar Company, Synechron,

15 32548

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

2 10914

What are Magic Table?

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

34 78612

what are file groups?

Evalueserve,

3 10141

what is the cursor life span?

Evalueserve, HG,

5 14460

What is the difference between NOROW and LOCKROW?

Accenture, Honeywell, Satyam,

2827

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?

2139

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

IBM, Symphony,

28 32551

Un-Answered Questions { SQL Server }

Explain the xml support sql server extends?

1032

What objects does the fn_my_permissions function reports on? : sql server security

1028

What is dml command?

957

How many replicas are maintained for each sql azure db?

124

What is the ‘fillfactor’?

964

How to copy the tables, schema and views from one sql server to another?

1039

What is the sql case statement used for?

1088

What is application role in sql server database security? : sql server security

1055

What is triggers and stored procedures?

935

How to retrieve error messages using odbc_errormsg()?

1044

Do you think BCNF is better than 2NF & 3NF? Why?

1272

What is DCL?

1046

What is query cost in sql server?

987

What are the common performance issues in sql server?

915

What are the different types of stored procedures?

1110

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