Zusammenfassung der Ressource
Frage 1
Frage
Which of the following is NOT true of databases?
Frage 2
Frage
Which of the following is a piece of software used to create databases?
Frage 3
Frage
What term describes a personalised letter which can be sent to customers of a supermarket?
Frage 4
Frage
Which of the following is an advantage to paper-based databases?
Antworten
-
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.
Frage 5
Frage
Thinking of data, information and knowledge - which of the following is an example of information?
Antworten
-
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.
Frage 6
Frage
Which of the following holds a single piece of data?
Frage 7
Frage
Which field would be inappropriate in a database of countries?
Antworten
-
Continent
-
Population
-
First Name
Frage 8
Frage
What is the correct definition of primary key?
Antworten
-
The first field in a table.
-
A field that contains unique data in each record.
-
The field which we will use to search with.
Frage 9
Frage
What database feature checks to see if data meets certain rules when entered to a table?
Frage 10
Frage
Which validation rule would you use to limit what a user can enter to only a few options, e.g. male or female?
Antworten
-
List check
-
Presence check
-
Range check
Frage 11
Frage
What is a database record?
Antworten
-
All of the records in a field
-
All the data about one item in the database.
-
the colour of a persons hair
Frage 12
Frage
What is data redundancy?
Frage 13
Frage
What is data validation?
Antworten
-
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.
Frage 14
Frage
What is data verification?
Frage 15
Frage
What is a relational database?
Antworten
-
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
Frage 16
Frage
How are tables linked together in a database?
Antworten
-
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.