SQL Operators MCQ Arithmetic Comparison Logical Practice Questions

Direction: Choose the correct option

Which are arithmetic operators in SQL?

A. IN, BETWEEN, LIKE

B. AND, OR, NOT

C. =, <, >

D. +, -, *, /

Direction: Choose the correct option

SELECT salary, salary * 1.10 FROM employees;

What does salary * 1.10 calculate?

A. Salary plus 10%

B. Salary times 10

C. Salary divided by 10

D. Salary minus 10%

Direction: Choose the correct option

Which are comparison operators?

A. IN, BETWEEN, LIKE

B. =, <>, >, <, >=, <=

C. +, -, *, /

D. AND, OR, NOT

Direction: Choose the correct option

What is the difference between = and LIKE?

A. #NAME?

B. LIKE is faster

C. Both are same

D. #NAME?

Direction: Choose the correct option

SELECT * FROM employees WHERE department_id IN (SELECT id FROM departments WHERE location = 'New York');

What type of operator is IN used with?

A. Comparison operator

B. Arithmetic operator

C. Subquery operator

D. Logical operator

Quipoin Menu