| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is differece between union and union all | | 4 |
| How do you troubleshoot SQL Server if its running very slow? | | 2 |
| create index a on employee(dno)
In this,which index was created? | | 2 |
| Accidentally i deleted my table. How can i get that table? | | 4 |
| what is a cursor and what is its use? | | 1 |
| explain different types of jions with examples briefly? | Zensar | 3 |
| Display a roll having miminum marks in two subjects? | Patni | 7 |
| What are the types of backup and tell me the difference
between full and differential backup? | TCS | 3 |
| WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE
RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,... | TVS | 2 |
| Which system tables contain information on privileges
granted and privileges obtained | | 1 |
| i have a table student like
sname
-----
ram
ram
ram
raj
raj
raj
i need the output like
sname
-----
ram
raj
ram
raj
ram
raj
| IBM | 7 |
| What is a Trace frag?Where can we use this? | | 1 |
| Can you explain the types of Joins that we can have with Sql
Server? | | 2 |
| What is an index? | Yardi-Software | 7 |
| can you any body tell me the how to decrease the logfile | | 4 |
| What is the difference between UNION and UNIONALL? | CTS | 2 |
| What value could be assigned to Varchar Type? | | 3 |
| Can Somebody tell me the difference between Clustered & Non-
Clustered Index?? | Progressive | 3 |
| What are the advantages of using sql server over ms access
or why should one use sql instead of ms access | Impetus | 1 |
| What is the diff between Dynamic queries and static queries
| ICS-Integrated-Computer-Solutions | 1 |
| |
| For more SQL Server Interview Questions Click Here |