Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



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,

1385

what is sql injection?

2 4016

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

2 3608

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,

3025

How to Install SQL SERVER 2005 remotely?

IBM,

1 3122

what are the Prerequisites for Replication?

IBM,

1 9896

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 7661

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

IBM,

4 14996

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

G7 CR Technologies, IBM, Satyam,

1 3023

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

1284

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 10817

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 4008

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

1220

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 5659

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

Accenture,

11 13793







Un-Answered Questions { SQL Server }

What is a partition key?

173


What are wait types?

219


What is update locks?

181


Difference between report and query parameter.

220


What is page in sql server?

169






What is coalesce and check constraint in sql server?

194


What are trace flags and mention a few common trace flags used with sql server?

206


Create and insert into temp table in sql server?

221


What is difference between inner join and join?

183


What is extended stored procedures?

193


Why I can not enter 0.001 second in date and time literals in ms sql server?

202


How to search for a string in all stored procedure in sql server?

202


How to create an identity column?

204


When do you think a developer should use sql server-based cursors?

173


what is the difference between delete table and truncate table commands? : Sql server database administration

173