wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

EDPM Form 4 – Databases Theory Quiz

Total questions: 25

Worksheet time: 19mins

Name
Class
Date
1.

Choose the correct answer. A database is best defined as:

a)

A word processing file

b)

A collection of related data stored electronically

c)

A spreadsheet only

d)

A hardware device

2.

Choose the correct answer. Which software is an example of a Database Management System (DBMS)?

a)

Microsoft Word

b)

Microsoft Excel

c)

Microsoft Access

d)

Microsoft PowerPoint

3.

Choose the correct answer. Data in a database is stored in:

a)

Forms

b)

Queries

c)

Tables

d)

Reports

4.

Choose the correct answer. A record in a database table refers to:

a)

A column of data

b)

A row of data

c)

The database name

d)

A field type

5.

Choose the correct answer. A field is best described as:

a)

One row of data

b)

One column of data

c)

A table

d)

A database

6.

Choose the correct answer. Which key uniquely identifies each record in a table?

a)

Foreign key

b)

Primary key

c)

Secondary key

d)

Candidate key

7.

Choose the correct answer. A foreign key is used to:

a)

Uniquely identify records

b)

Link two tables together

c)

Delete records

d)

Sort data

8.

Choose the correct answer. Which database object is mainly used to retrieve specific data?

a)

Table

b)

Form

c)

Query

d)

Report

9.

Choose the correct answer. Which type of query displays data without changing it?

a)

Update query

b)

Delete query

c)

Select query

d)

Action query

10.

A student wants to change a field data type from Text to Number. Which view should be used?

a)

Datasheet View

b)

Design View

c)

Form View

d)

Report View

11.

Choose the correct answer. A one-to-many relationship means:

a)

One record relates to one record

b)

Many records relate to many records

c)

One record relates to many records

d)

Records are unrelated

12.

Choose the correct answer. Which relationship type requires a junction table?

a)

One-to-one

b)

One-to-many

c)

Many-to-many

d)

No relationship

13.

Which view allows you to see the actual data stored in the table?

a)

Design View

b)

Design Preview

c)

Datasheet View

d)

Layout View

14.

Choose the correct answer. Which field type is best for storing dates?

a)

Text

b)

Number

c)

Date/Time

d)

Yes/No

15.

Which statement is TRUE?

a)

Design View allows you to define field properties e.g.. Field size

b)

Datasheet View is used to create table structure

c)

Datasheet View cannot edit data

d)

Design View displays records only

16.

Choose the correct answer. Datasheet View is mainly used to:

a)

Define table structure

b)

Enter and edit records

c)

Set primary keys

d)

Change data types

17.

Choose the correct answer. Design View is mainly used to:

a)

View records

b)

Print tables

c)

Create and modify table structure

d)

Enter data

18.

Choose the correct answer. Which task is BEST done in Design View?

a)

Typing records

b)

Sorting data

c)

Setting a primary key

d)

Viewing data

19.

Choose the correct answer. Which view displays data in rows and columns similar to a spreadsheet?

a)

Design View

b)

Datasheet View

c)

Print Preview

d)

Layout View

20.

Choose the correct answer. In which view would you change a field’s data type?

a)

Datasheet View

b)

Design View

c)

Form View

d)

Report View

21.

Choose the correct answer. Which view allows you to see the actual data stored in a table?

a)

Design View

b)

Datasheet View

c)

Layout View

d)

Print View

22.

Choose the correct answer. A query can be based on:

a)

Tables only

b)

Reports only

c)

One or more tables

d)

Forms only

23.

Choose the correct answer. A view of selected data without storing it permanently is created using a:

a)

Table

b)

Query

c)

Form

d)

Report

24.

Which data type is used to store text or letters?

a)

Date/Time

b)

Number

c)

Yes/ No

d)

Short Text

25.

Which of the following is TRUE about field data types?
A. Text fields can store numbers for calculations
B. Number fields can store words like names
C. Choosing the correct data type ensures correct storage and operations
D. Yes/No fields can store any text

a)

Choosing the correct data type ensures correct storage and operations

b)

Yes/No fields can store any text

c)

Number fields can store words like names

d)

Short/ Long Text fields can store numbers for calculations