You wrote this constraint name for a unique constraint on the Products table: UQProducts. What is the issue with this name?

medium📝 Debug Q14 of 15

SQL - Table Constraints

You wrote this constraint name for a unique constraint on the Products table: UQProducts. What is the issue with this name?

AIt should include the column name

BIt uses the wrong prefix for unique constraints

CIt is missing an underscore after the prefix

DIt is too long

Step-by-Step Solution

Solution:

Step 1: Identify the correct prefix and format for unique constraints
Unique constraints use the prefix UQ_ with an underscore.
Step 2: Check the given name format
The name UQProducts misses the underscore after UQ, so it should be UQ_Products.
Final Answer:
It is missing an underscore after the prefix -> Option C
Quick Check:
Unique prefix = UQ_ with underscore [OK]

Quick Trick: Always put underscore after prefix like UQ_ [OK]

Common Mistakes:

MISTAKES

Master "Table Constraints" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes