SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

HCL, ZX,

5 10140

what is the difference between group and having give an example with query and sample output

7 10195

What is Data model and how to prepare a data model.?

TCS,

1 5720

what is a stored procedure and trigger?

3 6227

How to retrieve data from log files in SQL SERVER ?????

1 6506

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 9527

Whether the updations made to the views reflect the original records in the table

NIIT,

5 9686

How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the grade actegory of student table?

3 6149

how to select 5 to 7 rows from a table, which contains 10 rows?

IBM,

21 27876

How to select nth record from a table?

DELL, Microsoft, Ramco,

13 41419

role of sql sever 2005 in database rather than any other database

1 1998

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

CSC, IBM,

1 2542

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

TCL, Wipro,

1 2120

what is the difference between Delete and Truncate

CarrizalSoft Technologies, Geo Research Centre,

4 8908

from the table display the 2nd highest salary? and also the least 2nd salay?

8 10671

Un-Answered Questions { SQL Server }

What is the difference between upgrade and migration in sql server?

1163

Can you index views?

946

What are the different types of subquery?

1222

List out the different types of locks available in sql server?

1037

How do I create a trace in sql server?

1102

Does view occupy space?

997

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1275

What are the different subsets of sql?

1633

When should you use an instead of trigger?

1033

How to provide default values to function parameters?

1235

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1015

Explain “row_number()” in sql server with an example?

1060

Can one drop a column from a table?

1075

What is self contained sub query?

1129

Can we shrink data file in sql server?

1110

For More Un-Answered { SQL Server } Questions Click Here