64. What is referential integrity and how is it achieved
65. What is indexing
66. What is normalization and what are the different forms of normalizations
67. Difference between server.transfer and server.execute method
68. What id de-normalization and when do you do it
69. What is better – 2nd Normal form or 3rd normal form Why
70. Can we rewrite subqueries into simple select statements or with joins Example
71. What is a function Give some example
72. What is a stored procedure
73. Difference between Function and Procedure-in general
74. Difference between Function and Stored Procedure
75. Can a stored procedure call another stored procedure. If yes what level and can it be controlled
76. Can a stored procedure call itself(recursive). If yes what level and can it be controlled.
77. How do you find the number of rows in a table
78. Difference between Cluster and Non-cluster index
79. What is a table called, if it does not have neither Cluster nor Non-cluster Index
80. Explain DBMS, RDBMS
81. Explain basic SQL queries with SELECT from where Order By, Group By-Having
82. Explain the basic concepts of SQL server architecture
83. Explain couple pf features of SQL server
84. Scalability, Availability, Integration with internet, etc.)
85. Explain fundamentals of Data ware housing & OLAP
86. Explain the new features of SQL server 2000
88. What is data integrity Explain constraints
89. Explain some DBCC commands
90. Explain sp_configure commands, set commands
91. Explain what are db_options used for
92. What is the basic functions for master, msdb, tempdb databases
93. What is a job
94. What are tasks
95. What are primary keys and foreign keys
96. How would you Update the rows which are divisible by 10, given a set of numbers in column
97. If a stored procedure is taking a table data type, how it looks
98. How m-m relationships are implemented
99. How do you know which index a table is using
100. How will oyu test the stored procedure taking two parameters namely first name and last name returning full name
101. How do you find the error, how can you know the number of rows effected by last SQL statement
102. How can you get @@error and @@rowcount at the same time
103. What are sub-queries Give example In which case sub-queries are not feasible
104. What are the type of joins When do we use Outer and Self joins
105. Which virtual table does a trigger use
106. How do you measure the performance of a stored procedure
107. Questions regarding Raiseerror
108. Questions on identity
109. If there is failure during updation of certain rows, what will be the state