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

Last updated at April 16, 2024 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)

Go Ad-free

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 has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 14 years. He provides courses for Maths, Science and Computer Science at Teachoo