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

syntax for deleting the database in T SQL

5 8756

How are SQL Server databases physically stored under Windows 2000?

1 4243

internal language used in sql server 2000?

2 4456

What types of integrity are enforced by a foreign-key constraint

1 4786

How do you find the error, how can you know the number of rows effected by last SQL statement?

1 4571

Which virtual table does a trigger use?

3 8696

Name three version of sql server 2000 and also their differences?

1 4031

Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 9643

can you any body tell me which service pack is installed in the sql server?

3 5012

can you any body tell me the how to decrease the logfile

4 6201

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

HCL, IBM,

17 21078

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 7795

what is difference between having and where clause ?

3 5702

Accidentally i deleted my table. How can i get that table?

4 9337

how can i view structure of table in sql server? tell me that query.

10 18038

Un-Answered Questions { SQL Server }

What are the system database in sql server 2005?

1040

What are indexers?

1084

In which files does sql server actually store data?

895

How to configure and test odbc dsn settings?

1152

How many types of triggers in sql server?

1026

How to get the definition of a user defined function back?

1042

Explain about Normalization?

1054

Explain different backup plans?

935

When columns are added to existing tables, what do they initially contain?

1026

What is lock escalation and what is its purpose?

970

Define inner join in sql server joins?

1051

Explain concepts of analysis services?

952

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

979

What is 2nf example?

985

How many types of cursor type are there?

1083

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