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
20 questions
Aprofundando em SQL

Quiz
•
University
20 questions
quiz-1

Quiz
•
University
16 questions
Q3. Relational Model

Quiz
•
University
12 questions
Mastering Java Collections Framework

Quiz
•
University
20 questions
СБД1

Quiz
•
University
10 questions
NoSQL Concepts

Quiz
•
University
10 questions
Comandos SQL

Quiz
•
University
18 questions
Quizz về SQL Injection

Quiz
•
University
Popular Resources on Quizizz
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade