| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How m-m relationships are implemented? | | 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 | 7 |
| What are sub-queries? Give example? In which case
sub-queries are not feasible? | Infosys | 1 |
| What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they. | IBM | 5 |
| What is the difference between a local and a global variable? | | 2 |
| Can you link only other SQL Servers or any database servers
such as Oracle? | | 1 |
| how to find the particular row in table?(means suppose one
table contain 10 rows , in these 10 rows how to find the
particular row(example in 10 rows i want 5 row how)? | Marlabs | 5 |
| How do SQL server 2000 and XML linked? | | 1 |
| Difference between writing SQL query and stored procedure ? | Cognizent | 8 |
| What are cursors? Name four types of cursors and when each
one would be applied? | Adea-Solutions | 1 |
| What is the diff between Static Queries and Dynamic queries
give me some examples | CSC | 1 |
| difference between sql server2000 and sql server2005
| | 1 |
| I have a table in which phno is one of the columns.i do have
some values in tht phno column.i need to update phno column
values with 0(zero) as prefix.give me a correct solution plz... | Value-Labs | 4 |
| Can Somebody tell me the difference between Clustered & Non-
Clustered Index?? | Progressive | 3 |
| What is the use of DBCC commands? | | 1 |
| write query for fourth maximum salary from employee table | Mind-Tree | 4 |
| how to find number of columns in a table in sql server 2000
and 2005 also | Virtusa | 6 |
| How to list all tables having unique constraints in any of
the columns in a database. | | 1 |
| where do you use Isolations?give me some exmpale? | | 1 |
| What is the difference between a stored procedure and a user
defined function in sql server? | Millennium | 2 |
| |
| 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
