Test time left: 27:47Choose the correct answerThe query which selects the Course_id ‘CS-101’ from the section relation isOptionsSelect Course_id from section where Year = ‘2009’;Select Course_id from section where Building = ‘Richard’;Select Course_id from teaches where Building = ‘Packyard’;Select Course_id from section where Sec_id = ‘3’;

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)

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

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

Course(course_id,sec_id,semester)Here the course_id,sec_id and semester are __________ and course is a _________.OptionsRelations, AttributeTuples, SetTuples, AttributesAttributes, Relation

Below query can be replaced by which one of the following?Select name, course_idfrom instructor, teacheswhere instructor_ID= teaches_ID;Select course_id from instructor join teaches;Select name, course_id from instructor natural join teaches;Select name ,course_id from instructor;Select name,course_id from teaches,instructor where instructor_id=course_id;