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 18250

what are the new features of sql server 2005?

HP, Keane India Ltd,

8 13254

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 5294

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,

2223

How many index keys possible for a table

6 12544

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 63755

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

19 29829

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

Leo Technologies, Mannar Company, Synechron,

15 32622

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

2 10928

What are Magic Table?

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

34 78686

what are file groups?

Evalueserve,

3 10168

what is the cursor life span?

Evalueserve, HG,

5 14497

What is the difference between NOROW and LOCKROW?

Accenture, Honeywell, Satyam,

2837

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?

2147

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

IBM, Symphony,

28 32672

Un-Answered Questions { SQL Server }

How can you know if the row fetched from cursor is still valid in underlying table?

998

How to identify current user in ssrs report?

403

Do you know what is similarity and difference between truncate and delete in sql?

1007

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2785

What is a rownum?

976

what is bit datatype? : Sql server database administration

917

What is wide table?

948

Can sql servers link to other servers?

1085

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

986

How do you delete a trigger?

979

What is normalization? Explain different forms of normalization?

1160

what are acid properties? : Sql server database administration

997

List some of the rules that apply to creating and using a ‘view’

888

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1139

Which command is used for user defined error messages?

1060

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