What is the purpose of the SQL 'CONSTRAINT' keyword? MCQ with Answer and Explanation

Question
What is the purpose of the SQL 'CONSTRAINT' keyword?
A. To join tables
B. To define rules for data integrity
C. To create views
D. To create indexes
Answer: Option B
Solution (By JKSSB Mock Tests)
Constraints are used to enforce rules on data, such as NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK.
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 a candidate key in a relation?
A. A super key that is minimal
B. A foreign key
C. Any column that can be used as a primary key
D. A key that is not unique
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A candidate key is a minimal super key, meaning no subset of it can uniquely identify a row.
This question belongs to: Computer Database Management System (DBMS)
Question #2
RDBMS is based on which model?
A. Object-oriented model
B. Relational model
C. Hierarchical model
D. Network model
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Relational Database Management System (RDBMS) is based on the relational model proposed by E.F. Codd.
This question belongs to: Computer Database Management System (DBMS)
Question #3
A table is in Third Normal Form (3NF) if it is in 2NF and has absolutely no non-prime attributes that exhibit what type of dependency?
A. Join Dependency
B. Transitive Dependency
C. Partial Dependency
D. Trivial Dependency
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Third Normal Form (3NF) requires a relation to be in 2NF with no transitive dependencies, meaning non-prime attributes cannot be determined by other non-prime attributes.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Computer Hardware 430 Operating Systems 510 Programming Languages 0 Cyber Security 269 Database Management System (DBMS) 278
Explore Subjects
Reasoning 2064 Science 4430 Accountancy and Statistics 3179 Economy GK 2220 Computer 5279
Practice Mix
Which national park in Himachal Pradesh is known for its high-altitude grasslands and is a key habitat for the Himalayan Tahr?
Who was the first Indian to be the Coordination Secretary?
Which of the following is an example of an animal cell that lacks a nucleus in its mature form?
What is the primary limitation of configuring a network using a point-to-point Full Mesh Topology as the number of nodes scales high?
Double fertilization in angiosperms was discovered by: