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 = 2;Considering the above Students table and Freshman view, what will be the result of the following SQL query:Select * From Freshman Where Dept_No=2;Question 8Select one:a. Surname   First_Name   Student_No   Dept_No   Year Duke Fitzroy 1 4 2Al-Essawy Zaid 2 4 2b. Surname   First_Name   Student_No   Dept_No   Year PatelMahesh4 2 1JonesGareth5 2 1 Scott  Gavin  6  2  2c. Surname   First_Name   Student_No   Dept_No   Year Scott Gavin6 2 2d. Surname   First_Name   Student_No   Dept_No   Year PatelMahesh4 2 1Jones Gareth 5

You are given the following tables:CourseCourseID Description CreditsCS101 Computer Science I 3CS201 Elementary Data Structures 3ENGL210 Technical Writing 3RegistrationSID CourseID SemID Instructor Grade282712 ENGL210 201701 H. Zacny B+362112 CS101 201701 K. Ross CWhat would the following SQL Select statement produce for output?select course.description, registration.SID,registration.gradefrom registration right join courseon registration.courseID = course.courseIDSelect one:a.Computer Science I 362112 Cb.Computer Science I 362112 CTechnical Writing 28212 B+c.Computer Science I 362112 CElementary Data Structures null nullTechnical Writing 28212 B+d.No results due to syntax errorClear my choiceSkip Quiz navigationQuiz navigationQuestion1Question2Question3Question4Question5Question6Question7Question8Question9Question10Question11Question12Question13Question14Question15Question16Question17Question18Question19Question20Question21Question22Question23Question24Question25Question26Question27Question28Question29Question30Question31Question32Question33Question34Question35Question36Question37Question38Question39Question40Question41Question42Question43Question44Question45Question46This pageQuestion47This pageQuestion48This pageQuestion49This pageQuestion50This page

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;

Consider these following tables and only solve the query. Tables: 1) student: s_no (primary key), student_name, course_no (foreign key), age 2) courser-course-no (primary key), course-name.

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

Select the correct answerFollowing schema is given for university relation(Table):university(student_code, first_name, last_name, email,      phone_no, date_of_birth, honours_subject, percentage_of_marks);Which of the following query would display names of all students in descending order of percentage of marks?Optionsselect first_name, last name, percentage_of_marks order by percentage_of_marks desc from university;select first_name, last name, percentage_of_marks from university order by percentage_of_marks;select first_name, last name, percentage_of_marks from university order by percentage_of_marks desc;select first_name, last name, percentage_of_marks from university order by percentage_of_marks descending;