Which of the following is a valid constraint in SQL? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is a valid constraint in SQL?

A. CHECK

B. PRIMARY KEY

C. FOREIGN KEY

D. All of the above

Answer: Option D

Solution (By JKSSB Mock Tests)

CHECK, PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL are all constraints in SQL.

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

Request complete Subject PDF

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 main purpose of indexing in a database?

A. To encrypt data

B. To speed up data retrieval

C. To delete data

D. To backup data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Indexes improve the speed of data retrieval operations on a database table.

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

Question #2

What is a data mart?

A. A type of database

B. A backup technique

C. A subset of a data warehouse focused on a specific business unit or function

D. A query language

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A data mart is a specialized data warehouse for a specific department, team, or subject area.

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

Question #3

Which of the following is a characteristic of a DBMS?

A. Data redundancy control

B. Data independence

C. All of the above

D. Security and access control

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A DBMS provides features like data independence, reduced redundancy, security, and concurrent access.

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

Explore All Database Management System (DBMS) MCQs