Given 6 tables and more than 10 queries, all are about joining tables and it was complex
Sql Developer I Interview Questions
1,521 sql developer i interview questions shared by candidates
Experience with the project
What are the files created when a database is created and in which order? Then in which order file is deleted if a particular row is deleted from the table?
Write a stored procedure that accepts a date range to return data from a set of tables
powerbi: can we use measure in a calculated column
self join, cursors and its types, functions, procedures, can we have commit in functions, framing query for business logic
ArrayList, LinkedList, HashMap, HashTable, int,Integer
difference between procedure and function?
he has asked about performance tuning
SQL: Triggers Function syntax Procedure execution Joins how do you optimize slow running query delete and drop Common Table expressions Normalization They will give scenarios and ask you to write the queries. Power Bi: difference of Filter/ slicer page level filters Import mode and direct query Relationships some example scenerio questions: if i take the live data can we refresh the report everyday? if i have 5 lakhs record and 10k records which one you will use import mode or direct mode? Time intelligence functions
Viewing 1281 - 1290 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