Which SQL clause is used to restrict the rows returned by a `SELECT` statement?

FIT9132 PASS Week 9

Quiz
•
Information Technology (IT)
•
University
•
Easy
Yiheng Cai
Used 3+ times
FREE Resource
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
FROM
SELECT
WHERE
GROUP BY
2.
MULTIPLE SELECT QUESTION
30 sec • 1 pt
Which of the following are valid comparison operators in Oracle SQL? (Select all that apply)
=
!=
<>
>>
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL clause is valid to filter rows based on price between 3000 and 5300 inclusively?
price BETWEEN 3000 AND 5300
price >= 3000 AND <= 5300
price >= 3000 OR price <= 5300
price > 3000 AND price < 5300
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL pattern matches strings starting with 'DJI'?
LIKE 'DJI%'
LIKE '%DJI'
LIKE 'DJI_'
LIKE '_DJI%'
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL clause is used to test for NULL values?
= NULL
IS NULL
IS NOT NULL
NULL
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which logical operator is evaluated first in SQL?
AND
OR
NOT
XOR
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL keyword removes duplicate rows from the result set?
UNIQUE
DISTINCT
REMOVE
DELETE
Create a free account and access millions of resources
Similar Resources on Quizizz
15 questions
Oracle PL/SQL Quizz

Quiz
•
University
10 questions
Chapter Quiz

Quiz
•
University
10 questions
Comandos SQL

Quiz
•
University
18 questions
Database Refreshment

Quiz
•
University
15 questions
Power BI Quiz (Beginner Level)

Quiz
•
University
12 questions
Mastering Java Collections Framework

Quiz
•
University
10 questions
NoSQL Concepts

Quiz
•
University
10 questions
NoSQL Concepts 2

Quiz
•
University
Popular Resources on Quizizz
15 questions
Multiplication Facts

Quiz
•
4th Grade
25 questions
SS Combined Advisory Quiz

Quiz
•
6th - 8th Grade
40 questions
Week 4 Student In Class Practice Set

Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025

Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)

Quiz
•
9th - 12th Grade
15 questions
June Review Quiz

Quiz
•
Professional Development
20 questions
Congruent and Similar Triangles

Quiz
•
8th Grade
25 questions
Triangle Inequalities

Quiz
•
10th - 12th Grade