FIT9132 PASS Week 9

FIT9132 PASS Week 9

University

15 Qs

quiz-placeholder

Similar activities

SQL Quiz

SQL Quiz

University

19 Qs

NoSQL Concepts

NoSQL Concepts

University

10 Qs

Repaso ADO.NET

Repaso ADO.NET

University

10 Qs

SQL PRE-ASSESSMENT (MOTIVATION)

SQL PRE-ASSESSMENT (MOTIVATION)

University

10 Qs

GESTION BD

GESTION BD

University

12 Qs

2. Бази даних. Системи керування базами даних (СКБД). MS Access

2. Бази даних. Системи керування базами даних (СКБД). MS Access

University

15 Qs

UAS Sistem dan Teknologi Informasi

UAS Sistem dan Teknologi Informasi

University

20 Qs

Mastering Java Collections Framework

Mastering Java Collections Framework

University

12 Qs

FIT9132 PASS Week 9

FIT9132 PASS Week 9

Assessment

Quiz

Information Technology (IT)

University

Easy

Created by

Yiheng Cai

Used 3+ times

FREE Resource

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

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

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?