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

Why do you want to join software field as you have done your BE in Electronics?

Cap Gemini, HCL,

2195

what is sql injection?

2 6073

Can we passed multiple recordset(set of records) using a Stored Procedure

2 5522

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

IBM,

3919

How to Install SQL SERVER 2005 remotely?

IBM,

1 4671

what are the Prerequisites for Replication?

IBM,

1 11443

How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?

IBM,

2 10123

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

IBM,

4 19667

After the SQL installation what are the jobs will you configure?

G7 CR Technologies, IBM, Satyam,

1 4422

If i am handling 150 servers then how to check the active jobs of all the servers?

2038

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

ADP,

9 16430

I have cleared sbi clerk examination. I am Bachelor in computer application (BCA) graduate. so which type of question related bca in sbi clerk interviews. pls answers me at sejalvaghela@yahoo.co.in.. and also tell me which type of question asked in sbi clerk interview.

1 5164

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1984

difference between select column name from table name where serviceid=2; and select max(column name) from table name where serviceid=2; IN ORACLE

Intel, Wipro,

3 8376

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

Accenture,

12 21206

Un-Answered Questions { SQL Server }

Explain what is public role in sql server?

1192

How would you go about developing a ssrs report?

174

List out the differences between global and local temp tables in sql server?

1112

System requirements for sql server 2005 express edition?

1070

What is normalization and its types?

1077

how would you store your query in an SSRS report or a Database server?

165

Name few of the dcl commands in sql?

1054

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

1338

What are three major types of constraints?

1174

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

1063

What is the correct order of the logical query processing phases?

995

Does any body please help me what question's have asked for SSRS in the interview?

2202

Explain query editor regions

1109

What is the index requirement in SQL Azure?

What does select 1 mean?

977

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