What are cursors and when they are useful?
What is raid and what are different types of raid levels?
What do you understand by a view? What does the with check option clause for a view do?
Define views.
What is cte (common table expression)?
What do you mean by an execution plan? Why is it used?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
Describe in brief system database.
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is normalization of database? What are its benefits?
What is difference between index seek vs. Index scan?
Explain indexed views?
What are the properties of the relational tables?
What are the restrictions that views have to follow?
What are various aggregate functions that are available?