Which constraint ensures that a column cannot have NULL values? MCQ with Answer and Explanation

Which constraint ensures that a column cannot have NULL values?
A. PRIMARY KEY
B. UNIQUE
C. NOT NULL
D. FOREIGN KEY
Answer: Option C
Solution (By JKExamLibrary)
NOT NULL constraint enforces that a column must have a value, preventing NULL entries.

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
Which of the following is a purpose of a database management system?
A. To manipulate data
B. To define and create databases
C. To control access to data
D. All of the above

Correct Answer: Option D


Explanation:
A DBMS provides functionalities for defining, constructing, manipulating, and controlling access to databases.

This question belongs to: Computer Database Management System (DBMS)
Question #2 Report Error
What is the concept of data independence?
A. The ability to store data in different formats
B. The ability to access data from multiple sources
C. The ability to move data between tables
D. The ability to change the database schema without affecting the application programs

Correct Answer: Option D


Explanation:
Data independence is the capacity to change the database schema at one level without affecting the next higher level, minimizing impact on applications.

This question belongs to: Computer Database Management System (DBMS)
Question #3 Report Error
What is a composite index?
A. An index on a single column
B. An index on a view
C. An index on multiple columns
D. An index that is a primary key

Correct Answer: Option C


Explanation:
A composite index is created on two or more columns, often used to speed up queries that filter on those columns.

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