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,

972

what is sql injection?

2 3184

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

2 2826




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,

2628

How to Install SQL SERVER 2005 remotely?

IBM,

1 2569

what are the Prerequisites for Replication?

IBM,

1 8233

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 6521

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

IBM,

4 11574




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

IBM, Satyam, G7 CR Technologies,

1 2394

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

905

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 8078

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 3433

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

830

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 4548

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

Accenture,

11 10766


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Explain Capacity planning to create a database? and how to monitor it?

2712


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

833


What is the difference between NOROW and LOCKROW?

1204


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., }

1019


SQL Server Architecture ?

1082






after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

908


what is the sql equivaent of the dataset relation object ?

793


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

763


query processing

956


What is the difference between online clustering and Offline clustering?

1176


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

319


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

797


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?

1007


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 ?

796


what are the critical issues you have resloved in your company

770