What is basic difference between procedure and function.? What is cursor and why we use cursor? What is analytical functions? what is trigger and how many triggers we can create? What is the difference between truncate and delete? what is Dynamic sql? what is the join and its type ?
It was technical related to my work and technical questions asked based on my skills SQL DBA
about clustering.
Lots of basic analytical query. Performance tuning.
differednc btwn temp table,derived table
Q: What is views and Materialized views.
They have asked technical questions.
To explaining about day to day activities
Technical and coding. Basics of technology.
Call the stored procedure via VBA, return data into excel and format, delete all unused worksheets
Viewing 911 - 920 interview questions