1. What is Rule ?
2. What is difference between function and Stored Procedure?
3. What is difference between Rule and Constraint?
a. Rule created as separate object, constraint created as part of table
b. We can apply only one rule per column, where we can apply mulitple constraints
to columns
4. What is difference between Constraint and Trigger?
5. How many output parameters we can give to stored procedure?
6. How to access ther results of one sp in another sp?
7. What / which areas u will check in a long running SP?
8. When to use Cluster and Non cluster Index ?
If you have to sort by a particular column often, consider making that column a clustered index.
9. what are new datatypes in sql 2000?
BigInt, sql_variant, Table
10. what is global Temprorary variable / Table ?
11. What is Index how many types are they?
12. what are the new features in sql 2000?
13. What is Instead of Trigger ?
1. The triggers whcih can define on Tables / Views to replace the standard action of Insert / Delete / Update.
2. With help of Instead of Triggers we can update / Delete / Insert to Views which are constructed by multiple base tables.
3. INSTEAD OF triggers is that they allow you to code logic that can reject parts of a batch while allowing other parts of a batch succeed.
14. How to handel errors in SP?
15. what are materialized views?
The process of building the view results is called materializing the view
16. What is difference between Delete and Truncate
Delete is logged operation, Truncate is not logged operation and set Identity to starting point.
17. What is Default
Action taken on ceratin events when user didnt specify any action to take.
18. What is Correlated subQuery (repeating subquery) ?
In this the innerquery executes repeatedly, once for each possible outer query result