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
Sql Developer I Interview Questions
1,524 sql developer i interview questions shared by candidates
Mostly they covered all SQL concepts
Q: What is views and Materialized views.
over all Oracle related question in depth
Mostly on sql
Interviewer gave two tables and asked number of rows after inner, left outer, right outer joins
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
Viewing 611 - 620 interview questions
See Interview Questions for Similar Jobs
Sql DeveloperSql Database DeveloperPlsql DeveloperSql Database EngineerData And Reporting AnalystIt Pl Sql Developer Data AnalystSenior Database DeveloperSql Server Database DeveloperSql Database AdministratorSql Server Database-ontwikkelaarSas Etl DeveloperSenior Sql DeveloperEtl DeveloperJunior Oracle Database AdministratorVba Excel-ontwikkelaarSenior Data Stage DeveloperSql Server Database BeheerderTalend Etl Developer