Quiz

SQL quiz: joins, WHERE vs HAVING and more

A quick SQL quiz on SELECT and the core statements, WHERE vs HAVING, INNER and outer joins, DROP TABLE vs DELETE, and phantom reads under READ COMMITTED.

  • 6 min read
  • 5 questions
  • +35 XP
Transcript

Can you answer these five SQL questions? Let's find out. Question 1 Which SQL statement is used to retrieve rows from a table? (*clicking*) (*clicking*) (*clicking*) (*ding*) Question 2 Which clause is used to filter rows before grouping? (*clicking*) (*clicking*) (*clicking*) (*ding*) Question 3 Which JOIN returns only rows with matches in both tables?

(*clicking*) (*clicking*) (*clicking*) (*ding*) Question 4 Which SQL command removes a table and all its data from the database schema? (*clicking*) (*clicking*) (*clicking*) (*ding*) Question 5 In transaction isolation, which anomaly can still occur under READ COMMITTED? (*clicking*) (*clicking*) (*clicking*) (*clicking*) (*ding*) How many answers did you get right? Comment on the video. (*upbeat music*)