| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Which data type can be used only on OUTPUT parameters of the
stored proceduer? | | 2 |
| Can you explain the types of Joins that we can have with Sql
Server? | | 2 |
| what is the main difference between after trigger and
instead trigger. | | 1 |
| Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not? | | 3 |
| Is it possible to create tables in stored procedures using
a variable for the table name? | | 2 |
| Explain different isolation levels? | | 3 |
| How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name? | | 3 |
| How do you measure the performance of a stored procedure? | Infosys | 1 |
| Let us say master db itself has no backup. Now you have to
rebuild the db so what kind of action do you take? | | 1 |
| What is transcation?Plz give One example? | | 2 |
| can you any body tell me while running BCP Out in instance
in sql server 2000 is getting error.
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server does not exist or access denied.?
| | 1 |
| Which system tables contain information on privileges
granted and privileges obtained | | 1 |
| How the data stores in a page? | | 1 |
| UPDATE statement can on a single table or on the multiple
table? | iGate | 5 |
| can you any body tell me suppose database is suspect mode.
how can take to normal? | Teledata | 1 |
| Please tell me some knowledge about Clustering and how to
add clustering? | | 1 |
| What are SQL Jobs, please mention the use of it and how to
create them. | 247Customer | 1 |
| Which virtual table does a trigger use? | TCS | 6 |
| what is difference between having and where clause ? | | 2 |
| What is a function? Give some example? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
