wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Post-Test Database Quiz (SQL) PRSHS

Total questions: 55

Worksheet time: 39mins

Name
Class
Date
1.
What causes most errors in a database?
a)
SQL
b)
humans
c)
servers
d)
Internet access
2.
A quick way to find data in a database is to use _____.
a)
queries
b)
quandries
c)
questions
d)
file folders
3.
SQL stands for _____.
a)
structured query language
b)
sustainable query language
c)
structured question language
d)
sustainable question language
4.

What are databases mainly used for?

a)

To store archived data

b)

To store and organise data

c)

To analyse data

5.

Which of the following uses paper-based databases?

a)

Phonebook

b)

Smart Phone

c)

Computer

6.

Select one 'school/student based' database term.

a)

Allergies

b)

Type of pet

c)

Social media accounts

7.
The following are functions of a DBMS except
a)
Creating database
b)
Processing data
c)
Creating and processing forms
d)
Administrating database
8.

In a database, data is stored in

a)

Queries

b)

Forms

c)

Reports

d)

Tables

9.
Which language is used to develop and manage databases?
a)
sql
b)
java
c)
html
d)
dbms
10.
Which of the following is NOT an example of a database?
a)
telephone book
b)
Real Estate listing
c)
Online library card catalog
d)
DVD
11.
Rows are called...
a)
fields
b)
records
c)
table
d)
entry
12.
Columns are called...
a)
rows
b)
fields
c)
table
d)
form
13.
What Query view is shown in this image?
a)
Datasheet View
b)
Design View
14.
Which of the following can you do with a database?
a)
Search
b)
Sort
c)
Do calculations
d)
All of these
15.
A database is essential to all shopping websites.
a)
True
b)
False
16.
 What data type is your name? 
a)
text
b)
number
c)
date
d)
time
17.
 What data type is your address? 
a)
text
b)
number
c)
date
d)
time
18.
 What data type is this? 
a)
text
b)
number
c)
date
d)
graphic
19.
 What data type is this? 
a)
text
b)
number
c)
date
d)
graphic
20.
 What data type is this? 
a)
text
b)
number
c)
date
d)
graphic
21.
 What data type is 543? 
a)
text
b)
boolean
c)
date
d)
number
22.
True or False: A Database is an unorganized collection of information
a)
True
b)
False
23.

What does "SQL" stand for?

a)

Structured Question Language

b)

Structured Query Language

c)

Simple Query Language

d)

Simple Question Language

24.

Which statement is used to extract data from a database?

a)

Extract

b)

Get

c)

Open

d)

Select

25.

If you were wanting to filter data, which clause would you use?

a)

Where

b)

Order by

c)

From

d)

Select

26.

Using which word allows you to specify that more than one condition must be met in a query?

a)

Also

b)

And

c)

Or

d)

Where

27.

To remove a record from a table which SQL statement would you use?

a)

Remove

b)

Cancel

c)

Delete

d)

Eradicate

28.

Less than or equal to?

a)

>=

b)

=>

c)

=<

d)

<=

29.

Which character returns all the data found in a table?

a)

%

b)

#

c)

*

d)

/

30.

Which example of the field name below is in camel case?

a)

First Name

b)

firstName

c)

FIRSTNAME

d)

firstname

31.

What would the SQL query pictured do?

a)

Find all the men

b)

Find all of the female writers

c)

Find all of Elgar's friends

d)

Find all the male writers

e)

Find all the fish

32.

When examining a row in a table, we refer to it as a...

a)

row number

b)

result number

c)

record

d)

result

33.

Which of the queries is most likely to have produced this result?

a)

ANSWER: SELECT id, name, year FROM movies WHERE year > 2010;

b)

ANSWER: SELECT id, name, year FROM movies WHERE year < 2010;

c)

ANSWER: SELECT * FROM movies WHERE year > 2010;

d)

ANSWER: SELECT id, name, year FROM movies WHERE YEAR > 2010;

