Based on the relationship provided above, where referential integrity is enforced, which of the following statements is true?Question 3Answera.Data must be entered into the Students table first.b.Data must be entered into the Enrolment table first.c.Enrolment data can be entered without the unit code.d.The order of data entry does not matter.

Which of the following conditions are necessary to ensure data integrity? Select all that apply.

Since you choose to enforced the referential integrity while creating relationship between Employees table and Social Security table, which of the following would therefore be true?Group of answer choicesIt allows user from deleting a record from Social Security table when there are related records in Employees tableIt prohibits the user from entering a foreign key value in a Social Security table unless the primary key value already exists in the Employees tableIt allows you to enforce marriage between Employees table and Social Security tableIt prohibits the user from entering primary key value in Social Security table unless the foreign key value already exists in the Employees table

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

Which of the following options related to integrity constraints is/are trueIntegrity Constraints   ensure that the data stored  within the database  is ;A reliableB worthyC inconsistent D accurate

Which of the following statements will execute successfully? [Choose any TWO]INSERT INTO Student(Id, Name, Gender, DOJ) VALUES(1, 'Alice', 'F', NULL);INSERT INTO Student(Id, Gender) VALUES( 1, 'F');INSERT INTO Student(Id, Name) VALUES(1, 'Alice');INSERT INTO Student(Id, Name, Gender, DOJ) VALUES (1,NULL, 'F', '20-JAN-15');