wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Database Query Quiz

Total questions: 20

Worksheet time: 10mins

Name
Class
Date
1.
What is letter "A" showing?
a)
Where to configure the Join properties
b)
Where to Run the query
c)
Where to configure which fields and criteria are used for the Query
2.
What is letter "B" showing?
a)
Where to click to Run the Query
b)
Where to Configure the Fields returned and criteria to be used
c)
Where to click to configure the Join properties
d)
Where to click to Save this Query
3.
A query can get its data from
a)
a. one or more tables.
b)
b. existing queries.
c)
c. a combination of a and b.
d)
d. all of the above.
4.
Which Boolean operator will narrow your results
a)
AND
b)
OR
c)
NOT
d)
BUT
5.
Which Boolean operator will expand your results
a)
AND
b)
OR
c)
NOT
d)
BUT
6.
A football team keeps a database about its players. Which query would allow them to produce a query showing players who are strikers and who have scored 20 goals or more?
a)
Position = "Striker" OR Goals = 20
b)
Position = "Striker" AND Goals = 20
c)
Position = "Striker" or Goals >=20
d)
Position = "Striker" AND Goals >= 20
7.
Wildcard that represents any collection of characters
a)
Asterisk
b)
Question Mark
c)
Query
d)
Equal Sign
8.
A bookshop owner is using the shop's database to help a customer.  The customer is looking for a particular author but cannot remember their full name.  The customer remembers that the surname of the author starts with the letters "Co".  What kind of query could the bookshop owner use to find this information?
a)
Parameter
b)
GroupBy
c)
Wildcard
d)
Selection
9.

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

a)

Validation

b)

Data type

c)

Primary key

d)

Field size

10.

What is a foreign key?

a)

A FOREIGN KEY is a field in one table that matches the PRIMARY KEY in another table.

b)

A foreign key is a field in a table that uniquely defines every record uniquely

11.

What is the purpose of a primary key?

a)

To uniquely identify the record

b)

To take telephone numbers and lock then

c)

It will ensure that values are entered twice

12.

How would you define a Query?

a)

Created to see tables better

b)

Allow you to retrieve data from tables

c)

The wizard allows you to go step by step

13.

Relationships are created in Ms. Access to:

a)

Connect tables to create combined reports queries or forms

b)

To show relation

c)

To join tables together for printing

14.
____  Is a database object that lets you ask the database about the information that you want to see displayed.
a)
Query
b)
Datasheet
c)
Sort
d)
Filter
15.
_________ means to put information in order. 
a)
Query
b)
Sort
c)
Filter
d)
Count
16.
A to Z is sorting in ________ order. 
a)
Ascending
b)
Descending
17.
A to Z is sorting in ________ order. 
a)
Ascending
b)
Descending
18.
What is this operator?
<>
a)
Equal to
b)
Not equal
c)
Less than and greater than
19.

Click ___________ to show the results of a query

a)

Execute

b)

Show

c)

Run

d)

Results

20.

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

Similar Resources on Wayground

4.6.4 Logic Gates

15 questions

4.6.4 Logic Gates

quiz

Worksheet

•

10th Grade - Professi...

Java Control and Loop -2

20 questions

Java Control and Loop -2

quiz

Worksheet

•

University

Lenguaje de Definición de Datos

18 questions

Lenguaje de Definición de Datos

quiz

Worksheet

•

University

Redes Sociales

20 questions

Redes Sociales

quiz

Worksheet

•

University

Firewall and Network Security

15 questions

Firewall and Network Security

quiz

Worksheet

•

University

PBO Inheritance Episode 2

18 questions

PBO Inheritance Episode 2

quiz

Worksheet

•

University

2.4 - 2.6

15 questions

2.4 - 2.6

quiz

Worksheet

•

University

Week 4

15 questions

Week 4

quiz

Worksheet

•

University