SQL Logical Operators and Conditions

What are logical operators also known as?

• Arithmetic operators

• Boolean operators

• Comparison operators

• Assignment operators

What is the primary function of the OR operator?

• To combine two criteria P and Q, returning a Boolean expression P OR Q.

• To return a TRUE Boolean value only if both criteria P and Q are TRUE.

• To negate a single criterion.

• To perform mathematical calculations between two values.

Where is the OR operator typically used in an SQL statement to combine multiple criteria or conditions?

• In the SELECT clause.

• In the FROM clause.

• In the WHERE clause.

• In the ORDER BY clause.

In the OR operator's truth table, when will the Boolean value be FALSE?

• When both P and Q are TRUE.

• When P is TRUE and Q is FALSE.

• When P is FALSE and Q is TRUE.

• When both P and Q are FALSE.

Which of the following is the correct syntax for using the OR operator in an SQL SELECT statement?

• SELECT attribute FROM table WHERE criteria1 AND criteria2;

• SELECT attribute FROM table OR criteria1 criteria2;

• SELECT attribute FROM table WHERE criteria1 OR criteria2;

• SELECT attribute FROM table JOIN criteria1 OR criteria2;

Based on the provided table and the SQL query `SELECT ID_Murid, Nama_Murid, Jantina, Kaum FROM MURID WHERE Jantina = "PEREMPUAN" OR Kaum = "MELAYU";`, which student record would NOT be selected?

• SM101 Damia Zahraa Binti Rahim

• SM103 Denish Raimi Bin Zainal

• SM104 Tan Xue Lieh

• SM105 Jessica Heng Mui Mui

When using the OR operator in an SQL WHERE clause, under what condition will a record be returned?

• Only if all specified criteria are true.

• If at least one of the specified criteria is true.

• If none of the specified criteria are true.

• Only if the first specified criterion is true.

When using the AND operator in an SQL WHERE clause, under what condition will a record be returned?

• If at least one of the specified criteria is true.

• Only if all specified criteria are true.

• If none of the specified criteria are true.

• Only if the last specified criterion is true.

Given the table and the SQL query `SELECT ID_Murid, Nama_Murid, Jantina, Kaum FROM MURID WHERE Jantina = "PEREMPUAN" AND Kaum = "MELAYU";`, which student record would be selected?

• SM103 Denish Raimi Bin Zainal

• SM104 Tan Xue Lieh

• SM101 Damia Zahraa Binti Rahim

• SM106 Jessica Heng Mui Mui

What is the primary difference in how the OR and AND operators function in an SQL WHERE clause?

• OR requires all conditions to be true, while AND requires at least one.

• OR is used for numerical comparisons, while AND is for text comparisons.

• OR returns a record if any condition is met, while AND returns a record only if all conditions are met.

• OR is faster than AND for large datasets.