Froggy Jumps Computer Science - SQL Lesson 3 StarterOnline version Computer Science - SQL Lesson 3 Starter by Mr Habib 1 What does the SELECT statement do in SQL? a Retrieves data from a table b Updates data in a table c Deletes data from a table 2 Which clause is used to filter records in SQL? a WHERE b ORDER BY c GROUP BY 3 Which SQL keyword is used to specify the table to query? a FROM b SELECT c WHERE 4 What does the ORDER BY clause do? a Sorts the result set b Deletes duplicate rows c Filters rows based on condition 5 Which comparison operator means 'not equal to' in SQL? a <> b = c >< 6 Which operator is used to compare if a value is greater than another? a > b < c <> 7 Which SQL clause is used to sort results in descending order? a ORDER BY DESC b ORDER BY ASC c SORT BY DESC 8 Which of the following is a valid SQL SELECT statement? a SELECT * FROM table_name; b GET * FROM table_name; c FETCH * FROM table_name; 9 Which clause would you use to get records where age is greater than 30? a WHERE age > 30 b WHERE age < 30 c WHERE age >= 30 10 Which operator checks if two values are equal in SQL? a = b == c != 11 What is the correct order of SQL clauses in a SELECT statement? a SELECT, FROM, WHERE, ORDER BY b SELECT, WHERE, FROM, ORDER BY c WHERE, SELECT, FROM, ORDER BY
New game