L3 BTEC Unit 2 - SQL

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