SQL Quiz

What is SQL primarily used for in a relational database?

• Creating and deleting user accounts

• Querying and updating tables

• Designing graphical interfaces

• Managing network connections

Which SQL clause is used to specify the source table(s) for the data?

• SELECT

• FROM

• WHERE

• ORDER BY

What is the default sorting order of the results in an SQL query if not explicitly specified?

• Descending

• Random

• Ascending

• Alphabetical

Which of the following is NOT a purpose of the SELECT statement in SQL?

• To delete data from a table

• To extract data from a table

• To list the fields to be displayed

• To specify the criteria for data selection

What SQL operator is used to select records where a field does not contain any value?

• BETWEEN

• LIKE

• IS NULL

• NOT

Which SQL operator is used to find records where the field value is greater than a specified value?

• >

• <

• =

• LIKE

What does the SQL operator 'BETWEEN...AND' do?

• Selects values within a given range

• Compares values for inequality

• Matches a pattern

• Checks for values outside a range

Which SQL operator would you use to find records where a field contains part of a text?

• IS NULL

• IN

• LIKE

• NOT

What SQL keyword is used to specify the order in which records appear in the output table?

• WHERE

• FROM

• ORDER BY

• SELECT

Which SQL statement is correct for selecting all fields from a table where the date is before December 31, 2015?

• SELECT * FROM CD WHERE DatePublished < '31/12/2015'

• SELECT * FROM CD WHERE DatePublished > '31/12/2015'

• SELECT * FROM CD WHERE DatePublished = '31/12/2015'

• SELECT * FROM CD WHERE DatePublished != '31/12/2015'