| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| WHAT OPERATOR PERFORMS PATTERN MATCHING? | CTS | 2 |
| Explain the storage models of OLAP? | | 1 |
| What is user stored procedure & it purpose? | Wipro | 3 |
| Explain Active/Active and Active/Passive cluster
configurations? | | 1 |
| 1.what is stored procedure?Its significance with example?
2.Explain about index with syntax and example?
plz do reply......... | | 1 |
| what is index seek and index scan? | | 2 |
| How do SQL server 2000 and XML linked? | | 2 |
| what are file groups? | Evalueserve | 3 |
| PC(code, model, speed, ram, hd, cd, price)
Find the hard drive sizes that are equal among two or more
PCs.
| APX | 2 |
| How to select Distinct columns from the table, table having
20 columns and i want all coulmns | Wipro | 3 |
| Difference between Function and Stored Procedure? | C1-India | 4 |
| Can anybody explain me cold backup and hot backup?
| TCS | 3 |
| Can you create UNIQUE and PRIMARY KEY constraints on
computed columns in SQL Server 2000? | Infosys | 1 |
| Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed) | | 5 |
| Is it possible to have more then one foreign key in a
single table? if possible, is this the good way to design
the table? | | 2 |
| What are the magic tables in SQL Server 2000? | Infogain | 5 |
| select the 3rd maximum salary from sql server database if 4
(just an example In practically I may not know the exact
situation) of the highest salaries are equal. | | 7 |
| Explain Trigger with an example?
| | 1 |
| What is a Lock and let me know Different types of locks? | | 1 |
| How are SQL Server databases physically stored under
Windows 2000? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
