1. What is XML?
2. What is the version information in XML?
3. What is ROOT element in XML?
4. If XML does not have closing tag will it work?
5. Is XML case sensitive?
6. What’s the difference between XML and HTML?
7. Is XML meant to replace HTML?
8. Can you explain why your project needed XML?
9. What is DTD (Document Type definition)?
10. What is well formed XML?
11. What is a valid XML?
12. What is CDATA section in XML?
13. What is CSS?
14. What is XSL?
15. What is Element and attributes in XML?
16. Can we define a column as XML?
17. How do we specify the XML data type as typed or untyped?
18. How can we create the XSD schema?
19. How do I insert in to a table which has XSD schema attached to it?
20. What is maximum size for XML datatype?
21. What is Xquery?
22. What are XML indexes?
23. What are secondary XML indexes?
24. What is FOR XML in SQL Server?
25. Can I use FOR XML to generate SCHEMA of a table and how?
26. What is the OPENXML statement in SQL Server?
27. I have huge XML file which we want to load in database?
28. How to call stored procedure using HTTP SOAP?
29. What is XMLA?
.NET Integration
1. What are steps to load a .NET code in SQL SERVER 2005?
2. How can we drop an assembly from SQL SERVER?
3. Are changes made to assembly updated automatically in database?
4. Why do we need to drop assembly for updating changes?
5. How to see assemblies loaded in SQL Server?
6. I want to see which files are linked with which assemblies?
7. Does .NET CLR and SQL SERVER run in different process?
8. Does .NET controls SQL SERVER or is it vice-versa?
9. Is SQLCLR configured by default?
10. How to configure CLR for SQL SERVER?
11. Is .NET feature loaded by default in SQL Server?
12. How does SQL Server control .NET run-time?
13. What’s a “SAND BOX” in SQL Server 2005?
14. What is an application domain?
15. How are .NET Appdomain allocated in SQL SERVER 2005?
16. What is Syntax for creating a new assembly in SQL Server 2005?
17. Do Assemblies loaded in database need actual .NET DLL?
18. You have a assembly which is dependent on other assemblies, will SQL Server load the dependent assemblies?
19. Does SQL Server handle unmanaged resources?
20. What is Multi-tasking?
21. What is Multi-threading?
22. What is a Thread ?
23. Can we have multiple threads in one App domain?
24. What is Non-preemptive threading?
25. What is pre-emptive threading?
26. Can you explain threading model in SQL Server?
27. How does .NET and SQL Server thread work?
28. How is exception in SQLCLR code handled?
29. Are all .NET libraries allowed in SQL Server?
30. What is “Hostprotectionattribute” in SQL Server 2005?
31. How many types of permission level are there for an assembly?
32. In order that an assembly gets loaded in SQL Server what type of checks are done?
33. Can you name system tables for .NET assemblies?
34. Are two version of same assembly allowed in SQL Server?
35. How are changes made in assembly replicated?
36. Is it a good practice to drop a assembly for changes?
37. In one of the projects following steps where done, will it work?
38. What does Alter assembly with unchecked data signify?
39. How do I drop an assembly?
40. Can we create SQLCLR using .NET framework 1.0?
41. While creating .NET UDF what checks should be done?
42. How do you define a function from the .NET assembly?
43. Can you compare between T-SQL and SQLCLR?
44. With respect to .NET is SQL SERVER case sensitive?
45. Does case sensitive rule apply for VB.NET?
46. Can nested classes be accessed in T-SQL?
47. Can we have SQLCLR procedure input as array?
48. Can object datatype be used in SQLCLR?
49. How’s precision handled for decimal datatypes in .NET?
50. How do we define INPUT and OUTPUT parameters in SQLCLR?
51. Is it good to use .NET datatypes in SQLCLR?
52. How to move values from SQL to .NET datatypes?
53. What is System.Data.SqlServer?
54. What is SQLContext?
55. Can you explain essential steps to deploy SQLCLR?
56. How do create function in SQL Server using .NET?
57. How do we create trigger using .NET?
58. How to create User Define Functions using .NET?
59. How to create aggregates using .NET?
60. What is Asynchronous support in ADO.NET?
61. What is MARS support in ADO.NET?
62. What is SQLbulkcopy object in ADO.NET?
63. How to select range of rows using ADO.NET?
64. What are different types of triggers in SQl SERVER 2000 ?
65. If we have multiple AFTER Triggers on table how can we define the sequence of the triggers ?
66. How can you raise custom errors from stored procedure ?
2. How can we drop an assembly from SQL SERVER?
3. Are changes made to assembly updated automatically in database?
4. Why do we need to drop assembly for updating changes?
5. How to see assemblies loaded in SQL Server?
6. I want to see which files are linked with which assemblies?
7. Does .NET CLR and SQL SERVER run in different process?
8. Does .NET controls SQL SERVER or is it vice-versa?
9. Is SQLCLR configured by default?
10. How to configure CLR for SQL SERVER?
11. Is .NET feature loaded by default in SQL Server?
12. How does SQL Server control .NET run-time?
13. What’s a “SAND BOX” in SQL Server 2005?
14. What is an application domain?
15. How are .NET Appdomain allocated in SQL SERVER 2005?
16. What is Syntax for creating a new assembly in SQL Server 2005?
17. Do Assemblies loaded in database need actual .NET DLL?
18. You have a assembly which is dependent on other assemblies, will SQL Server load the dependent assemblies?
19. Does SQL Server handle unmanaged resources?
20. What is Multi-tasking?
21. What is Multi-threading?
22. What is a Thread ?
23. Can we have multiple threads in one App domain?
24. What is Non-preemptive threading?
25. What is pre-emptive threading?
26. Can you explain threading model in SQL Server?
27. How does .NET and SQL Server thread work?
28. How is exception in SQLCLR code handled?
29. Are all .NET libraries allowed in SQL Server?
30. What is “Hostprotectionattribute” in SQL Server 2005?
31. How many types of permission level are there for an assembly?
32. In order that an assembly gets loaded in SQL Server what type of checks are done?
33. Can you name system tables for .NET assemblies?
34. Are two version of same assembly allowed in SQL Server?
35. How are changes made in assembly replicated?
36. Is it a good practice to drop a assembly for changes?
37. In one of the projects following steps where done, will it work?
38. What does Alter assembly with unchecked data signify?
39. How do I drop an assembly?
40. Can we create SQLCLR using .NET framework 1.0?
41. While creating .NET UDF what checks should be done?
42. How do you define a function from the .NET assembly?
43. Can you compare between T-SQL and SQLCLR?
44. With respect to .NET is SQL SERVER case sensitive?
45. Does case sensitive rule apply for VB.NET?
46. Can nested classes be accessed in T-SQL?
47. Can we have SQLCLR procedure input as array?
48. Can object datatype be used in SQLCLR?
49. How’s precision handled for decimal datatypes in .NET?
50. How do we define INPUT and OUTPUT parameters in SQLCLR?
51. Is it good to use .NET datatypes in SQLCLR?
52. How to move values from SQL to .NET datatypes?
53. What is System.Data.SqlServer?
54. What is SQLContext?
55. Can you explain essential steps to deploy SQLCLR?
56. How do create function in SQL Server using .NET?
57. How do we create trigger using .NET?
58. How to create User Define Functions using .NET?
59. How to create aggregates using .NET?
60. What is Asynchronous support in ADO.NET?
61. What is MARS support in ADO.NET?
62. What is SQLbulkcopy object in ADO.NET?
63. How to select range of rows using ADO.NET?
64. What are different types of triggers in SQl SERVER 2000 ?
65. If we have multiple AFTER Triggers on table how can we define the sequence of the triggers ?
66. How can you raise custom errors from stored procedure ?
Data Warehousing/Data Mining
1. What is “Data Warehousing”?
2. What are Data Marts?
3. What are Fact tables and Dimension Tables?
4. What is Snow Flake Schema design in database?
5. What is ETL process in Data warehousing?
6. How can we do ETL process in SQL Server?
7. What is “Data mining”?
8. Compare “Data mining” and “Data Warehousing”?
9. What is BCP?
10. How can we import and export using BCP utility?
11. In BCP we want to change field position or eliminate some fields how can we achieve this?
12. What is Bulk Insert?
13. What is DTS?
14. Can you brief about the Data warehouse project you worked on?
15. What is an OLTP (Online Transaction Processing) System?
16. What is an OLAP (On-line Analytical processing) system?
17. What is Conceptual, Logical and Physical model?
18. What is Data purging?
19. What is Analysis Services?
20. What are CUBES?
21. What are the primary ways to store data in OLAP?
22. What is META DATA information in Data warehousing projects?
23. What is multi-dimensional analysis?
24. What is MDX?
25. How did you plan your Data ware house project?
26. What are different deliverables according to phases?
27. Can you explain how analysis service works?
28. What are the different problems that “Data mining” can solve?
29. What are different stages of “Data mining”?
30. What is Discrete and Continuous data in Data mining world?
31. What is MODEL is Data mining world?
32. How are models actually derived?
33. What is a Decision Tree Algorithm?
34. Can decision tree be implemented using SQL?
35. What is Naïve Bayes Algorithm?
36. Explain clustering algorithm?
37. Explain in detail Neural Networks?
38. What is Back propagation in Neural Networks?
39. What is Time Series algorithm in data mining?
40. Explain Association algorithm in Data mining?
41. What is Sequence clustering algorithm?
42. What are algorithms provided by Microsoft in SQL Server?
43. How does data mining and data warehousing work together?
44. What is XMLA?
45. What is Discover and Execute in XMLA?
2. What are Data Marts?
3. What are Fact tables and Dimension Tables?
4. What is Snow Flake Schema design in database?
5. What is ETL process in Data warehousing?
6. How can we do ETL process in SQL Server?
7. What is “Data mining”?
8. Compare “Data mining” and “Data Warehousing”?
9. What is BCP?
10. How can we import and export using BCP utility?
11. In BCP we want to change field position or eliminate some fields how can we achieve this?
12. What is Bulk Insert?
13. What is DTS?
14. Can you brief about the Data warehouse project you worked on?
15. What is an OLTP (Online Transaction Processing) System?
16. What is an OLAP (On-line Analytical processing) system?
17. What is Conceptual, Logical and Physical model?
18. What is Data purging?
19. What is Analysis Services?
20. What are CUBES?
21. What are the primary ways to store data in OLAP?
22. What is META DATA information in Data warehousing projects?
23. What is multi-dimensional analysis?
24. What is MDX?
25. How did you plan your Data ware house project?
26. What are different deliverables according to phases?
27. Can you explain how analysis service works?
28. What are the different problems that “Data mining” can solve?
29. What are different stages of “Data mining”?
30. What is Discrete and Continuous data in Data mining world?
31. What is MODEL is Data mining world?
32. How are models actually derived?
33. What is a Decision Tree Algorithm?
34. Can decision tree be implemented using SQL?
35. What is Naïve Bayes Algorithm?
36. Explain clustering algorithm?
37. Explain in detail Neural Networks?
38. What is Back propagation in Neural Networks?
39. What is Time Series algorithm in data mining?
40. Explain Association algorithm in Data mining?
41. What is Sequence clustering algorithm?
42. What are algorithms provided by Microsoft in SQL Server?
43. How does data mining and data warehousing work together?
44. What is XMLA?
45. What is Discover and Execute in XMLA?
Integration Services/DTS
1. What is Integration Services import / export wizard?
2. What are prime components in Integration Services?
3. How can we develop a DTS project in Integration Services?
2. What are prime components in Integration Services?
3. How can we develop a DTS project in Integration Services?
Database Optimization
1. What are indexes
2. What are B-Trees?
3. I have a table which has lot of inserts, is it a good database design to create indexes on that table?
4. What are “Table Scan’s” and “Index Scan’s”?
5. What are the two types of indexes and explain them in detail?
6. What is “FillFactor” concept in indexes?
7. What is the best value for “FillFactor”?
8. What are “Index statistics”?
9. How can we see statistics of an index?
10. How do you reorganize your index, once you find the problem?
11. What is Fragmentation?
12. How can we measure Fragmentation?
13. How can we remove the Fragmented spaces?
14. What are the criteria you will look in to while selecting an index?
15. What is “Index Tuning Wizard”?
16. What is an Execution plan?
17. How do you see the SQL plan in textual format?
18. What is nested join, hash join and merge join in SQL Query plan?
19. What joins are good in what situations?
20. What is RAID and how does it work
2. What are B-Trees?
3. I have a table which has lot of inserts, is it a good database design to create indexes on that table?
4. What are “Table Scan’s” and “Index Scan’s”?
5. What are the two types of indexes and explain them in detail?
6. What is “FillFactor” concept in indexes?
7. What is the best value for “FillFactor”?
8. What are “Index statistics”?
9. How can we see statistics of an index?
10. How do you reorganize your index, once you find the problem?
11. What is Fragmentation?
12. How can we measure Fragmentation?
13. How can we remove the Fragmented spaces?
14. What are the criteria you will look in to while selecting an index?
15. What is “Index Tuning Wizard”?
16. What is an Execution plan?
17. How do you see the SQL plan in textual format?
18. What is nested join, hash join and merge join in SQL Query plan?
19. What joins are good in what situations?
20. What is RAID and how does it work
Subscribe to:
Posts (Atom)