what is angular lifecycle, what is lazy loading, how to write event in angular (write code), what is action filter & use , if filter use for authorization why you need [Authorize] attribue? what is jwt auth and how to implement it, have you implement custom SSO, role based authentication , how to know which role is authenticating, and how to implemet? dyamic role based for controller, CTE vs temp table, Global temp vs Local temp, if you have store procedure how to know which part of store procedure is doing slow? , if we redirect a directly url in browser how to know which role is authenticating ?, primary key vs unique key, if unique key is not inserting null should we need a primary key?, what is no-lock in sql and if we don't use transaction and if i only have single select then can we use no-lock