wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

KS3 Database

Total questions: 51

Worksheet time: 2hrs 36mins

Name
Class
Date
1.

Which program would you use to create a database?

a)
b)
c)
d)
2.

What is database?

a)

A program used to draw images

b)

An organised collection of data, stored and accessed electronically

c)

A way of creating presentations

d)

Basically Available, Soft state

3.

In a database, data is stored in:

a)

Forms

b)

Tables

c)

Reports

d)

Queries

4.

Which of the following would be used to uniquely identify a record?

a)

Validation

b)

Data type

c)

Primary key

d)

Combo box

5.

Data sorted in order from A-Z or 1-100 is:

a)

Growing data

b)

Alphabetical data

c)

Ascending data

d)

Descending data

6.

Data sorted in order from Z-A or 100 -1 is:

a)

Ascending data

b)

Small data

c)

Alphabetical data

d)

Descending data

7.

What does FILTER let us do?

a)

Sort the data in order

b)

Colour different data types

c)

Save file as

d)

Select which data we want to see

8.

What is a COMBO BOX?

a)

A box containing shapes

b)

A dropdown menu with selected options

c)

A way to sort data

d)

Data type field

9.

What could be an option in a combo box? (select more than 1)

a)

Male; Female

b)

>25

c)

Yes; No

d)

100

10.

Which View would you select to add record to your table?

a)

Design View

b)

Datasheet View

11.

Which View would you select to add a Combo Box?

a)

Design View

b)

Datasheet View

12.

Which option allows us to limit the number that we can input to a field?

a)

Combo box

b)

Sorting

c)

Data Validation

d)

Filter

13.

What character do we use to list options avaliable in the combo box?

a)

;

b)

"

c)

.

d)

,

14.

Which option shows smaller than 25?

a)

>=25

b)

<<25

c)

<25

d)

<<25

15.

Select examples of data validation (more than one):

a)

>25

b)

<25

c)

m;f

d)

text

16.
A database application can perform which of the following activities?
a)
Add records
b)
Display / read records
c)
Update records
d)
All of the above
17.
The term _______ is used to refer a row
a)
Record
b)
Foreign key
c)
Primary key
d)
Field
18.
Consider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key?
a)
NAME
b)
ID
c)
CITY
d)
ID, NAME
19.
which one of the following cannot be taken as a primary key?
a)
ID
b)
RegistrationNo
c)
DepartmentID
d)
Street
20.
The records of a table can be of ________ order.
a)
Any
b)
Same
c)
Sorted
d)
Constant
21.
Which of the following is a common error when creating database tables?
a)
Failing to add a foreign key
b)
Failing to add a common field
c)
Entering the wrong data type in a field
d)
Failing to uniquely identify each record
22.
The word "query" means:
a)
populate
b)
question
c)
answer
d)
locate
23.
What operation would you perform to rename a field?
a)
Open the table in Design View, click into the field name column, type the new name, click the save button.
b)
Open the table in Design View, right click on the row the field name, click cut, and click the save button.
c)
Open the table in Datasheet View, click the drop down arrow, enter the new name, and click the save button.
d)
Open the table in the Layout View, click the drop down arrow, enter the new name, and click the save button.
24.
How is each record in a database identified?
a)
By the record's foreign key
b)
By the record's primary key
c)
By the number in the ID column
d)
By the value contained in the first data column for the record.
25.
Which operation would you perform to change your age from 11 to 12 in a database field?
a)
add a record
b)
sort a record
c)
delete a record
d)
update a record
26.
Which operation would you perform to insert information into a database table for a new student in your class?
a)
add a record
b)
sort a record
c)
delete a record
d)
update a record
27.
Which operation would you perform to remove information from a database table for a student who leaves your class?
a)
add a record
b)
sort a record
c)
delete a record
d)
update a record
28.
What should you do if you want to view database records in alphabetical order by last name?
a)
Sort the records n the database by the Last Name field.
b)
Create another table and add records in the desired order.
c)
Sort the records in the database by the First Name field.
d)
Update the Last Name field for each record in the database to reflect the desired order.
29.
What happens to the unique ID field when a record is deleted?
a)
the ID is deleted
b)
the ID remains
c)
You cannot delete a record once is has an ID.
d)
The ID is reassigned to a new record.
30.
What View allows you to make changes to the database?
a)
table view
b)
form view
c)
layout view
d)
design view
31.
What operations would you perform name a database?
a)
Click save.
b)
Click File, name, type the name and save.
c)
Click File, close and save.
d)
Type the name in the File Name Box.
32.
What information is considered when naming a database table?
a)
The information the table will contain.
b)
The purpose of the table.
c)
The order of the table.
d)
The name of the database.
33.
Why is the number data type appropriate for the Siblings field?
a)
It has numbers with decimal places.
b)
It has unique sequential numbers.
c)
It has numbers and characters.
d)
It has numeric data.
34.
What operations would you perform to delete a record?
a)
Select the entire record, right click the record, and select Delete Record.
b)
Delete the record name.
c)
Select the name, right click and select delete.
d)
You cannot delete a record once it has an unique ID.
35.
What operations would you perform to add a record?
a)
From File, click Create, Record, enter the appropriate information and save.
b)
From File, click new record type in the information and save.
c)
In the Datasheet View, enter the appropriate information for each field in the row of the table
d)
From the Design View, click add, new record, enter the appropriate information and save.
36.
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
37.
Which database component is used to organize information by data type?
a)
row
b)
title
c)
field
d)
record
38.
What is another name for a table row in a database?
a)
field
b)
record
c)
column
d)
heading
39.
What does a database use to provide a simplified interface for the user to enter, modify and view database records?
a)
form
b)
table
c)
query
d)
report
40.
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
41.
Which data types is best for calculations?
a)
autonumber
b)
text
c)
number
d)
currency
42.
What data type is used for monetary values?
a)
Autonumber
b)
General
c)
currency
d)
accounting
43.

