N5 DBDD Queries

What is the primary use of Structured Query Language (SQL)?

• To design computer hardware

• To generate queries and interrogate data in a database

• To develop mobile applications

• To create web pages

Which of the following is NOT a key word of SQL?

• PRINT

• WHERE

• FROM

• SELECT

In the context of SQL, what does the 'SELECT' statement do?

• Retrieves data from a database

• Deletes data from a database

• Creates a new database

• Updates data in a database

What is the purpose of the 'WHERE' clause in SQL?

• To join two tables

• To sort the results

• To filter records based on a condition

• To specify the database to use

Which SQL clause is used to sort the result-set?

• GROUP BY

• SORT BY

• ORDER BY

• SORT

Which of the following SQL statements could you use If you want to select the username, e-mail and postcode fields from a table named ‘users’?

• SELECT users FROM username, e-mail, postcode;

• 
  FROM users SELECT username, email, postcode;

• 
  SELECT username, email, postcode FROM users;

Which of the following would be returned if this command were executed?

SELECT PupilID, Surname, Class FROM Pupil

WHERE Class = ‘1T1’;

• The pupil field from the PupilID, Surname and Class tables, where the class in each table is 1T1

• 
  The value 1T1, if it appears in either the PupilID, Surname or Class fields within the pupil table

• 
  Data held in the PupilID, Surname and Class fields from the pupil table where the class field holds the value 1T1

What would need to be added to this SQL example to sort the data by class in ascending order and merit points in descending order?

• 
  ORDER BY class ASC, merit points ASC;

• ORDER BY class ASC, merit points DESC;

• 
  ORDER by merit points DESC, class ASC;