FIT9132 PASS Week 9

FIT9132 PASS Week 9

University

15 Qs

quiz-placeholder

Similar activities

Fundamentos de Bases de Datos

Fundamentos de Bases de Datos

10th Grade - University

15 Qs

Quick Quiz Simpeda

Quick Quiz Simpeda

University

10 Qs

SQL PRE-ASSESSMENT (MOTIVATION)

SQL PRE-ASSESSMENT (MOTIVATION)

University

10 Qs

Teste de SQL: Tabelas e Inserções

Teste de SQL: Tabelas e Inserções

10th Grade - University

14 Qs

Ktra thường xuyên Tin 11

Ktra thường xuyên Tin 11

11th Grade - University

20 Qs

UAS Sistem dan Teknologi Informasi

UAS Sistem dan Teknologi Informasi

University

20 Qs

Recoleccion y Fuentes de Datos

Recoleccion y Fuentes de Datos

University

15 Qs

Avaliação de SQL Básico

Avaliação de SQL Básico

University

16 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?