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,

2138

what is sql injection?

2 5916

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

2 5407

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,

3872

How to Install SQL SERVER 2005 remotely?

IBM,

1 4564

what are the Prerequisites for Replication?

IBM,

1 11346

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 9947

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

IBM,

4 19515

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

G7 CR Technologies, IBM, Satyam,

1 4337

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 16152

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 5089

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

1939

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 8230

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

Accenture,

12 20695

Un-Answered Questions { SQL Server }

Do you know what is fill factor and pad index?

997

What is normalization of database? What are its benefits?

1020

What is local temp table?

947

How much does sql server 2016 cost?

1058

What are the limitations in ssrs on sql server express edition?

186

What is the index requirement in SQL Azure?

What do you understand by sql server agent?

974

Explain the truncate command?

975

What does the not null constraint do?

1077

What is the web service used for reporting services?

123

How do you delete a trigger?

969

How to set a database state to offline in ms sql server?

1040

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

1010

What is a field in a table?

1036

Do you know what is similarity and difference between truncate and delete in sql?

1004

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