placeholder image to represent content

SQL quiz Final

Quiz by Vibhuti Tagra

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