differednc btwn temp table,derived table
Sql Support Interview Questions
2,214 sql support interview questions shared by candidates
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.
over all Oracle related question in depth
It was technical related to my work and technical questions asked based on my skills SQL DBA
about clustering.
Viewing 911 - 920 interview questions