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;

he correct answerRight replacement of below given Query is : SELECT Name, CourseId  FROM Faculty, Teaches  WHERE FacultyID= TeachesID;OptionsSelect Name, CourseId from Faculty natural join Teaches;Select Name, CourseId from Faculty;Select Name,CourseId from Teaches,Faculty where FacultyId=CourseId;Select CourseId from Faculty join Teaches;

Select ID, name, dept name, salary * 1.1 where instructor;The query given below will not give an error. Which one of the following has to be replaced to get the desired output?*Salary*1.1IDWhereInstructor

SELECT LECTURERS.SURNAME, LECTURERS.SURNAMEFROM LECTURERS, LECTURERSWHERE DEPT_NO = DEPT_NO ;The above query is syntactically correct.Question 2Select one:TrueFalse

SELECT DISTINCT LastName, FirstNameFROM Instructors i JOIN Courses c  ON i.InstructorID = c.InstructorIDORDER BY LastName, FirstName ; Write a SELECT statement (Commented as 5A-2 ) that returns the same result set as this SELECT statement, but don’t use a join. Instead, use a subquery in a WHERE clause that uses the  IN

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;