Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
To ensure the successful execution of the command intended to add a check constraint on the routes table, which of the following modifications would you recommend? The original command is: ALTER TABLE routes ADD CHECK (distance > 0).
routes
ALTER TABLE routes ADD CHECK (distance > 0)
A
Replace the CHECK keyword with CONSTRAINT.
CHECK
CONSTRAINT
B
Remove the TABLE keyword from the command.
TABLE
C
Change ADD CHECK to ADD CONSTRAINT CHECK.
ADD CHECK
ADD CONSTRAINT CHECK
D
Eliminate the brackets around the condition, changing (distance > 0) to distance > 0.
(distance > 0)
distance > 0
E
Modify ADD CHECK to ADD CONSTRAINT constraint_name CHECK.
ADD CONSTRAINT constraint_name CHECK
