In SQL, which operator is used to combine two conditions and returns true if both are true? MCQ with Answer and Explanation

Question

Share Report Error

In SQL, which operator is used to combine two conditions and returns true if both are true?

A. AND

B. OR

C. NOT

D. XOR

Answer: Option A

Solution (By JKSSB Mock Tests)

The AND operator returns true only if both conditions are true.

This question belongs to: Computer Database Management System (DBMS)

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1

Which SQL clause is used to limit the number of rows returned in a query?

A. ROWNUM

B. All of the above (depending on DBMS)

C. LIMIT

D. TOP

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Different DBMS use different keywords: MySQL uses LIMIT, SQL Server uses TOP, Oracle uses ROWNUM.

This question belongs to: Computer Database Management System (DBMS)

Question #2

Which SQL operator allows you to check if a column value matches any item contained within a comma-separated list of explicit values?

A. EXISTS

B. BETWEEN

C. IN

D. LIKE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The IN operator allows you to specify multiple literal values or a subquery inside a WHERE clause, testing if an attribute matches any element in the list.

This question belongs to: Computer Database Management System (DBMS)

Question #3

Which clause is used in SQL to sort the final query result set in ascending or descending order?

A. SORT BY

B. GROUP BY

C. ORDER BY

D. ARRANGE BY

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The ORDER BY clause is used to sort the result set of a query in either ascending (default) or descending (using DESC) order.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs