what is identity column ?

what are constraints & it's uses?

trigger,trigger for auditing?

local & global varibale?

diffrenece between truncate & delete

what steps are required for query optimisation.

what steps are required for performance optimisation.

how you can use delete?

diffrenece between temp table & table?

what is index & its types?

diffreneec between indexing & partition.

diffrenece between set operetors ,Joins & subquery? advantagaes & disadvanatges in brief.

disadvanatges of procedures

analytical functions and its uses

diffrenece between procedure & functions

designe database schema?

how you can use delete for safe transaction?

what is cursor?lifecycle?advatages? disadvanatges?attributes? write cursor.

5th max salary

what is dynamic query?