queries using group by Clause
Sql Developer I Interview Questions
1,524 sql developer i interview questions shared by candidates
basic c++
Write SQL Statement psudeo code on the white board
1.) types of joins? 2.) Difference between subquery and inner query? 3.) NVL function? 4.) Stored procedures? advantages? 5.) SQL Injection? 6.) polymorphism? 7.) Virtual function in c++ 8.) Syntax for memory allocation and how to free the memory? 9.) Function pointer? 10.) What is template? 11.) working with trigger 12.) Q# Programming language in microsoft?
Basically, they asked that are you comfortable with if you have to work on our own platform that is t24.
2 hrs sql test is on a computer where the database is build and the questions to related to the data in the tables.
what is like clause?
Basic sql/pl sql questions, like subquery, group by, join, left join , right join , Packages, functions, procedures, views. Very very easy to answer, they only pay attention about skills, not too much experiences, that is it.
Temporal Tables, CDC, CTE & Recursive CTE, Rank vs Dense_rank, Lead & Lag, INDEXSCAN vs INDEXSEEK, Nested Hash vs Merge Joins, Merge statement and few basic SQL Query questions.
Más que todo Experiencia y conocimientos
Viewing 1021 - 1030 interview questions