| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the difference between constraints and triggers? | Wipro | 6 |
| what are default? Is there a column to which a default cant be
bound? | | 1 |
| What are three SQL keywords used to change or set someone?s
permissions? | | 3 |
| any one can explain
Self mapping
Delegation
Remote Credentials | | 1 |
| what is Constraint? How many types of constraints in SQL ? | NIIT | 7 |
| what are three different authentications to connect linked
servers? | CitiGroup | 1 |
| How do we get month name in SQL Server 2000, Oracle, MS Access? | | 9 |
| What is an execution plan? When would you use it? How would
you view the execution plan? | | 1 |
| 1.what is the difference between view and cursor?
2.If we do any change in view will it affect the
database,similarly when we do changes in cursor will it
affect the databse?with certain example?Thanks
| | 3 |
| What is transcation?Plz give One example? | | 2 |
| How To Change Column Ordinal Position in SQL Server 2005
using Query i.e I Want To Add Column at Particular Ordinal
Position in SQL Server 2005 | | 2 |
| Let’s say the table in the database is named as
TBL_Register. The fields in this table include:
1. User_Name,
2. User_Telephone,
3. Register_Date
The field Register_Date stores the current date and time of
the registration.
Write the SQL statement that inserts the data into the
table. | Techno-Solutions | 2 |
| how do u do Performance tunning ?
| Satyam | 1 |
| Difference between Triggers and Stored Procedure | Protech | 9 |
| What is the difference Between Sql-server 2000 & 2005 | Value-Labs | 2 |
| what is difference between primary key and Unique | | 8 |
| What meant by Performance Tuning,how can we do the
performance tuning on stored procedures and tell some steps
to do the performance tuning | TCS | 2 |
| What is the system function to get the current user's user
id? | HCL | 1 |
| write the query for taking database restore in sql? | | 2 |
| What is indexed views?
plz explain with example? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
