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

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 8061

What is the maximun sixes of .mdf in sql server 2005

1 3590

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 5013

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1857

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

Verizon,

2089

what is isolation level at dead lock?

Verizon,

2144

what r steps to we need to fallow b4 kill the process?

Verizon,

1 5400

If the job running very slow what is the action you do

1886

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1801

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

IBM,

2 5599

You are doing log shipping due to some reasons it is failing. How you will proceed from there

2065

Working with TLogs

1832

How you trouble shoot when any job fails

1932

How to trouble shoot if unable to connect SQL Server

1986

If user is owning any SQL Objects, can we drop that user

2064

Un-Answered Questions { SQL Server }

What is the difference between a fill factor of 100 and 0?

976

What are the different types of locks in the database?

918

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1099

What is meant by datasource?

919

What is the default schema of your login session in ms sql server?

1045

What do we have to check in database testing?

1017

Define left outer join?

958

What is the difference between getdate and sysdatetime?

998

Explain how many types of relationship?

1018

Can we return Data from 4(more than 1) tables in stored procedure?

1055

What is normalization? Explain different forms of normalization?

1151

Find columns used in stored procedure?

987

Explain the third normal form(3nf)?

938

Can a table be moved to different filegroup?

971

How do we know if any query is retrieving a large amount of data or very little data?

969

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