Day 1 - Basic SQL Functions Review Quiz
Quiz by Tiara Angelica
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
Which SQL keyword is used to specify the table(s) from which data should be retrieved?
FROM
INTO
SELECT
WHERE
30s - Q2
Logical operators 'IN' syntax can consist of multiple values
truefalseTrue or False30s - Q3
In BigQuery, what can you do to reduce query cost and improve query performance?
Always retrieve all columns in your SELECT statement
Use efficient data partitioning and clustering
Avoid using indexes
Write longer and more complex queries
30s - Q4
Order the syntax
SELECT.... WHERE.... FROM.... ORDER....
SELECT.... WHERE.... FROM.... ORDER BY....
SELECT.... FROM.... WHERE.... ORDER....
SELECT.... FROM.... WHERE.... ORDER BY...
30s - Q5
What SQL clause is used to filter rows based on a specified condition?
FROM
SELECT
WHERE
ORDER BY
30s - Q6
Logical operators "<>" and "!=" will NOT have the same result
falsetrueTrue or False30s - Q7
BigQuery is case sensitive
truefalseTrue or False30s - Q8
What is the operator for 'not similar' in query expression?
/=
!=
not =
==
30s - Q9
Which data types need quote ('.....') or (".....")?
Integer
Float
Boolean
Date
30s - Q10
To exclude several values, you can use "NOT IN" logical operators
truefalseTrue or False30s