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 9086

How are SQL Server databases physically stored under Windows 2000?

1 4353

internal language used in sql server 2000?

2 4591

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

1 4879

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

1 4697

Which virtual table does a trigger use?

3 8920

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

1 4151

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 9770

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

3 5184

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

4 6473

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 21764

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 7983

what is difference between having and where clause ?

3 5898

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

4 9532

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

10 18453

Un-Answered Questions { SQL Server }

What is a scheduled job or what is a scheduled task?

1029

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1284

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

1121

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1184

Disadvantages of the indexes?

1216

How can you append an identity column to a temporary table?

1063

Equi join and non equi join is possible with sql server?

1118

What is clustered index

1081

What is the primary use of the model database?

1144

do you know how to configure db2 side of the application? : Sql server database administration

1113

How can we solve concurrency problems?

1116

What are different types of constraints?

995

What is the difference between upgrade and migration in sql server?

1170

Can you index views?

951

How do I find query history in sql server?

1018

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