Which of the following are the correct syntaxes for displaying the StudentName and Department from Student table?Select one or more:a.SELECT StudentName, Department FROM Student;b.select studentname, department FROM STUDENT;c.SELECT STUDENTNAME, DEPARTMENT FROM Student;d.select studentname, department FROM Student;

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

Choose the correct answerWhich of the following command is used to display the departments of the instructor relation?OptionsSelect * from instructor ;Select * from instructor where Dept_name = Finance;Select dept_name from instructor;Select dept_name for instructor where Name=Jackson;

Students Table Surname   First_Name   Student_No   Dept_No   Year Duke Fitzroy 1 4 2Al-Essawy Zaid 2 4 2Ayton Phil 3 3 1Patel Mahesh 4 2 1Jones Gareth 5 2 1Scott Gavin 6 2 2CREATE VIEW Freshman     AS Select * From Students Where Year = 1;Considering the above Students table and Freshman view, what will be the result of the following SQL query:Select * From Freshman Where Dept_No=4;Question 6Select one:a. Surname   First_Name   Student_No   Dept_No   Year Ayton Phil 3 3 1Patel Mahesh 4 2 1Jones Gareth 5 2 1b. Surname   First_Name   Student_No   Dept_No   Year Duke Fitzroy 1 4 2Al-Essawy Zaid 2 4 2c. Surname   First_Name   Student_No   Dept_No   Year Duke Fitzroy 1 4 2d.None of the above

Question 2Which of the following SQL statements uses the right syntax to create the Student table in a college database with character limits? 1 point123456CREATE TABLE students (    username CHAR(5),     fullName VARCHAR(100),     email VARCHAR(255));123456CREATE TABLE students (    username CHAR,     fullName VARCHAR,     email VARCHAR);

Consider following schema and write SQL for given statements.Student (RollNo, Name, DeptCode, City)Department (DeptCode, DeptName)Result (RollNo, Semester, SPI)1. List out the RollNo, Name along with SPI of Student.2. Display student name who got highest SPI in semester 1.3. Display the list of students whose DeptCode is 5, 6,7,10