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 8209

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

7 7858

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

TCS,

1 4833

what is a stored procedure and trigger?

3 4625

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

1 5684

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 8493

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

NIIT,

5 8007

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 4796

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

IBM,

21 21330

How to select nth record from a table?

DELL, Microsoft, Ramco,

13 36748

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

1494

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,

2042

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

TCL, Wipro,

1572

what is the difference between Delete and Truncate

CarrizalSoft Technologies, Geo Research Centre,

4 7086

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

8 8222


Un-Answered Questions { SQL Server }

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

586


what is the different types of backups available in sql server? : Sql server database administration

477


What is sql server transaction log file?

495


Explain the purpose of indexes?

521


Explain difference between control flow and data flow?

510






Why we need sql server?

534


What is the difference between online clustering and Offline clustering?

1896


What objects does the fn_my_permissions function reports on? : sql server security

537


What are views used for?

601


Differentiate between ms sql server reporting services vs crystal reports?

461


Explain what is the difference between union and union all?

528


How to modify existing triggers using "alter trigger"?

498


Tell me what is use of except clause? How it differs from not in clause?

490


How to set database to be single_user in ms sql server?

537


What are system databases into sql server (2005/2008)?

562