H446 SQL

Which SQL command is used to retrieve data from a table?

• GET

• SELECT

• EXTRACT

• SHOW

Which clause is used to choose the table to read data from?

• WHERE

• TABLE

• FROM

• ORDER BY

Which SQL statement returns all fields from the `Student` table?

• SELECT ALL Student;

• SELECT * FROM Student;

• GET * IN Student;

• SHOW Student.*;

Which clause is used to filter rows?

• SORT

• WHERE

• ORDER

• FILTER

Which query returns all students with the surname `Patel`?

• SELECT * FROM Student WHERE Surname = 'Patel';

• SELECT Surname FROM Student = 'Patel';

• SELECT * Student WHERE Surname = 'Patel';

• GET * FROM Student WHERE Surname = 'Patel';

Which operator means 'both conditions must be true'?

• OR

• NOT

• AND

• XOR

Which query finds students in Year 12 who study Computing?

• SELECT * FROM Student WHERE Year = 12 OR Subject = 'Computing';

• SELECT * FROM Student WHERE Year = 12 AND Subject = 'Computing';

• SELECT * FROM Student WHERE Year = 12 NOT Subject = 'Computing';

• SELECT * FROM Student WHERE Year = 12, Subject = 'Computing';

Which keyword is used to sort query results?

• GROUP BY

• SORT BY

• ORDER BY

• ARRANGE BY

Which query sorts students by surname in ascending order?

• SELECT * FROM Student ORDER BY Surname ASC;

• SELECT * FROM Student SORT Surname ASC;

• SELECT * FROM Student ORDER Surname;

• SELECT * FROM Student BY Surname ASC;

Which keyword sorts in descending order?

• ASC

• REV

• DOWN

• DESC