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

In SQL, which operator is used to combine two conditions and returns true if both are true?
A. XOR
B. OR
C. AND
D. NOT
Answer: Option C
Solution (By JKSSB Mock Tests)
The AND operator returns true only if both conditions are true.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
Which of the following commands is a Data Manipulation Language (DML) statement?
A. UPDATE
B. RENAME
C. TRUNCATE
D. COMMENT

Correct Answer: Option A


Explanation:
UPDATE is a DML statement because it is used to modify existing data values within rows of a database table, rather than modifying the structural schema.

This question belongs to: Computer Database Management System (DBMS)
Question #2
RDBMS is based on which model?
A. Hierarchical model
B. Relational model
C. Network model
D. Object-oriented model

Correct Answer: Option B


Explanation:
Relational Database Management System (RDBMS) is based on the relational model proposed by E.F. Codd.

This question belongs to: Computer Database Management System (DBMS)
Question #3
What is the full form of RDBMS?
A. Random Data Backup Management System
B. Relational Data Binary Management System
C. Relational Database Management System
D. Real-time Database Management Software

Correct Answer: Option C


Explanation:
RDBMS stands for Relational Database Management System.

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