When working with databases we need to be able to use query languages such as SQL. This requires basic use of Boolean operators.
What tool allows a user to search a database for specific information?
Which of the following are Boolean operators in queries?
AND, NOT, OR
Which of the following queries would exclude 'Red' from a list of colours?
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?
Which SQL statement defines the fields that will be looked at in the query?
Which SQL statement allows a user to add a new record?
Which SQL statement allows a user to sort records into order?