Select ________ dept_namefrom instructor;Here which of the following displays the unique values of the column?FromNameDistinctAll

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

Which keyword is used to display uniquely data from any specific column ?

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

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 C652123 CS403 201603 K. Ross AStudentSID Lname Fname Major986223 Smith Janet Chemistry362112 Williams Henry Computer Science282712 Jones John English LiteratureWhat would the following SQL Select statement produce for output?select course.Description,registration.SID,registration.grade, student.lnamefrom registrationinner join courseon registration.courseID = course.courseIDinner join student on registration.sid = student.sidSelect one:a.No output, since this query cannot be performedb.Technical Writing 282712 B+ Jonesc.Technical Writing 282712 B+ JonesComputer Science I 362112 Williams Cd.Technical Writing 282712 B+ JonesComputer Science I 362112 Williams CNull 652123 Null A

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;