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,

2110

what is sql injection?

2 5802

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

2 5338

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,

3824

How to Install SQL SERVER 2005 remotely?

IBM,

1 4462

what are the Prerequisites for Replication?

IBM,

1 11253

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 9807

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

IBM,

4 19361

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

G7 CR Technologies, IBM, Satyam,

1 4263

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

1949

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 15869

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 5026

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

1896

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 8074

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

Accenture,

12 20241

Un-Answered Questions { SQL Server }

What is dynamic cursor in SQL SERVER?

1010

How to modify an existing user defined function?

1044

What are the tables in sql?

1044

How to delete all rows with truncate table statement in ms sql server?

940

What is the minimum recommended amount of ram for sql server 2012 enterprise?

896

What is tablix?

156

what is the system function to get the current user's user id? : Sql server database administration

962

Explain indexed views?

934

what are the new features in SSRS?

132

How to define output parameters in stored procedures?

970

How to list all login names on the ms sql server?

1089

Which are new data types introduced in sql server 2008?

998

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

911

What is collation?

1103

How to list all user defined functions in the current database?

986

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