In SQL, how do you check if a value is NOT NULL? MCQ with Answer and Explanation

Question Report Error

In SQL, how do you check if a value is NOT NULL?

A. NOT NULL

B. IS NOT NULL

C. IS NULL

D. != NULL

Answer: Option B

Solution (By JKExamLibrary)

IS NOT NULL is the correct operator to test for non-NULL values.

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 type of key uniquely identifies each record in a table and cannot contain NULL values?

A. Secondary Key

B. Foreign Key

C. Candidate Key

D. Primary Key

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
A Primary Key is a unique identifier for each tuple in a relation. It enforces entity integrity and strictly cannot accept NULL values.

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

Question #2 Report Error

Which of the following is not an aggregate function in SQL?

A. DESC

B. MAX

C. AVG

D. SUM

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
DESC is a keyword for sorting order, not an aggregate function.

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

Question #3 Report Error

Which of the following is not a type of database model?

A. Flat-file

B. Hierarchical

C. Network

D. Object-oriented

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
Flat-file is not a database model; it is a simple file containing records. Hierarchical, Network, Relational, and Object-oriented are database models.

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

Explore All Database Management System (DBMS) MCQs