What value represents missing, unknown, or inapplicable data in a relational database? MCQ with Answer and Explanation

What value represents missing, unknown, or inapplicable data in a relational database?
A. Zero (0)
B. Blank Space (' ')
C. Void
D. NULL
Answer: Option D
Solution (By JKSSB Mock Tests)
NULL is a special marker used in SQL to indicate the absence of a value or that the data is missing, unknown, or not applicable.

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. RENAME
B. TRUNCATE
C. UPDATE
D. COMMENT

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)
Question #2
Which SQL statement is used to delete all rows from a table without logging individual row deletions?
A. REMOVE FROM table_name;
B. DELETE FROM table_name;
C. DROP TABLE table_name;
D. TRUNCATE TABLE table_name;

Correct Answer: Option D


Explanation:
TRUNCATE TABLE removes all rows and is a DDL operation with minimal logging, often faster than DELETE without WHERE.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following is a valid SQL statement to update a record?
A. UPDATE table_name SET column1 = value1 WHERE condition;
B. CHANGE table_name SET column1 = value1 WHERE condition;
C. MODIFY table_name SET column1 = value1 WHERE condition;
D. UPDATE table_name column1 = value1 WHERE condition;

Correct Answer: Option A


Explanation:
The correct syntax for UPDATE is: UPDATE table_name SET column1 = value1 WHERE condition;

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