When we should use and scope of @@identity?
Is Sql non procedural query language?
what is extended StoreProcedure ?
When do u use clustered index and non-clustered index?
To which devices can a backup be created and where should these devices be located? : sql server management studio
What are the properties and different types of sub-queries?
Can foreign key be deleted?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What are the types of resultset?
Explain the different types of backups available in sql server? : sql server database administration
What are 3 ways to get a count of the number of records in a table?
what is spatial nonclustered index
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture