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

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

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

Student Relation Student_ID   Student_Name   Dept_Name 0000 AAAAA Computer Science1111 BBBBB Computer Science2222 CCCCC  Business Administration Question 13Select one:a.CREATE TABLE Student(   Student_ID int,   Student_Name char(20),   Dept_Name char(20),);b.CREATE TABLE Student(   Student_ID int,   Student_Name varchar(100),   Dept_Name varchar(100),);c.CREATE TABLE Student(   Student_ID int,   Student_Name char(100),   Dept_Name char(100),);d.CREATE TABLE Student(   Student_ID char(20),   Student_Name char(100),   Dept_Name char(100),);

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

Select the correct answerWhat does the following statement in SQL do?DROP TABLE student;OptionsCreates the table called studentDeletes the table called studentChecks if there is a table called studentNone of theseFinish ClearPrev Next (0)