23713054
Description
Quiz by christina Littlewood, updated more than 1 year ago
|
Created by christina Littlewood
over 4 years ago
|
|
Question 1
Question
Which of the following is NOT true of databases?
Answer
-
You can store large amounts of data.
-
You have to use a computer.
-
You can search the data.
Question 2
Question
Which of the following is a piece of software used to create databases?
Answer
-
Google Chrome
-
Microsoft Office PowerPoint
-
Microsoft Office Access
Question 3
Question
What term describes a personalised letter which can be sent to customers of a supermarket?
Answer
-
Report
-
Mail merge
-
Macro
Question 4
Question
Which of the following is an advantage to paper-based databases?
Answer
-
It is easy to add or amend records.
-
You do not need any training on how to use the database.
-
Data can be sorted and re-sorted easily.
Question 5
Question
Thinking of data, information and knowledge - which of the following is an example of information?
Answer
-
The average men's shoe size is nine.
-
9
-
If you are to open a shoe shop, you must stock plenty of size nine shoes.
Question 6
Question
Which of the following holds a single piece of data?
Answer
-
Table
-
Record
-
Field
Question 7
Question
Which field would be inappropriate in a database of countries?
Answer
-
Continent
-
Population
-
First Name
Question 8
Question
What is the correct definition of primary key?
Answer
-
The first field in a table.
-
A field that contains unique data in each record.
-
The field which we will use to search with.
Question 9
Question
What database feature checks to see if data meets certain rules when entered to a table?
Answer
-
Table
-
Query
-
Validation
Question 10
Question
Which validation rule would you use to limit what a user can enter to only a few options, e.g. male or female?
Answer
-
List check
-
Presence check
-
Range check
Question 11
Question
What is a database record?
Answer
-
All of the records in a field
-
All the data about one item in the database.
-
the colour of a persons hair
Question 12
Question
What is data redundancy?
Answer
-
The unnecessary repetition of data.
-
The removal of data.
-
inputting the wrong data.
Question 13
Question
What is data validation?
Answer
-
Checking if the data is from a reliable source.
-
The process of checking data as it is entered into the system to ensure it is entered correctly.
-
Checking if the data interesting.
Question 14
Question
What is data verification?
Answer
-
Updating records.
-
The checking that the data is true or correct (usually by human checking).
-
Checking to see if the data has already on the system.
Question 15
Question
What is a relational database?
Answer
-
A relationship database stores data in tables. Each table contains data about one entity. Each table is called a relation. Tables are linked together using keys.
-
A database that stores information about relatives.
-
A database about a specific subject
Question 16
Question
How are tables linked together in a database?
Answer
-
The tables are typed in to the database and added together to make one table.
-
A database will automatically use all the tables available.
-
Tables are linked together by using keys. The primary key in one table is linked to another table as a foreign key.
Want to create your own Quizzes for free with GoConqr? Learn more.