Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Database Quiz

Total questions: 11

Worksheet time: 11mins

Name
Class
Date
1.

Advantages of relational databases over flat files include:

a)

Efficiency

b)

Flexibility

c)

Accuracy

d)

All of the above

2.

Which database component feeds data into tables?

a)

form

b)

query

c)

report

d)

vlookup

3.

Large databases in organizations must be scalable, support many concurrent users, and

a)

protect access to data

b)

use Linux operating systems

c)

have more than 100000 tables

d)

compress stored data to half its original size

4.

Which character is used in queries to designate any text string (any characters of any length)? Hint: wildcard symbol

a)

?

b)

^

c)

*

d)

!

e)

&

5.

Which of the following choices can appear only once (no duplicates) in a table?

a)

Queries

b)

Calculated data

c)

Foreign Key

d)

Primary key

6.

Which of the following is an appropriate primary key for a student record in the WMU student database?

a)

Birth date

b)

WIN number

c)

Major

d)

Home town

7.

What database component stores data?

a)

Table

b)

Form

c)

Query

d)

Report

8.

Databases do all of the following except

a)

Retrieve Data

b)

Create Data

c)

Organize and Filter Data

d)

Store Data

9.

Which of the following choices is a field?

a)

Name

b)

John Fetzer

c)

7-2332

d)

123 Sesame St

e)

All of the above

10.

Which database component filters data and returns a subset of the data stored in the database responding to a question asked of the data?

a)

Table

b)

Form

c)

Query

d)

Report

11.

Given the relationship diagram shown, which are primary tables?

a)

Customers and Cars

b)

Customers and SalesTransaction

c)

Cars and SalesTransaction

d)

Cars Only

e)

SalesTransaction Only