christina Littlewood
Quiz by , created more than 1 year ago

A multi choice quiz on databases

269
0
0
christina Littlewood
Created by christina Littlewood over 4 years ago
Close

Database quiz

Question 1 of 16

1

Which of the following is NOT true of databases?

Select one of the following:

  • You can store large amounts of data.

  • You have to use a computer.

  • You can search the data.

Explanation

Question 2 of 16

1

Which of the following is a piece of software used to create databases?

Select one of the following:

  • Google Chrome

  • Microsoft Office PowerPoint

  • Microsoft Office Access

Explanation

Question 3 of 16

1

What term describes a personalised letter which can be sent to customers of a supermarket?

Select one of the following:

  • Report

  • Mail merge

  • Macro

Explanation

Question 4 of 16

1

Which of the following is an advantage to paper-based databases?

Select one of the following:

  • 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.

Explanation

Question 5 of 16

1

Thinking of data, information and knowledge - which of the following is an example of information?

Select one of the following:

  • 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.

Explanation

Question 6 of 16

1

Which of the following holds a single piece of data?

Select one of the following:

  • Table

  • Record

  • Field

Explanation

Question 7 of 16

1

Which field would be inappropriate in a database of countries?

Select one of the following:

  • Continent

  • Population

  • First Name

Explanation

Question 8 of 16

1

What is the correct definition of primary key?

Select one of the following:

  • The first field in a table.

  • A field that contains unique data in each record.

  • The field which we will use to search with.

Explanation

Question 9 of 16

1

What database feature checks to see if data meets certain rules when entered to a table?

Select one of the following:

  • Table

  • Query

  • Validation

Explanation

Question 10 of 16

1

Which validation rule would you use to limit what a user can enter to only a few options, e.g. male or female?

Select one of the following:

  • List check

  • Presence check

  • Range check

Explanation

Question 11 of 16

1

What is a database record?

Select one of the following:

  • All of the records in a field

  • All the data about one item in the database.

  • the colour of a persons hair

Explanation

Question 12 of 16

1

What is data redundancy?

Select one of the following:

  • The unnecessary repetition of data.

  • The removal of data.

  • inputting the wrong data.

Explanation

Question 13 of 16

1

What is data validation?

Select one of the following:

  • 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.

Explanation

Question 14 of 16

1

What is data verification?

Select one of the following:

  • 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.

Explanation

Question 15 of 16

1

What is a relational database?

Select one of the following:

  • 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

Explanation

Question 16 of 16

1

How are tables linked together in a database?

Select one of the following:

  • 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.

Explanation

Previous
Next