UPDATE `db_me`.`student_table` SET `student_name` = 'Sarah Geronimo' WHERE `student_table`.`student_id` =1;*5 pointsThere is an error in the statementStatement will execute successfullyOther:INSERT INTO `db_me`.`student_table` (`student_id` ,`student_name` ,`student_year`)VALUES (NULL , 'Sarah G', '3rd year'), (NULL , 'Moira', `3rd year`);*5 pointsThere is an error in the statementStatement will execute successfullyOther:CREATE DATABASE 'db_me' ; *5 pointsThere is an error in the statementStatement will execute successfullyOther:CREATE TABLE `db_me`.`student_table` (`student_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,student_name VARCHAR( 255 ) NOT NULL ,`student_year` VARCHAR( 255 ) NOT NULL) *5 pointsThere is an error in the statementStatement will execute successfullyOther:BackNext

UPDATE Enrollments SET StudentID = 10, CourseID = 999 WHERE EnrollmentID = 1;Group of answer choicesNo ViolationReferential integrity constraintKey constraintEntity integrity constraint

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?

Question 3You have a new database named 2023_students. You have an old database named 2022_students. The 2022_students database has a table in it named freshmen. All the students who were freshmen in 2022 will be returning as sophomores in 2023. You need to copy the whole freshmen table to the 2023_students database. The new table in the 2023_students database should be named sophmores.You have executed the USE 2023_students; statement.What statement should you execute next?1 pointCREATE TABLE sophomores AS SELECT * FROM freshmenCREATE TABLE sophomores AS 2022_students.freshmen CREATE TABLE sophomores AS SELECT * FROM 2022_students.freshmenCREATE TABLE 2023_students.sophomores AS SELECT * FROM freshmen

In a student database, there's a table named student that stores information about students, including their names and marks in different subjects (Math, English, Science, and History). Some students may initially have NULL values for their marks. Your task is to create a function named tbl_Update that takes the student's name and new marks for each subject as input parameters. The function should update the student's marks in the table based on the provided values.The following table is already created, and the records are inserted into the table.Table:student Name VARCHAR(100), Math INT, English INT, Science INT, History INTPrepopulated Records:Input format :The input records are already prepopulated, as given in the problem statement.Output format :The output should return 1 to indicate a successful update and should display the student's information with the updated result.tbl_update('Saurabh',85,69,75,82)1Name Math English Science HistoryRaman 95 89 85 81Rahul 90 87 86 81Mohit 90 85 86 81Saurabh 85 69 75 82

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