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
Degrees calculating between hour and minute hand in the clock
Why MVC, javascript?
Basic questions and hr wasted all my efforts
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.
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
Interviewer gave two tables and asked number of rows after inner, left outer, right outer joins
Q: What is views and Materialized views.
Viewing 891 - 900 interview questions