SQL Server Interview Questions
Questions Answers Views Company eMail

Why we need a group by clause?

4 6743

What is a join and their types?

Challenger Financial,

2 5137

What is the difference between referencing and joining?

1 2363




What is the difference between constraints and triggers?

Wipro,

9 25817

What is ACID Property of Transaction?

10 30236

What is an index?

Yardi Software,

8 9946

What is normalization and its forms?

Challenger Financial,

4 10551

What is a cursor in SQL Server 2000 and their types?

8 13827




How do we get month name in SQL Server 2000, Oracle, MS Access?

11 45896

How do we return a record set from a Stored Procedure in SQl server 2000?

3 3829

What are the magic tables in SQL Server 2000?

Merrill Lynch, Infogain,

7 20164

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 43511

What are the differences between stored procedure and functions in SQL Server 2000?

Infosys, HCL, TCS, College School Exams Tests,

25 96929

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 3869

Which is best Subquery (or) joins in sql server? explain why

2 9073


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is best institute to Learn DotNET And SQL in chennai?

1042


what is checksum in sql server.........???

467


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

1430


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

690


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1418






what is isolation level at dead lock?

1082


Tell about MOM Tool(Microsoft Operator Manager)?

761


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1017


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?

947


tell me the disaster recovery plan

1358


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

452


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

2947


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

928


How do you Implement SSIS Packages in your Project?

903


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

939