SQL Where Clause MCQ

Sql MCQ
  1. Home
  2. Tutorials
  3. Sql
  4. Where Clause
  5. Multiple Choice Question

(1) Which keyword provide facility to match non-continous or distinct values using where clause?

A) BETWEEN
B) IN
C) DIS
D) UNIQUE

(2) Which keyword is used for matching of string patterns in where clause?

A) MATCH
B) STRING
C) LIKE
D) SIMILAR

(3) Where statement can be used with which of the following ones?

A) SELECT
B) UPDATE
C) DELETE
D) All of these

(4) Which keword is used to specify a continous range of values to be matched in where clause?

A) IN
B) BETWEEN
C) CONTINOUS
D) RANGE

(5) How many where clauses can be used with single statement?

A) One
B) Two
C) Four
D) Multiple

(6) Which of the following commands use combination of where clause ?

A) DML
B) DDL
C) DCL
D) TCL

(7) Which of the following expression is used with where clause?

A) Relational
B) Logical
C) Assignment
D) Both A and B
Comments
Login to TRACK of Comments.