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. OR
B. XOR
C. AND
D. NOT
Answer: Option C
Solution (By JKExamLibrary)
The AND operator returns true only if both conditions are true.

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

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1 Report Error
What is the full form of RDBMS?
A. Relational Database Management System
B. Relational Data Binary Management System
C. Real-time Database Management Software
D. Random Data Backup Management System

Correct Answer: Option A


Explanation:
RDBMS stands for Relational Database Management System.

This question belongs to: Computer Database Management System (DBMS)
Question #2 Report Error
Which normal form addresses partial dependencies, i.e., non-prime attributes dependent on part of a composite primary key?
A. 1NF
B. 2NF
C. BCNF
D. 3NF

Correct Answer: Option B


Explanation:
Second Normal Form (2NF) eliminates partial dependencies by ensuring all non-key attributes are fully functionally dependent on the entire primary key.

This question belongs to: Computer Database Management System (DBMS)
Question #3 Report Error
Which of the following is a property of a well-designed database?
A. Avoidance of data redundancy
B. Ease of data maintenance
C. All of the above
D. Support for efficient data retrieval

Correct Answer: Option C


Explanation:
Good database design aims to minimize redundancy, simplify maintenance, and provide efficient access.

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