** PLEASE DESCRIBE THIS IMAGE **** PLEASE DESCRIBE THIS IMAGE **** PLEASE DESCRIBE THIS IMAGE **
 Your Ad Here
** PLEASE DESCRIBE THIS IMAGE **

** PLEASE DESCRIBE THIS IMAGE **
** PLEASE DESCRIBE THIS IMAGE **
** PLEASE DESCRIBE THIS IMAGE **
Bookmark and Share

IV. SQL SERVER

1. Key features of SQL Server
2. Stored Procedures
3. Diff types of arguments supported SP
4. CAST, CONVERT, CASE
5. Error handling in SP
6. How to debug a SP
7. Identity & Reset Identity (After deletion of records)
8. Transaction Process
9. Joins (inner, outer, cross)
10. Diff between Oracle Cursor & SQL Cursor
11. How SP returns set of rows to an out variable
12. Diff between TRUNCATE & DELETE
13. Max tables that can be used in an SQL
14. Level of sub queries
15. Level of triggers/ stored procedure
16. Diff between UNIQUE & PRIMARY KEY
17. Can FOREIGN KEY have NULL values?
18. Normalization/De-normalization
19. OLAP, OLTP
20. Aggregation Tables
21. Indexing
22. Clustered Index
23. Non clustered Index
24. Evaluating Performance
25. Pages
26. Temporary Tables
27. Declare Cursor
28. @@FETCH_STATUS
29. SET ROWCOUNT
30. Inline & Scalar functions
Freshers Job Alert
** PLEASE DESCRIBE THIS IMAGE **
Freshers Online, Company Question Papers, Interview Tips ,Technical Interview Questions, Learning, , Quick Learn, Resume Tips, Career FAQ, Freshers Jon, Subscribe Job, Training Center,Aptitude puzzle Questions, Software Company job Consultants,Free Online exam,Wiki
Contact Us SiteMap Advertise
� 2000-2005 Fresher's Online, Inc