InfoMidterm P4

What is the keyword used to display specific rows of output in a SELECT query?

• SELECT

• AND

• FROM

• WHERE

Which operator is used to compare one term with another in SQL?

• <

• >

• =

• *

What is the purpose of the BETWEEN operator in SQL?

• To check for NULL values in a column

• To perform pattern matching and wildcard searches

• To test a column value in a given set of values

• To compare a column value within a definite range

Which logical operator in SQL returns results only when all conditions are true?

• OR

• LIKE

• NOT

• AND

What is the purpose of the ORDER BY clause in SQL?

• To perform mathematical operations

• To filter rows based on specific conditions

• To join multiple tables in a query

• To sort the output rows

Which operator is used to test a column value in a given set of values?

• =

• <>

• IN

• LIKE

What is the purpose of the LIKE operator in SQL?

• To compare column values within a range

• To test for NULL values

• To perform pattern matching and wildcard searches

• To join multiple tables

Which operator is used to negate an expression in SQL?

• AND

• OR

• BETWEEN

• NOT

What is the purpose of the IS NULL operator in SQL?

• To join multiple tables

• To test for NULL values

• To perform pattern matching and wildcard searches

• To compare column values within a range

Which operator is used to compare one term with another in SQL?

• <

• >

• =

• *