Question 1 - MCQ Questions - Chapter 9 - Structured Query Language

Last updated at July 14, 2026 by

Which of the following is not a comparison query?

(A) IN

(B) BETWEEN

(C) LIKE

(D) AND

 

Answer:

Comparison Keyword

Description

LIKE

Checks if column value is similar to the specified pattern.

IN

Checks if column value is equal to any one of a specified set of values.

BETWEEN

Checks if column value is between two values, including the end values specified in the range.

IS NULL

Checks if column value is null.

 

Checking the options

  • (A) IN - It is a comparison keyword
  • (B) BETWEEN - It is a comparison keyword
  • (C) LIKE - It is a comparison keyword
  • (D) AND - It is not a comparison keyword

So, the correct answer is (D)

Remove Ads

Transcript

Which of the following is not a comparison query? (A) IN (B) BETWEEN (C) LIKE (D) AND Answer: Comparison Keyword Description LIKE Checks if column value is similar to the specified pattern. IN Checks if column value is equal to any one of a specified set of values. BETWEEN Checks if column value is between two values, including the end values specified in the range. IS NULL Checks if column value is null. Checking the options (A) IN - It is a comparison keyword (B) BETWEEN - It is a comparison keyword (C) LIKE - It is a comparison keyword (D) AND - It is not a comparison keyword So, the correct answer is (D)

Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh is an IIT Kanpur graduate and has been teaching for 16+ years. At Teachoo, he breaks down Maths, Science and Computer Science into simple steps so students understand concepts deeply and score with confidence.

Many students prefer Teachoo Black for a smooth, ad-free learning experience.