SQL Server Interview Questions
Questions Answers Views Company eMail

write the query for find the top 2 highest salary in sql server

Medi Assist, Cranes, TCS, Jayanti Software, Rmax,

36 50389

how to retrive only second row from table in sql server 2000?

Cognizant, CTS,

15 16706

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

vsworx, tdfc,

9 6882




Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 4336

Alternative way to DetDate() function?

5 5635

How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com

Oracle, Scend, TechInfini,

35 36995

How to delete an attribute from the emp table

4 6204

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 2329




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

HCL,

997

HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE

Infosys, TCS,

18 38818

wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform

Idea,

1 6616

how to find out the repeated value from table using groupby function?

4 4138

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

TCS, ABC,

4891

What is mean by "fill factor" ? and what is mean by "Index "in sql?

iGate, Logica CMG,

1 7297

write the query for taking database backup in sql

IBM, ABC, Logica CMG, MA,

10 29381


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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?

956


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1569


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

935


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

935


last function used in MS Access to convert sql what function will use in sql

937






What is Lock table in SQL?

364


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

2960


Scalability, Availability, Integration with internet, etc.)?

1749


How retrieve field names from the table in SQL through JAVA code?

777


what is package and it uses and how can u call a package

974


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

886


How you trouble shoot when any job fails

793


Call by value and call by reference in procedure and function, with NOCOPY.

239


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

1442


How to restore performance issues and how to check?

925