Free Printable Tech+ Objective 5

Worksheets

Tech+ Objective 5 - Database

Total questions: 22

Worksheet time: 16mins

Name

Class

Date

What is a relational database?

A database that is built from a set of unique tables containing data about one entity

A database with one single large table

A set of many databases about numerous, related topics

What is a foreign key?

A foreign key is a primary key that appears in another table to create a relationship between the two tables

A foreign key is a field that does not belong in that table

A foreign key is a field that is a unique identifier in that entity

What would you use a query for?

To export and present information from a database

To enter data into a database

To search and filter a database

Why would you create a report?

To store data in the database

To present data in a user-friendly way

To search the database

A database is:

An organised collection of data or information

A collection of software

A collection of drivers

Which of the following is a tool to store, edit and organise a database?

A database management system (DBMS)

A database

SQL

What is SQL?

A programming language used to search and query databases

A programming language used to build databases

A programming language used to debug databases

What is a foreign key?

A foreign key is a primary key that appears in another table to create a relationship between the two tables

A foreign key is a field that is a unique identifier in that entity

A foreign key is a field that does not belong in that table

A tool used to organize, store, retrieve, and communicate groups of related information.

Spreadsheet

Word

Presentations

Database

10.

Which of the following is a common database program?

Access

Excel

InDesign

Badata

11.

The building blocks of a database that are used to store information are called

tables

fields

records

entries

12.

A complete description of all the fields related to one item in a table is called

record

field

table

entry

13.

Primary key means

normal key

unique key

subordinate key

candidate key

14.

Give 3 examples of a primary key

Student Number, Name, Birthday

Student Number, Auto Number, License Number

15.

What does "SQL" stand for?

Structured Question Language

Structured Query Language

Simple Query Language

Simple Question Language

16.

Which statement is used to extract data from a database?

Extract

Get

Open

Select

17.

To remove a record from a table which SQL statement would you use?

Remove

Cancel

Delete

Eradicate

18.

Which data type uses historical data to make decisions in the present?

Analytical

Operational

Conceptual

Logical

19.

Which type of analytical data can help you make investment decisions?

Machine

Market

Transactional

Sensor

20.

What does cloud storage mean in the context of databases?

Storing data online, managed by a cloud provider

Storing data offline

Storing data on an intranet

Storing data on local servers

21.

What advantage do databases have over spreadsheets in terms of user access?

Databases can be accessed by multiple users at the same time.

Spreadsheets are more secure.

Databases are easier to use.

Spreadsheets can only be used by one person at a time.

22.

What role do constraints play in maintaining database integrity?

They allow for duplicate records.

They enable faster data retrieval.

They ensure data accuracy and consistency.

They increase storage capacity.

Reset

Tech+ Objective 5 - Database

Total questions: 22

Worksheet time: 16mins

Similar Resources on Wayground