Quizalize logo
placeholder image to represent content

SQL quiz Final

Quiz by Vibhuti Tagra

Feel free to use or edit a copy

includes Teacher and Student dashboards

Measure skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can
  • edit the questions
  • save a copy for later
  • start a class game
  • automatically assign follow-up activities based on students’ scores
  • assign as homework
  • share a link with colleagues
  • print as a bubble sheet

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
15 questions
Show answers
  • Q1

    GROUP BY is the statement for..

    an union

    a join

    an aggregate function

    a window function

    30s
  • Q2

    Which one is generally a task for a data engineer?

    Creating data ingestion pipelines.

    Making data visualisations, such as graphics.

    Delivering machine learning models into production.

    Creating machine learning models.

    30s
  • Q3

    As a data-driven business, I use data to guide me in decisions.

    False

    True

    30s
  • Q4

    INNER JOIN returns the intersection between two tables.

    True

    False

    30s
  • Q5

    UNION ALL returns data de-duplicated.

    False

    True

    30s
  • Q6

    Which of the following is the correct order of occurrence in a typical SQL statement?

    select, from, having, where, group by

    select, from, group by, where, having

    select, from, where, having, group by 

    select, from, where, group by, having 

    30s
  • Q7

    month(date_parse('11/08/2022', '%m/%d/%Y')), what it returns?

    11

    12

    08

    10

    30s
  • Q8

    Spark allows us to explore fault-tolerance and data parallelism processing.

    True

    False

    30s
  • Q9

    Which of the following is true about CASE SQL statement?

    A way to establish a loop in SQL.

    A way to establish a data definition in SQL.

    All of the above.

    A way to establish an IF-THEN-ELSE in SQL.

    30s
  • Q10

    Which of the following is one of the basic approaches for joining tables?

    Subqueries

    Union Join

    All of the above

    Natural join

    30s
  • Q11

    A join B Which join would you use to create a query that returns ALL data from Table B and only those on Table A that match?

    Right join

    Left Join

    Inner Join

    Full outer join

    30s
  • Q12

    Which of the following is the correct order of execution in a typical SQL statement?

    from, where, group by, having, select

    select, from, group by, where, having

    select, from, having, where, group by

    select, from, where, group by, having 

    30s
  • Q13

    Which file format is suitable for streaming system?

    Apache Avro

    CSV

    Apache Parquet

    ORC

    30s
  • Q14

    Which of the following query would limit the output to 5 rows?

     SELECT * FROM DataFlair LIMIT 5;

     SELECT * FROM DataFlair 5 LIMIT;

    SELECT * FROM DataFlair 5;

     SELECT LIMIT(5) * FROM DataFlair ;

    30s
  • Q15

    Which of the following is not a Clause in SQL?

    Limit

    Group By

    Where

    Below

    30s

Teachers give this quiz to your class