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?
What is indexed view?
What is a with(nolock)?
What are acid properties of transaction?
What is difference between clustered and non clustered index?
What is normalization of database?
Where do we use trace frag?