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
Sql Programmer Interview Questions
1,521 sql programmer interview questions shared by candidates
powerbi: can we use measure in a calculated column
Basic SQL commands
Tell me about yourself,
Are you familiar with stored procedures? Describe your experience using stored procedures.
Difference between a view and materialized view? Can we modify a view? if any view is modifiable? Difference between PLSQL table and Varray? Have you ever used utl_file package? Write a program to bulk insert into a table using FORALL ? Find the 2nd highest salary of an employee? Difference between procedure and function
one query on self join
what is trigger?
Some multiple SQL tables like employee, manager are given and based upon them there some questions like salary, manager etc.
would like to keep it secret lol.
Viewing 1291 - 1300 interview questions