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,

1034

what is sql injection?

2 3301

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

2 2941




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,

2694

How to Install SQL SERVER 2005 remotely?

IBM,

1 2657

what are the Prerequisites for Replication?

IBM,

1 8516

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 6706

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

IBM,

4 12170




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

IBM, Satyam, G7 CR Technologies,

1 2520

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

966

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 8445

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 3519

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

890

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 4720

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

Accenture,

11 11120


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

892


Issues related in upgrading SQL Server 2000 to 2005 / 2008

791


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1365


how to use DTS package in 2000,2005,2008 in sql server

797


System variable and temporary variables

994






Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

1313


what are the critical issues you have resloved in your company

839


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

328


ow to bring suspect mode datbase online from scratch

701


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

883


If a stored procedure is taking a table data type, how it looks?

4675


How can we call UDF(User Define Function) using C# code in ASP.net ?

4711


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1122


What is Lock table in SQL?

284


what are the Prerequisites for Replication?

8516