WorksheetsNational 5 - Databases - Basic SQL
Total questions: 8
Worksheet time: 4mins
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
