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?

HCL, Cap Gemini,

1010

what is sql injection?

2 3238

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

2 2882




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,

2669

How to Install SQL SERVER 2005 remotely?

IBM,

1 2630

what are the Prerequisites for Replication?

IBM,

1 8403

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 6642

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

IBM,

4 11923




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

IBM, Satyam, G7 CR Technologies,

1 2467

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

948

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 8288

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 3488

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

865

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 4647

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

Accenture,

11 10953


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

865


What is the difference between online clustering and Offline clustering?

1213


what are the Prerequisites for Replication?

8403


application server is slow what may be the problem

1073


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

848






optimization techinques

1306


How to restore performance issues and how to check?

830


Comment,Datatypes are unlimited

909


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

296


Which is the best place or learning center for MS SQL?????In Bangladesh?????

864


what is the sql equivaent of the dataset relation object ?

827


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1048


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1035


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

865


last function used in MS Access to convert sql what function will use in sql

840