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

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

Nonnegativity constraints ensure that _____.Group of answer choicesthe problem modeling includes only nonnegative values in the constraintsthe solution to the problem will contain only nonnegative values for the decision variablesthe objective function of the problem always returns maximum quantitiesthere are no inequalities in the constraints