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 ?
Basic questions and hr wasted all my efforts
Technical and coding. Basics of technology.
differednc btwn temp table,derived table
1. Tell me something about yourself? 2.What is difference between method and constructor? 3. what is big O notation in java? 4.How many types of joins are there in SQL?
Most complex / satifying project / work you did.
Difference between rank and dense rank
1. If month inbetween jan and jul then 2022 else 2023. What function used to find and how? 2. Analytical functions example 3. Challenges faced in previous project
Mostly they covered all SQL concepts
Q: What is views and Materialized views.
Viewing 611 - 620 interview questions