What is the simplest type of database?
Simple database
Flat file database
Single file database
"Flat file databases store data in single file". This statement is:
True
False
How do relational databases store data?
In relations (tables)
In boxes
In folders
What is the purpose of Structured Query Language (SQL)?
To request information from a database which matches set criteria
To display images on an interface
To translate languages from around the world
Which of the options below best describes a complex query?
Asks complicated questions that the computer cannot understand
Searches records using more than one parameter value
Searches records in a database using only one parameter value
Which of the following is an example of a complex query?
Searching for customers who are female AND live in Belfast OR Lisburn
Searching for customers who live in Newtonabbey
Searching for female customers
Can calculations form part of your query?
Yes
No
What is a feature of a report?
Adding all the data together
Allowing users to group, sort and add headers and footers
Including redundant data
What is an advantage of a report?
It contains subtotals, counts and other formulas that save time and provide greater analysis
Keeps data safe and prevents any sensitive information from leaking
Has a large memory so that large amounts of data can be stored
What is the purpose of mail merge?
So that multiple people can reply to the same email
So that company owners can view their employees' emails
Allows users to personalise letters with fields from a database