What was your role during your OJT and what have you done during your training? (Non-verbatim)
Sql Programmer Interview Questions
1,521 sql programmer interview questions shared by candidates
Most of the questions from a technical perspective were case based scenarios - they would give me a data set and ask me to write the SQL code to extract the desired outcome. From a business perspective, most of the conversation centered around project management and communication.
1-SQL commands , 2- diff between truncate and delete 3- SQL optimization
A lot of SQL specific questions and knowledge on financial market
SQL case study to create a data collecting and computing logic.
2nd round: Given a School DB with Professor, Student, Class, Score tables. 1) How many classes does each professor teach? 2) Display AverageScoreForClass and AverageScoreForProfessor. 3) Write a SP to get a student’s score 4) Display StudentName, ClassName, MAX(Score) which got max score for each class. How to optimize a SSIS package? How to use Checkpoint?
sql concepts & theory,basic to intermediate
basic sql queries and sql qdvance questions
materialized view , joins , basic SQL functions
What is sql explain by realtime scene
Viewing 1401 - 1410 interview questions