Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Database Paper 1 - Year 9

Total questions: 45

Worksheet time: 25mins

Name
Class
Date
1.

What is a database?

a)

A software package used to store information

b)

Something that has a list

c)

A spreadsheet

d)

A table of data

2.

Which software program do we use to create a database (a)  

Choose from the below words
Microsoft Excel
Microsoft Word
Microsoft Access
Microsoft Publisher
3.

Who might use a database? (a)  

Choose from the below words
School
Police
Employer
All of the above
4.

In school, what kind of data might be stored in a database?

a)

Favourite colour

b)

Emergency contact details

c)

Favourite food

d)

Your mobile phone number

5.

What is an advanage of a database?

a)

You can input information

b)

Its different to Excel

c)

It saves files

d)

Can search through and find information quickly

6.

What is a unique identifying field called?

a)

Field

b)

Primary Key

c)

Record

d)

Query

7.

Short text, date, long text and number are all examples of what?

a)

Data types

b)

Headings

c)

Fields

d)

Records

8.

A column in a database is better known as a...

a)

Record

b)

Query

c)

Field

d)

Form

9.

A row in a database is better known as

a)

Record

b)

Query

c)

Field

d)

Form

10.

True or false - it is important to check our literacy (spelling, capital letters, etc) when inputting data into a database

a)

True

b)

False

11.

A query is used to

a)

Sort the database in alphabetical order

b)

Search the database

c)

Delete records

d)

Create a form

12.

If we are running a query and looking for all records with a date before 1999, we type what into the criteria?

a)

>1999

b)

>01/01/1999

c)

<01/01/1999

d)

<1999

13.

What is this following a definition of?

Stores data/information in an organised way

a)

Field

b)

Database

c)

Record

d)

File/Table

14.

The rows in a database are called:

a)

Records

b)

Fields

c)

Attribute

d)

Coloum

15.

The columns in a database are called:

a)

Records

b)

Fields

c)

Primary key

d)

Foreign key

16.
A database does NOT consist of .........
a)
field
b)
table
c)
character
d)
report
17.
In a database, Yes/No, Text and Date/Time are all examples of:
a)
data types
b)
data queries
c)
tabs you can select
d)
records in the data table
18.
Which language is used to develop and manage databases?
a)
sql
b)
java
c)
html
d)
dbms
19.
In which of the following must the data be unique?
a)
the foriegn key
b)
the primary key
c)
the junction table
d)
the common field
20.
How many characters are allowed in the Text field?
a)
. More than 255
b)
1-255
c)
1-9
d)
Unlimited
21.
. What is a field in a related database table that refers to the primary key in the primary table?
a)
Secondary key
b)
Table key
c)
Foreign key
d)
Common key
22.
Text/String, Integer, Real/Float, Boolean and Date/Time are all examples of...
a)
Data Types
b)
Filters
c)
Sorts
d)
Validations
23.
A method of only displaying records in a table that match specific criteria...
a)
Filter
b)
Validation
c)
Sort
d)
Verification
24.
A database search that can be saved as a separate file.
a)
Query
b)
Validation
c)
Filter
d)
Verification
25.
A data type used for storing numbers with a fractional part e.g. 3.142
a)
Integer
b)
Boolean
c)
Real / Float
d)
String
26.
A data type that can only hold 2 values e.g. Yes/No or True/False.
a)
Boolean
b)
Integer
c)
Real
d)
String
27.
Which of these is not a type of validation?
a)
Proof Reading
b)
Range
c)
Limit
d)
Presence
28.
A group of related records.
a)
Entity
b)
Validation
c)
Field
d)
Filter
29.
One of the members of the Sports Club has decided to resign.  What would the secretary do with the record for that member on the database?
a)
Amend the record
b)
Delete the field
c)
Delete the record
d)
Delete the file
30.

What is a primary key?

a)

A field

b)

A record

c)

Two fields

d)

A unique reference

31.
The Sports Club has had an Open Day and has gained a new member.  How will they add their details to the database?
a)
Add another field
b)
Amend a record
c)
Add a new record
d)
Delete a record
32.
A gym has a database with all their members they want to include email addresses in the database, what will they do?
a)
Add a record
b)
Add a field
c)
Edit a record
d)
Delete a field
33.

This table has ___________ fields.

a)

2

b)

4

c)

5

d)

6

34.

This table has ___________ records.

a)

2

b)

4

c)

5

d)

6

35.

In a Database, each column is called a _____________

a)

Field

b)

Data

c)

Record

d)

Table

36.

___________, ___________ & ___________ are fields.

a)

S. No, Product Code & Description

b)

1021, Beverages & Soft drinks, coffees, teas

c)

Dairy Products, Beverages & Seafood.

d)

All of these are fields.

37.

Consider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key?

a)

Name

b)

ID

c)

City

d)

All of these

38.

Which one of the following attributes cannot be taken as a primary key?

a)

ID

b)

RegistrationNo

c)

DepartmentID

d)

Street

39.

______________ datatype you'd select for entering "Address".

a)

Number

b)

Date

c)

Text

d)

Time

40.

You have to enter Sam's DOB, What datatype would you use for this field.

a)

Time

b)

Date

c)

Text

d)

Number

41.

Information corresponding to each field is called (a)   .

42.

______________ symbol indicates that a field is the Primary Key of the table.

a)
b)
c)
d)

All of these

43.

Which of the following uses paper-based databases?

a)

Phonebook

b)

Smart Phone

c)

Computer

44.

What is open data?

a)

Open data is data that only certain people have access to

b)

Open data is data that is freely available and shared

c)

Open data is data that is very secure

45.

Why would you create a primary key?

a)

To make each record in a database unique

b)

To make each field in a database unique

c)

To make each query in a database unique

Similar Resources on Wayground

Quiz Bilangan dan Algoritma

40 questions

Quiz Bilangan dan Algoritma

quiz

Worksheet

•

9th Grade

SOAL LATIHAN PERSIAPAN PAS GANJIL 9

50 questions

SOAL LATIHAN PERSIAPAN PAS GANJIL 9

quiz

Worksheet

•

9th Grade

PTS X GASAL SISTEM INFORMASI

50 questions

PTS X GASAL SISTEM INFORMASI

quiz

Worksheet

•

9th - 12th Grade

Presentaciones de Google

48 questions

Presentaciones de Google

quiz

Worksheet

•

KG - Professional Dev...

BASIC DATA ENTRY

50 questions

BASIC DATA ENTRY

quiz

Worksheet

•

9th Grade

GCSE Computing Quiz

45 questions

GCSE Computing Quiz

quiz

Worksheet

•

7th - 11th Grade

Google Sheets Revision 1

50 questions

Google Sheets Revision 1

quiz

Worksheet

•

6th - 10th Grade

[SMP-VII] Soal ASAS 2024 Ganjil

40 questions

[SMP-VII] Soal ASAS 2024 Ganjil

quiz

Worksheet

•

7th Grade - University