FIT9132 PASS Week 9

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

• FROM

• SELECT

• WHERE

• GROUP BY

Which of the following are valid comparison operators in Oracle SQL? (Select all that apply)

• =

• !=

• <>

• >>

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

Which SQL pattern matches strings starting with 'DJI'?

• LIKE 'DJI%'

• LIKE '%DJI'

• LIKE 'DJI_'

• LIKE '_DJI%'

Which SQL clause is used to test for NULL values?

• = NULL

• IS NULL

• IS NOT NULL

• NULL

Which logical operator is evaluated first in SQL?

• AND

• OR

• NOT

• XOR

Which SQL keyword removes duplicate rows from the result set?

• UNIQUE

• DISTINCT

• REMOVE

• DELETE

Which SQL clause specifies the sort order for the query results?

• GROUP BY

• ORDER BY

• SORT BY

• ARRANGE BY

Which SQL clause ensures NULL values appear at the end of the result set?

• NULLS FIRST

• NULLS LAST

• NULLS END

• NULLS BOTTOM

Which SQL keyword is used to assign an alias to an expression or column?

• ALIAS

• AS

• WITH

• NAME