| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| A table contains list of customers and his city with other
details. Each customer has a unique number and the table
consists millions of data. Query is: I want to retrieve 10
customers from each city, no script, only from single query? | Infosys | 3 |
| what is replication?
where do u use Go Keyword?
| Satyam | 1 |
| How do we return a record set from a Stored Procedure in SQl
server 2000? | | 2 |
| What is an Index? | Yardi-Software | 3 |
| What is user stored procedure & it purpose? | Wipro | 3 |
| select top 5 * from emp order by newid()
my question is , how this query get executed? | | 4 |
| What is the appropriate number of test cases that you can
write on a database? | Microsoft | 1 |
| What are the advantages of using stored procedures? Please
don't simply say compilation time will be saved as they are
already complied. Please specify some other advantages. | 247Customer | 3 |
| any one can explain
Self mapping
Delegation
Remote Credentials | | 1 |
| one table has four field id,name,design,salary. i have to
find maximum salary . | | 6 |
| what is cluster and nin-cluster index? | | 4 |
| Can we create a clustered index on composite primary key. | | 2 |
| what is a cursor and what is its use? | | 1 |
| What is data integrity? Explain constraints? | Thinksoft | 1 |
| What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same? | Microsoft | 2 |
| Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement | | 2 |
| WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT? | | 5 |
| Which is the subset of SQL commands used to manipulate
Oracle Database structures, including tables? | | 2 |
| how will u create "n" possible tables in sql...
| Oracle | 1 |
| Anyone please explain me the concept of Serialization? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