Which database view is used by users who input and view data?

a)

Physical view

b)

Logical view

c)

User view

44.

A collection of data that is organized and stored to help people make decisions

a)

Database

b)

Table

c)

Record

d)

Entity

45.

Contains important information (data) organized into rows and columns.

a)

Database

b)

Table

c)

Record

d)

Entity

46.

Information displayed in columns on a table.

a)

Database

b)

Table

c)

Record

d)

Field

47.

Displays information in columns and rows so that the user can easily see more than one record at a time.

a)

Datasheet

b)

Attribute

c)

Relationship

d)

Data type

48.

Any combination of letters, numbers, or calculations. (Up to 255 characters)

a)

Short text

b)

Long text

c)

Number

d)

Currency

49.

A data type used for numbers.

a)

Short text

b)

Long text

c)

Number

d)

Currency

50.

A data type used for dates.

a)

Short text

b)

Date/Time

c)

Number

d)

Currency

51.

A number that is automatically placed into a field.

a)

Autonumber

b)

Long text

c)

Number

d)

Currency

Similar Resources on Wayground

Yr 8 (IT3) - Hardware & Software

51 questions

Yr 8 (IT3) - Hardware & Software

quiz

Worksheet

•

5th - 9th Grade

PLTW Technology QUIZIZZ

52 questions

PLTW Technology QUIZIZZ

quiz

Worksheet

•

7th Grade

Sumatif jaringan komputer

50 questions

Sumatif jaringan komputer

quiz

Worksheet

•

7th Grade

Computer devices

50 questions

Computer devices

quiz

Worksheet

•

1st - 10th Grade

Quiz Latihan Soal-Soal UTS Keamanan Jaringan

50 questions

Quiz Latihan Soal-Soal UTS Keamanan Jaringan

quiz

Worksheet

•

KG - University

ICT KS3 ERC End of Year Quiz

50 questions

ICT KS3 ERC End of Year Quiz

quiz

Worksheet

•

4th - 10th Grade

soal pas informatika

50 questions

soal pas informatika

quiz

Worksheet

•

7th Grade

Latihan Soal Informatika ASTS

50 questions

Latihan Soal Informatika ASTS

quiz

Worksheet

•

7th Grade