National 5 - Databases - Basic SQL

What does SQL stand for?

• Systematic Query Language

• Systematic Question Language

• Structured Query Language

• Structured Question Language

What is a query in a database system?

• A way to ask questions of the data in the system

• A way to input data into the system

• A way to delete data from the system

• A way to organize data in the system

How can you create a query in Microsoft Access?

• By typing the query directly into the database table

• By using the 'Sort' function to organize the data

• By clicking on the 'Filter' button and selecting the data

• By clicking on the 'Create' button and choosing 'Query Design'

What does the 'SELECT' keyword do in SQL?

• It adds new data to the database

• It retrieves data from the database

• It updates existing data in the database

• It deletes data from the database

What does the 'WHERE' keyword do in SQL?

• It groups the results based on a specified column

• It sorts the results in ascending order

• It filters the results based on a specified condition

• It specifies the tables to select data from

How do you select specific fields from a table in SQL?

• Use the 'FILTER' keyword

• Use the 'PICK' keyword

• Use the 'SEARCH' keyword followed by the field names

• Use the 'SELECT' keyword followed by the field names

What is the purpose of the 'FROM' keyword in SQL?

• It specifies the tables to select data from

• It specifies the fields to be displayed in the results

• It specifies the conditions for the query

• It specifies the order of the results

What is the purpose of the 'ORDER BY' keyword in SQL?

• It specifies the fields to be displayed in the results

• It specifies the order of the results

• It specifies the tables to select data from

• It specifies the conditions for the query