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,

2144

what is sql injection?

2 5930

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

2 5412

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,

3873

How to Install SQL SERVER 2005 remotely?

IBM,

1 4570

what are the Prerequisites for Replication?

IBM,

1 11351

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 9964

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

IBM,

4 19527

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

G7 CR Technologies, IBM, Satyam,

1 4341

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

1985

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 16176

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 5091

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

1946

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 8240

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

Accenture,

12 20735

Un-Answered Questions { SQL Server }

What are the restrictions that views have to follow? : SQL Server Architecture

1001

What is the recovery model?

989

Can we call future method from trigger?

937

What are trace files?

957

How to backup encryption key ?

182

What is store procedure? How do they work?

1020

What is relationship? What number of sorts of relationship are there?

1138

Explain in brief how sql server enhances scalability of the database system?

981

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1054

can any body tell me how to know the password of current user in sql server

2072

What is compression - row-level and page-level compression?

918

What are the default system databases in sql server 2000?

1028

Why truncate is ddl command?

1064

What are the types of normalization?

1031

What is the difference between implicit and explicit transaction?

1010

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