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 the distinct honours subjects in the university table?Optionsselect distinct honours_subject from university;select honours_subject from university;No query is correctselect all honours_subject distinct from university;select * distinct from university;

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;

Select the correct answerCourse(course_id,sec_id,semester)Here the course_id,sec_id and semester are __________ and course is a _________.OptionsAttributes, RelationRelations, AttributeTuples, SetTuples, AttributesFinish ClearPrev Next (1)

Select ________ dept_namefrom college;Here which of the following displays the unique values of the column ? AllFromDistinctNameReview AnswerNext

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

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