Which constraint ensures that a column cannot accept or store an unassigned or missing value? MCQ with Answer and Explanation

Which constraint ensures that a column cannot accept or store an unassigned or missing value?
A. UNIQUE
B. DEFAULT
C. NOT NULL
D. CHECK
Answer: Option C
Solution (By JKSSB Mock Tests)
The NOT NULL constraint explicitly forces a column to always contain a value, preventing blank or NULL entries.

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 a relation in relational database terms?
A. A row
B. A column
C. A table
D. A key

Correct Answer: Option C


Explanation:
In the relational model, a relation is a table consisting of rows and columns.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What is the purpose of the SAVEPOINT statement?
A. To permanently save changes
B. To release locks
C. To create a point within a transaction to which you can later roll back
D. To start a new transaction

Correct Answer: Option C


Explanation:
SAVEPOINT creates a named point within a transaction, allowing partial rollback to that point without affecting the entire transaction.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following commands is a Data Manipulation Language (DML) statement?
A. TRUNCATE
B. COMMENT
C. UPDATE
D. RENAME

Correct Answer: Option C


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)