wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

DATABASE QUIZ

Total questions: 50

Worksheet time: 26mins

Name
Class
Date
1.

Which software program do we use to create a database

a)

Microsoft Excel

b)

Microsoft Word

c)

Microsoft Access

d)

Microsoft Publisher

2.

Who might use a database?

a)

School

b)

Police

c)

Employer

d)

All of the above

3.

What is an advantage 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

4.

What is a unique identifying field called?

a)

Field

b)

Primary Key

c)

Record

d)

Query

5.

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

a)

Data types

b)

Headings

c)

Fields

d)

Records

6.

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

a)

Record

b)

Query

c)

Field

d)

Form

7.

A row in a database is better known as

a)

Record

b)

Query

c)

Field

d)

Form

8.

A query is used to

a)

Sort the database in alphabetical order

b)

Search the database

c)

Delete records

d)

Create a form

9.
Which is the best example of a primary key?
a)
Driver's License Number
b)
Home Runs Hit
c)
Price
d)
First and Last Name
10.
Data _____ helps ensure that an incorrect entry isn't made.
a)
validation
b)
checks
c)
accuracy
d)
integrity
11.
A quick way to find data in a database is to use _____.
a)
queries
b)
quandries
c)
questions
d)
file folders
12.
The front-end of a database is known as a _____.
a)
form
b)
report
c)
query
d)
website
13.
SQL stands for _____.
a)
structured query language
b)
sustainable query language
c)
structured question language
d)
sustainable question language
14.

Which of the following statements best defines the word 'database'?

a)

A database is a collection of data or information which is stored in a logical and structured way

b)

A database is a collection of statistics stored only for computers.

c)

A database does not collect data or information.

15.

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

16.

Which of the following defines the term 'field' in relation to databases?

a)

A field is all of the information about one person or one thing

b)

A field is the collection of all the database records on one topic or subject

c)

A field is one type or piece of information

17.

Which of the following defines the term 'file' in relation to databases?

a)

A file is all of the information about one person or one thing

b)

A file is one type or piece of information

c)

A file is the collection of all the database records on one topic or subject

18.
How many records are in this database?
a)
8
b)
5
c)
10
d)
12
19.
What is the primary key in this database?
a)
Emp_Id
b)
Last Name
c)
Gender
d)
Title
20.

Which of the following is an example of a record?

a)

347

b)

ChannelType

c)

351, Nature, Documentary, Bling, False

21.

The HD field is using the data type Boolean

a)

True

b)

False

22.

Which of the following is an example of a record?

a)

Artist

b)

Game Over

c)

002, Tail, Seeing You, 2.7, 0, True

23.

You will get full marks if you say "a database is a collection of data"

a)

True

b)

False

24.
What Query view is shown in this image?
a)
Datasheet View
b)
Design View
25.
What Query view is shown in this image?
a)
Datasheet View
b)
Design View
26.
Wildcard that represents any collection of characters
a)
Asterisk
b)
Question Mark
c)
Query
d)
Equal Sign
27.
 Max wants to create a list of graduate degrees in a database that will allow the selection of only three choices: BSBA, MBA, and MBE. Which field property should he use? 
a)
 Auto Number 
b)
 Lookup
c)
  Number 
d)
  Yes/No
28.
 What data type is your name? 
a)
text
b)
number
c)
date
d)
time
29.
 What data type is your address? 
a)
text
b)
number
c)
date
d)
time
30.
 What data type is yes or no? 
a)
text
b)
boolean
c)
date
d)
time
31.
What data type is 31/5/2017?
a)
number
b)
date
c)
graphic
d)
boolean
32.
What data type is a post code?
a)
number
b)
date
c)
graphic
d)
text
33.
The following is a description of the data being held inside the database, what is the data type?  Your birthday
a)
time
b)
date
c)
graphic
d)
boolean
34.

Which data type would be most suitable for the 'Age' field?

a)

Currency

b)

Date & Time

c)

Number

d)

Memo

35.

Each item of information within a record.

a)

form

b)

field

c)

record

d)

report

36.
Which is the correct definition for a field and a record?
a)
Fields are single pieces of information and records are a collection of data about a single person or item
b)
Fields are made of green grass and records contain music
c)
Fields are where you put data, records are where you sort data
d)
Fields are rows, records are columns
37.
What is data validation?
a)
Rules used to reduce errors when data is entered
b)
A method of sorting data
c)
A different method of entering data in to a table
d)
Importing data in to a table
38.

A database that stores all the records in multiple tables that are linked together is called ____


a)

Multiple Database

b)

Flat file Database

c)

Relational Database

d)

Linked Database

39.

Data can be entered into a table using the Datasheet view, but it can be easier to use a ______ instead.

a)

“Form”

b)

“Record”

c)

“Primary Key”

d)

“Field”

40.

Which database view can be used to enter data?

a)

“Table Design View”

b)

“Datasheet View”

41.

DBMS means ____________________

a)

database management system

b)

data management system

c)

detail-based management system

42.

EXAMPLE OF DBMS

a)

MS WORD

b)

MS ACCESS

c)

MS EXCEL

43.

Data type for 'male/female'

a)

Yes/No

b)

Text

c)

Number

d)

Currency

44.

Data type for 'CV34 5TR'

a)

Text

b)

Number

c)

Date

d)

Autonumber

45.

Data type for '£5.67'

a)

Number

b)

Currency

c)

Date

d)

Time

46.

When you perform a basic search using only one criterion, it is called ___

a)

Basic Query

b)

Simple Query

c)

Single Query

d)

Complex Query

47.

A query that requires two or more criteria in order to perform the search is called ____

a)

Multiple Query

b)

Simple Query

c)

Complex Query

d)

Double Query

48.

How many views does a Query have in Microsoft Access?

a)

1

b)

2

c)

3

d)

4

49.

How many views does a database table have?

a)

1

b)

2

c)

3

d)

4

50.

A database that stores all the records in just one table is called ____

a)

Paper-based Database

b)

Computer-based Database

c)

Flat file Database

d)

Relational Database

Similar Resources on Wayground

Exploring Computer Science Unit 1 Review

55 questions

Exploring Computer Science Unit 1 Review

quiz

Worksheet

•

9th - 12th Grade

QUIZZ PKK - Hak Atas Kekayaan Intelektual (HAKI)

50 questions

QUIZZ PKK - Hak Atas Kekayaan Intelektual (HAKI)

quiz

Worksheet

•

KG - Professional Dev...

EVALUACIÓN PARCIAL DE INFORMÁTICA

50 questions

EVALUACIÓN PARCIAL DE INFORMÁTICA

quiz

Worksheet

•

9th - 12th Grade

Komputer Akuntansi XII AK1

50 questions

Komputer Akuntansi XII AK1

quiz

Worksheet

•

KG - 12th Grade

Penilain Harian 2

50 questions

Penilain Harian 2

quiz

Worksheet

•

9th Grade - University

CompTIA ITFundamentals CRAM

46 questions

CompTIA ITFundamentals CRAM

quiz

Worksheet

•

6th Grade - University

GCSE Computer Science [Component 1]

46 questions

GCSE Computer Science [Component 1]

quiz

Worksheet

•

9th Grade

Simulasi Bahasa Indonesia Ke-1 (Paragraf)

50 questions

Simulasi Bahasa Indonesia Ke-1 (Paragraf)

quiz

Worksheet

•

9th Grade