Year 12 - Quarter 3 - Summative test

The SELECT statement is used to:

• a) Insert data into a table

• b) Update data in a table

• c) Delete data from a table

• d) Retrieve data from a table

The DISTINCT keyword is used to:

• a) Retrieve distinct values from a table

• b) Join two or more tables together

• c) Filter data based on specified conditions

• d) Sort data in ascending or descending order

The WHERE clause is used to:

• a) Specify the columns to be selected in a query

• b) Specify the table to be updated in a query

• c) Specify the conditions for data retrieval or modification

• d) Specify the sorting order of the query results

Which of the following is true about SQLite?

• a) It is a NoSQL database

• b) It is a distributed database

• c) It is a relational database

• d) It is a graph database

The LIKE operator is used to:

• a) Filter data based on specified conditions

• b) Join two or more tables together

• c) Retrieve distinct values from a table

• d) Modify an existing table's structure

The UPDATE statement is used to:

• a) Insert data into a table

• b) Update data in a table

• c) Delete data from a table

• d) Retrieve data from a table

The PRIMARY KEY constraint is used to:

• a) Specify the sorting order of the query results

• b) Specify the columns to be selected in a query

• c) Specify the table to be updated in a query

• d) Uniquely identify each record in a table

The INSERT INTO statement is used to:

• a) Create a new table

• b) Update existing records in a table

• c) Delete records from a table

• d) Insert new records into a table

The ALTER TABLE statement is used to:

• a) Filter data based on specified conditions

• b) Join two or more tables together

• c) Modify an existing table's structure

• d) Retrieve distinct values from a table

The ORDER BY clause is used to:

• a) Specify the columns to be selected in a query

• b) Specify the table to be updated in a query

• c) Specify the conditions for data retrieval or modification

• d) Sort data in ascending or descending order based on specified columns