SQL quiz Final
Quiz by Vibhuti Tagra
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
- 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
- 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