SQL IGCSE Quiz

An SQL command that counts the number of records (rows) in which the field (column) matches a specified condition; used with SELECT (a)  

• ORDER BY

• COUNT

• SUM

• WHERE

Answer explanation

The COUNT function in SQL is used to count the number of records that meet a specified condition. It is commonly used with SELECT to retrieve the total number of rows that match the criteria defined in the WHERE clause.

A classification of how data is stored and displayed, and of which operations that can be performed on the stored value

• data type

• data value

• data

• data packet

Answer explanation

The term 'data type' refers to a classification that defines how data is stored, displayed, and the operations that can be performed on it. This makes 'data type' the correct choice, as it encompasses all aspects mentioned in the question.

The values associated with each record in a database table

• table

• record

• primary key

• field

Answer explanation

In a database table, a 'field' refers to the individual values associated with each record. Each field represents a specific attribute of the record, making 'field' the correct choice for this question.

An SQL command that identifies the table to use

• SELECT

• FROM

• WHERE

• ORDER BY

Answer explanation

The correct choice is 'FROM' because it specifies the table from which to retrieve data in an SQL query. 'SELECT' is used to choose columns, 'WHERE' filters records, and 'ORDER BY' sorts the results.

An SQL command that sorts the results from a query by a given column either alphabetically or numerically

• SUM

• WHERE

• COUNT

• ORDER BY

Answer explanation

The correct choice is 'ORDER BY', which is an SQL command used to sort query results by a specified column, either in ascending or descending order. The other options (SUM, WHERE, COUNT) serve different purposes in SQL.

An SQL command that fetches specified fields (columns) from a table

• SELECT

• FROM

• WHERE

• ORDER BY

Answer explanation

The SQL command 'SELECT' is used to fetch specified fields (columns) from a table. It allows users to retrieve data based on their requirements, making it the correct choice for this question.

A collection of fields that describe one item

• table

• record

• field

• database

Answer explanation

A record is a collection of fields that describe a single item, making it the correct choice. A table contains multiple records, while a field is a single attribute, and a database is a collection of tables.

An SQL command that fetches specified fields (columns) from a table

• SELECT

• FROM

• WHERE

• ORDER BY

Answer explanation

The SQL command 'SELECT' is used to fetch specified fields (columns) from a table. It allows users to retrieve data based on their requirements, making it the correct choice among the options provided.

A collection of fields that describe one item

• table

• record

• field

• database

Answer explanation

A record is a collection of fields that describe a single item, making it the correct choice. A table contains multiple records, while a field is a single attribute, and a database is a collection of tables.

A collection of fields that describe one item

• table

• record

• field

• database

Answer explanation

A record is a collection of fields that describe a single item, making it the correct choice. A table contains multiple records, while a field is a single attribute, and a database is a collection of tables.