What happens when you try to insert a record with a value that violates a CHECK constraint?Group of answer choicesThe record is inserted successfullyThe record is rejected, and an error is raisedThe record is inserted, but the constraint is violatedThe constraint is automatically disabled temporarily

The tables above show information on a school database. The questions below will test your understanding of the violations of constraints. Check all the constraints that the operations below violate. Flag question: Question 6Question 6Tips2 ptsUPDATE Enrollments SET StudentID = 10, CourseID = 999 WHERE EnrollmentID = 1;Group of answer choicesKey constraintEntity integrity constraintReferential integrity constraintNo Violation

INSERT INTO Enrollments (EnrollmentID, StudentID, CourseID, EnrollmentDate) VALUES (1, 10, 101, '2023-09-05');Group of answer choicesReferential integrity constraintKey constraintEntity integrity constraintNo Violation

What is the purpose of the SQL CHECK constraint?OptionsPrevents the deletion of a tableEnsures that a column contains only numeric valuesEnsures that a column contains unique valuesDefines a condition that must be satisfied for data to be entered into a column

INSERT INTO Courses (CourseID, CourseName, Credits, InstructorID) VALUES (101, NULL, 3, 1);Group of answer choicesEntity integrity constraintReferential integrity constraintKey constraintNo Violation

Select the correct answerWhat SQL statement is used to add a unique constraint to a column?OptionsUNIQUECHECKCONSTRAINTPRIMARY KEY