placeholder image to represent content

Day 1 - Basic SQL Functions Review Quiz

Quiz by Tiara Angelica

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

Correct quiz answers unlock more play!

New Quizalize solo game modes
10 questions
Show answers
  • 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

    true
    false
    True or False
    30s
  • 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

    false
    true
    True or False
    30s
  • Q7

    BigQuery is case sensitive

    true
    false
    True or False
    30s
  • 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

    true
    false
    True or False
    30s

Teachers give this quiz to your class