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?
- Retos mas complejos que habia tenido en mi experiencia laboral - Motivación para trabajar en la empresa - Nivel de ingles con una pequeña prueba hablada para validarlo
sql concepts & theory,basic to intermediate
basic sql queries and sql qdvance questions
materialized view , joins , basic SQL functions
nothing as such was difficult jus core knowledge is important.
What is sql explain by realtime scene
What are the subsets of SQL? What is a UNIQUE constraint?
How to change a table name in SQL? How to create a database in SQL? How can I see all tables in SQL?
What are the NVL and the NVL2 functions in SQL? How do they differ? What is the difference between the WHERE and HAVING clauses?
Viewing 2041 - 2050 interview questions