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

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;

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

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;

Evaluate below sql statement SELECT emp_name, department FROM employees WHERE department = 'HR' UNION SELECT contractor_name, department FROM contractors WHERE department = 'IT';Select one:a. Retrieves the names of all employees and contractors from the HR and IT departments.b. Retrieves the names of employees from the HR department and all contractors.c. Retrieves the names of employees and contractors from the HR and IT departments, excluding employees from the IT department and contractors from the HR department.d. Retrieves the names of employees from the HR department and contractors from the IT department.