SQL Server Interview Questions
Questions Answers Views Company eMail

what is difference between primary key and Unique

8 4006

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

SAP Labs,

3 6110

HOW TO RENAME A COLUMN NAME

3 4336




what is cluster and nin-cluster index?

4 3447

how to delete duplicate rows from table in sql server

UHG, HCL,

12 14447

What is difference beteen Migration and Upgrdation?

Satyam,

7 18517

What are different types of Keys? Please explain all the keys with a suitable example.

4 23014

What is cursor ? And what is difference between Trigger ?

HCL, Polaris,

2 24272




What is row by row processing ?

2 5747

can primery key be a non clustered index?

10 6740

How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

1 3724

can foreign key take role of primary key?

TCS, CarrizalSoft Technologies, Villa Marie,

5 6019

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

Wipro,

4 6257

How to find out name of all employees who has salary less than 200 Rs.?

8 4379

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 1966


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

ow to bring suspect mode datbase online from scratch

662


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

756


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

829


What is data modeling and Reterminal integrity?

633


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

1573






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

279


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

563


tell me the disaster recovery plan

1261


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?

835


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

1271


how to take backup bcp out for a column in table in sql server?

820


Why do you want to join software field as you have done your BE in Electronics?

996


how can u get last observation in an unknown dataset ?

1106


1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

1273


query processing

975