.NET database dev questions

[Kalyan]

.NET database dev questions

  31. What is the purpose of using COLLATE in a query?

  32. What is one of the first things you would do to increase performance of a query? For example, a boss tells you that "a query that ran yesterday took 30 seconds, but today it takes 6 minutes"?

  33. What is an execution plan? When would you use it? How would you view the execution plan?

  34. What is the STUFF function and how does it differ from the REPLACE function?

  35. What does it mean to have quoted_identifier on? What are the implications of having it off?

  36. What are the different type of replication? How are they used?

  37. What is the difference between a Local temporary table and a Global temporary table? How is each one used?

  38. What are cursors? Name four type of cursors and when each one would be applied?

  39. What is the purpose of UPDATE STATISTICS?

  40. How do you use DBCC statements to monitor various ASPects of a SQL Server installation?

  41. How do SQL Server 2000 andXML linked? What is SQL Server agent?

  42. What is referential integrity and how can we achieve it?

  43. What is indexing?

  44. Explain differences between server.transfer and server.execute method?

  45. What is de-normalization? When do you do it and how?

  46. Explain features of SQL Server like Scalibility, Availability, Integration with Internet.

  47. What is DataWarehousing?

  48. What is OLAP?

  49. How do we upgrade SQL Server 7.0 to 2000?

  50. What is job?

  51. What is Task?

  52. How would you update the rows which are divisible by 10, given a set of numbers in column?

  53. How do you find the error, how can you know the number of rows affected by last SQL Statement?

  54. What are the advantages/disadvantages of viewstate?

  55. Describe session handling in webform. How does it work and what are the limits?

  56. Explain differences between framework 1.0 and framework 1.1

  57. If we write any code for dataGrid methods, what is the access specifier used for that methods in the code behind file and why and how? Give an example.

  58. What is the use of trace utility?

  59. What are the differences between User control and Web control and Custom control?

  60. If I have more than one version of one assemblies, then how will I use old version in my application? Give an example.

  61. How do you create threadinf in.NET?

  62. Describe the Managed Execution Process.

  63. What is Active Directory? What is the namespace used to access the Microsoft Active Directories?

  64. What are Interop Services?

  65. How does you handle this COM components developed in other programming languages in.NET?

  66. How will you register COM+ services?