what is surrogate key, explain scd type 2 informatica, how to improve query performance in sql, explain your projects, how to find duplicates, how to delete duplicates, joins in sql, difference between lookup and joiner, which one is faster, types of lookup
To explaining about day to day activities
Technical and coding. Basics of technology.
Lots of basic analytical query. Performance tuning.
Q: What is views and Materialized views.
Basic questions and hr wasted all my efforts
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
Mostly they covered all SQL concepts
over all Oracle related question in depth
Viewing 891 - 900 interview questions