| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the disadvantage of using subquery exact after a
select statement?ex.
select (select * from sometable) | | 1 |
| 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 are file groups? | Evalueserve | 3 |
| How to create logins using windows Authentication mode? | | 2 |
| Can you explain the role of each service? | | 1 |
| Can we use Truncate command on a table which is referenced
by FOREIGN KEY? | | 2 |
| How do we return a record set from a Stored Procedure in SQl
server 2000? | | 2 |
| What are sub-queries? Give example? In which case
sub-queries are not feasible? | Infosys | 3 |
| How To Make password Protected SQL Server 2005 Database
i.e when i open SQL Server database then ask for password.
| | 1 |
| What is a function? Give some example? | | 2 |
| Questions on identity? | Infosys | 1 |
| How do I list the available tables in a database I'm
querying? | | 3 |
| How to Debug a Stored Procedure? | Allianz | 4 |
| How do you find the error, how can you know the number of
rows effected by last SQL statement? | | 2 |
| Which virtual table does a trigger use? | TCS | 6 |
| What is the purpose of UPDATE STATISTICS? | | 1 |
| There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better? | | 1 |
| write the query for taking database restore in sql? | | 2 |
| What types of integrity are enforced by a foreign-key
constraint | | 1 |
| What is MSDE? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |