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,

2199

what is sql injection?

2 6079

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

2 5528

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,

3923

How to Install SQL SERVER 2005 remotely?

IBM,

1 4673

what are the Prerequisites for Replication?

IBM,

1 11446

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 10134

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

IBM,

4 19685

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

G7 CR Technologies, IBM, Satyam,

1 4430

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

2042

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 16434

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 5170

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

1988

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 8386

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

Accenture,

12 21247

Un-Answered Questions { SQL Server }

How can I add Reporting Services reports to my application?

132

Can we write trigger for view?

1071

What is the difference between for trigger and after trigger?

1166

What the class forname () does?

1143

What is the security principal at the database level that represents your session?

997

How to download and install the scaled-down database adventureworkslt?

1045

What are the underflow and overflow behaviors on float literals?

1171

How you can minimize the deadlock situation?

1089

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

1003

What is the index requirement in SQL Azure?

How to turn off warning messages during php execution?

1112

What are 3 ways to get a count of the number of records in a table?

1123

What is the most common type of join?

1045

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2858

What is the advantage of sql server?

1084

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