WorksheetsL3 BTEC Unit 2 - SQL
Total questions: 10
Worksheet time: 5mins
What tool allows a user to search a database for specific information?
Query
Report
Filter
Form
Which of the following are Boolean operators in queries?
YES,NO
TRUE, FALSE
AND, NOT, OR
Which of the following queries would exclude 'Purple' from a list of colours?
Purple
ONLY
NOT Purple
Which query would you use to present results for 'purple trousers'?
Purple AND Trousers
Purple NOT Trousers
Purple OR Trousers
What is SQL
A programming language used to build databases
A programming language used to search and query databases
A programming language used to debug databases
In SQL, what does the code 'Title varchar(20)' mean?
Create a variable called 'Title' with a maximum length of 20 characters
Create a field called 'Title' with a string data type and a length of 20 characters
Create a field called 'Title' with number data type and a length of 20 characters
Which SQL statement allows a user to find records with similar attributes?
SEARCH
FROM
WHERE
Which SQL statement defines the fields that will be looked at in the query?
SELECT
FROM
CHOOSE
Which SQL statement allows a user to sort records into order?
SORT
ORDER
SORT ASCENDING
Which SQL statement allows a user to add a new record?
INSERT
INSERT INTO
ADD
