SQL Server Interview Questions
Questions Answers Views Company eMail

wat is the main diff between sql server 2000and sql server 2005

Jade Software,

6 8450

What is the difference between windows authentication and sql server authentication

HCL,

7 21480

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

IGT,

1750

how can i store resumes in database?

HCL,

3 8807

how many joins we can write if at all we have n no of tables

Tanla Solutions, TS,

5 14345

what is the order of execution of where,having,group by in select stement

IBM, Tanla Solutions,

6 20392

What is the difference between SSAS 2000 and SSAS 2005?

APX,

1 6553

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.

APX,

6 12998

please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 9452

can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3

Google,

15 13201

i want table name basis on column name.

5 6730

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

iFlex,

3 6795

In clustered and non clustered indexes which one is faster while executing a query ?

1 6915

How to create logins using windows Authentication mode?

2 3740

write the query for taking database restore in sql?

2 4622


Un-Answered Questions { SQL Server }

What is rank function?

597


What is an example of a primary key?

498


what is the maximum size of a row? : Sql server database administration

523


what are the disadvantages of cursors? : Sql server database administration

488


how to avoid cursors? : Sql server database administration

483






What is a DBMS, query, SQL?

566


How can you insert null values in a column while inserting the data?

703


what is a transaction? : Sql server database administration

466


can we have a nested transaction? : Sql server database administration

492


What do you understand by hotfixes and patches in sql server?

504


Explain triggers?

548


What is Command line parameters in PLSQL.?

576


How does clustered and non clustered index work?

508


What is difference between views and stored procedures?

504


Do you know what is lock escalation?

572