SQL Server Interview Questions
Questions Answers Views Company eMail

wht is normalization?can u explain me in detail?

TCS,

9 11270

what are the new features of sql server 2005?

HP, Keane India Ltd,

8 7544

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

HP,

1 3079




hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

Oracle, IntraLogic,

1118

How many index keys possible for a table

6 7908

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

Infosys, TCS, DELL, Siemens, i Tech,

9 55493

wat will be the sql query to extract only last 3 records from table supose table hving thousands for records

19 18254

How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

Synechron, Leo Technologies, Mannar Company,

15 21131




what is meant by sql injection with example and one more question how to catch the errors in sqlserver

2 8279

What are Magic Table?

3i Infotech, NIIT, Evalueserve, Digiweb, PL,

34 55142

what are file groups?

Evalueserve,

3 6661

what is the cursor life span?

Evalueserve, HG,

5 9571

What is the difference between NOROW and LOCKROW?

Satyam, Accenture, Honeywell,

1233

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?

1019

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com

IBM, Symphony,

28 14507


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

If the job running very slow what is the action you do

687


what is the Ticketing tool used in Wipro technologies at Bangalore...???

4888


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 ?

826


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

852


optimization techinques

1277






What is RMS migrations?

922


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

790


tell me the disaster recovery plan

1260


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

782


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

749


If user is owning any SQL Objects, can we drop that user

829


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

1072


How we create SQL Server 2005 Reporting Services ? Give me Sample

887


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

899


You are doing log shipping due to some reasons it is failing. How you will proceed from there

792