Create Table EXAMS (        SUB_NO integer Not Null,        STUDENT_NO integer Not Null,        MARK decimal (3),        DATE_TAKEN date);This SQL statement is used to create the EXAMS table. Considering the EXAMS table; which of the following table contents cannot be inserted to the EXAMS table (assume date format is correct)?Question 5Select one:a. SUB_NO   STUDENT_NO   MARK   DATE_TAKEN 1 S1 62 2 S2 85 b. SUB_NO   STUDENT_NO   MARK   DATE_TAKEN 1 1 72 05-23-20202 2 85 c. SUB_NO   STUDENT_NO   MARK   DATE_TAKEN 1 1 05-23-20202 2 85 05-23-2020d. SUB_NO   STUDENT_NO   MARK   DATE_TAKEN 1 1 98.5 05-23-20201 1 85 05-23-2020

1 CREATE TABLE Student (2 StudentID INT NOT NULL,3 FirstName VARCHAR(40),4 LastName DATETIME,5 DegreeID INT,6 PRIMARY KEY (StudentID),7 FOREIGN KEY (DegreeID) );Which line will cause a syntax error?Group of answer choices7456231

Which of the following statements will execute successfully?INSERT INTO Student VALUES(1, 'Alice', 'Female', '20-JAN-15');INSERT INTO Student VALUES(1, "Alice", 'F', SYSDATE);INSERT INTO Student VALUES(1, 'Alice', 'F', '2015-JAN-20');INSERT INTO Student VALUES(1, 'Alice', 'F', NULL);

INSERT INTO Enrollments (EnrollmentID, StudentID, CourseID, EnrollmentDate) VALUES (7, NULL, 101, '2023-09-05');Group of answer choicesReferential integrity constraintNo ViolationKey constraintEntity integrity constraint

Problem StatementIn a university's academic department, a database table named "students" that stores information about students, including their student ID, name, enrolled course, and scores obtained in different subjects.The university administration wants to analyze the performance of students and identify those who scored above a certain threshold. To facilitate this analysis, you are tasked with creating a stored procedure named "GetHighScorers".The following table is already created, and the records are inserted into the table.TABLE: students student_id INT PRIMARY KEY, student_name VARCHAR(50), course VARCHAR(50), score INT

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');