| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the difference between Userdefined function and
stored procedure? Explain and give the example also | | 4 |
| How to Debug a Stored Procedure? | Allianz | 4 |
| what is difference between having and where clause ? | | 2 |
| Differnce between sel server 2000 and 2005 | | 3 |
| How to find the date and time of last updated table?
| Teledata | 4 |
| What is the difference between a local and a global variable? | | 3 |
| What is Files and Filegroups in SQL Server & it's
implementation. | Zenith | 1 |
| What is the disadvantage of using subquery exact after a
select statement?ex.
select (select * from sometable) | | 1 |
| What is a Trace frag?Where can we use this? | | 1 |
| What do you mean by COLLATION? | | 4 |
| About DTS usage ? | Cognizent | 2 |
| how to retrive only second row from table in sql server
2000? | CTS | 7 |
| What is the system function to get the current user's user
id? | HCL | 1 |
| 1. What are the grouping function in SQL ?
2. If base table of a view deleted means, what will happen
while we querying on view ? will give any error ?
3. Difference between DROP, DELETE, TRUNCATE table ?
4. What is constraints and types ?
5. What is max size of nchar & nvarchar ?
6. Define ROLLBACK, COMMIT, SAVE POINT
7. How non-clustered better ? or rank the Clustered,
Non-Clustered and Table scan in performance wise
8. Select 10 rows from a table ?
9. Define DML, DDL, DCL, DTL commands ?
10. What is mean by NULL value ? NULL means "" or 0 or
undefined ?
11. Default constraints ?
12. Can we have more then primary Key in table ?
13. Type of integrity ? Entity, Referential, Domain ?
| Perot-Systems | 8 |
| What is a function? Give some example? | | 2 |
| What is data integrity? Explain constraints? | Thinksoft | 1 |
| What is the difference between local table and global table | Polaris | 1 |
| What are cursors? Name four types of cursors and when each
one would be applied? | Adea-Solutions | 1 |
| What are the different types of backup avaible in SQL SErver | Emphasis | 5 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