34.
What is a special value in SQL that represents missing or unknown data?
a)
%
b)
?
c)
NULL
d)
*
35.
Return 5 movies with an imdb rating of 7 or higher.
a)
SELECT * FROM movies WHERE imdb_rating = 7 limit 5;
b)
SELECT * FROM movies WHERE imdb-rating >= 7 LIMIT 5;
c)
SELECT * FROM movies WHERE imdb_rating <= 7 LIMIT 5;
d)
SELECT * FROM movies WHERE imdb_rating >= 7 LIMIT 5;
36.
What word is missing from the line below?
SELECT *
_______ CUSTOMER;
a)
FROM
b)
WHERE
c)
SELECT
d)
ORDER BY
37.
What is the purpose of  *?
a)
Selects ALL fields from the table
b)
Selects only the first field in the table
c)
Selects the last field in the table
d)
Shows only the first row in the table
38.

A relational database accesses information from one or more...

a)

Spreadsheets

b)

Collections

c)

Matrices

d)

Tables

39.

The SQL statement to retrieve information from a table uses..

a)

CREATE TABLE <table name> (field_name DATATYPE...);

b)

SELECT <field_name> FROM <table name>;

c)

SELECT <table name> FROM <table name>;

d)

CREATE DATABASE <database name>;

40.

How many records are in this table?

a)

7

b)

6

c)

5

d)

4

41.

How many fields are there?

a)

4

b)

5

c)

6

d)

7

42.

What is the ID of the records that are returned when the SQL statement "SELECT * FROM Gymnasts WHERE Name='Xavier'"?

a)

0001

b)

0002

c)

0003

d)

0004

e)

0005

43.

How many records are there in this table?

a)

6

b)

7

c)

9

d)

42

44.

How many fields are there in this table?

a)

6

b)

7

c)

9

d)

42

45.

In what order does SQL process the instructions?

a)

FROM - SELECT - WHERE - ORDER BY

b)

WHERE - FROM - SELECT - ORDER BY

c)

SELECT - FROM - WHERE - ORDER BY

d)

SELECT - FROM - ORDER By - WHERE

46.

What is a field?

a)

A collection of information

b)

A single item of information

c)

A list of information

d)

A group of records

47.

Which symbol would you use to represent more than 50

a)

= 50

b)

< 50

c)

> 50

d)

# 50

48.

When examining a row in a table, we refer to it as a...

a)

row number

b)

result number

c)

record

d)

result

49.

What would the SQL query pictured do?

a)

Find all the men

b)

Find all of the female writers

c)

Find all of Elgar's friends

d)

Find all the male writers

e)

Find all the fish

50.
What is missing in this code? SELECT * FROM WHERE genre = ‘action’ ORDER BY year ASC;
a)
Missing an AND
b)
Table name
c)
Capitalize action
d)
None of these
51.
What word is missing from the line below?
SELECT *
_______ CUSTOMER;
a)
FROM
b)
WHERE
c)
SELECT
d)
ORDER BY
52.
What is the purpose of  *?
a)
Selects ALL fields from the table
b)
Selects only the first field in the table
c)
Selects the last field in the table
d)
Shows only the first row in the table
53.
Which clause allows you to SORT data?
a)
ORDER BY
b)
WHERE
c)
FROM
d)
HAVING
54.
True/False?
SQL table names are case sensitive
a)
True
b)
False
55.
What represents no value? 
a)
NULL
b)
" "
c)
0
d)
N/A

Similar Resources on Wayground

PAS TA 2025/2026 SIMDIG KELAS X

50 questions

PAS TA 2025/2026 SIMDIG KELAS X

quiz

Worksheet

•

10th Grade

TECHNICAL DRAWING SECOND TERM EXAMINATION 2022/2023 SESSION

50 questions

TECHNICAL DRAWING SECOND TERM EXAMINATION 2022/2023 SESSION

quiz

Worksheet

•

10th Grade

Semester one Learning outcomes (Review)

60 questions

Semester one Learning outcomes (Review)

quiz

Worksheet

•

9th - 11th Grade

QUIMESTRE 1(10-2019-2020)

50 questions

QUIMESTRE 1(10-2019-2020)

quiz

Worksheet

•

10th Grade

Small Engine Midterm Part 3

50 questions

Small Engine Midterm Part 3

quiz

Worksheet

•

9th - 12th Grade

Ag woods 2025 Quiz 6

50 questions

Ag woods 2025 Quiz 6

quiz

Worksheet

•

9th - 12th Grade

Quiz Ilmu Informatika

52 questions

Quiz Ilmu Informatika

quiz

Worksheet

•

9th - 12th Grade

Sumatif Sistem Komputer X-5

50 questions

Sumatif Sistem Komputer X-5

quiz

Worksheet

•

10th Grade