Which SQL operator is used to check if a value is within a range? MCQ with Answer and Explanation

Which SQL operator is used to check if a value is within a range?
A. EXISTS
B. BETWEEN
C. IN
D. LIKE
Answer: Option B
Solution (By JKExamLibrary)
BETWEEN checks if a value falls within a specified range (inclusive of boundaries).

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
What is the concept of referential integrity?
A. Ensuring that foreign key values match primary key values in the referenced table
B. Ensuring that all primary keys are unique
C. Ensuring that no null values exist
D. Ensuring data is normalized

Correct Answer: Option A


Explanation:
Referential integrity ensures that relationships between tables remain consistent, meaning foreign key values must have corresponding primary key values.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What is the difference between DELETE and TRUNCATE commands?
A. TRUNCATE can have WHERE; DELETE cannot
B. DELETE removes all rows; TRUNCATE removes structure
C. DELETE can be rolled back; TRUNCATE cannot (in most DBMS)
D. No difference

Correct Answer: Option C


Explanation:
DELETE is a DML command that can be rolled back and can use WHERE; TRUNCATE is a DDL command that removes all rows and cannot be rolled back (in some DBMS) and resets auto-increment counters.

This question belongs to: Computer Database Management System (DBMS)
Question #3
In the relational model, what is the term used to describe the header or definition of a table specifying its name and attributes?
A. Relation Schema
B. Relation Instance
C. Relation Card
D. Relation Domain

Correct Answer: Option A


Explanation:
A Relation Schema defines the structure of a relation, specifying its name and the list of attributes along with their data types.

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