Font size
S
M
L
XL
WorksheetsIntro to Transformation
Total questions: 15
Worksheet time: 8mins
Name
Class
Date
1.
What does SQL stand for?
a)
Sequential Query Language
b)
Structured Query Language
c)
Standard Query Log
d)
System Queue Logic
2.
SQL is used to manage and query relational databases.
a)
True
b)
False
3.
The command to retrieve data from a table is (a) .
4.
Which clause is used to remove duplicates in a query?
a)
FILTER
b)
DISTINCT
c)
GROUP BY
d)
ORDER BY
5.
Which SQL keyword limits the number of rows returned?
a)
TOP
b)
FIRST
c)
LIMIT
d)
MAX
6.
To filter results by a condition, use the (a) clause.
7.
What keyword do you use to rename a column in the output?
a)
CHANGE
b)
LABEL
c)
RENAME
d)
AS
8.
Which clause is used to sort results in SQL?
a)
FILTER
b)
ORDER BY
c)
GROUP BY
d)
SELECT
9.
The SELECT clause can reference a column using its index position.
a)
True
b)
False
10.
The function COUNT() returns the number of (a) .
11.
Which of the following is NOT a CRUD operation?
a)
UPDATE
b)
DELETE
c)
JOIN
d)
INSERT
12.
The SQL command to remove data from a table is (a) .
13.
Which operator is used for pattern matching in SQL?
a)
=
b)
IN
c)
LIKE
d)
JOIN
14.
What is the purpose of an Entity Relationship Diagram (ERD)?
a)
To create indexes
b)
To show table relationships
c)
To define columns
d)
To filter data
15.
A column that uniquely identifies each row is called a (a) .
Reset
