Home » MCQs » SQL MCQs » SQL Constraints Clause MCQs

What is the difference between Column Level and Table Level Constraints?

3. What is the difference between Column Level and Table Level Constraints?

1. Constraints are applied to a single row using Column Level Constraints whereas Multiple rows can be constrained using a Table Level Constraint.
2. Constraints are applied to multiple rows using Column Level Constraints whereas a single row can be constrained using a Table Level Constraint.
3. Constraints are applied to a single column using Column Level Constraints whereas Multiple columns can be constrained using a Table Level Constraint.
4. Constraints are applied to multiple columns using Column Level Constraints whereas only a single column can be constrained using a Table Level Constraint.

Answer: C) Constraints are applied to a single column using Column Level Constraints whereas Multiple columns can be constrained using a Table Level Constraint

Explanation:

Constraints are applied to a single column using Column Level Constraints whereas Multiple columns can be constrained using a Table Level Constraint.