SQL Where Clause MCQ
Sql MCQ- Home
- Tutorials
- Sql
- Where Clause
- 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
Explanation
IN keyword can be used for matching distinct values from the provided data set/table.
(2) Which keyword is used for matching of string patterns in where clause?
A) MATCH
B) STRING
C) LIKE
D) SIMILAR
Explanation
Like keyword is used for matching various patterns of string while fetching data from table.
(3) Where statement can be used with which of the following ones?
A) SELECT
B) UPDATE
C) DELETE
D) All of these
Explanation
Where can be used with all of these statements according to requirements.
(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
Explanation
Between keyword specify a range of values for matching with where clause for specific column.
(5) How many where clauses can be used with single statement?
A) One
B) Two
C) Four
D) Multiple
Explanation
We can use multiple where clauses with each single DML statement
(6) Which of the following commands use combination of where clause ?
A) DML
B) DDL
C) DCL
D) TCL
Explanation
Where clause is used with statements of DML (Data Manipulation Language).
(7) Which of the following expression is used with where clause?
A) Relational
B) Logical
C) Assignment
D) Both A and B
Explanation
Relational and logical expression return True or False, therefore it is used with where clause.