gs gs117 SQL: Queries, Constraints and Triggers - Aggregate Functions and Nested Subqueries - Quiz No.1
gs gs117 Database Management System Quiz
This quiz belongs to book/course code gs gs117 Database Management System of gs organization. We have 92 quizzes available related to the book/course Database Management System. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic SQL: Queries, Constraints and Triggers. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Select __________ from instructor where dept name= ’Comp. Sci.’;Which of the following should be used to find the mean of the salary ?
Select distinct course id from section where semester = ’Fall’ and year= 2009 and course id not in (select course id from section where semester = ’Spring’ and year= 2010); Select distinct course_id from instructor where name not in (’Fall’, ’Spring’); (Select course id from section where semester = ’Spring’ and year= 2010) Select count (distinct ID) from takes where (course id, sec id, semester, year) in (select course id, sec id, semester, year from teaches where teaches.ID= 10101); Select course id from section as S where semester = ’Fall’ and year= 2009 and exists (select * from section as T where semester = ’Spring’ and year= 2010 and S.course id= T.course id); Select name from instructor where salary > some (select salary from instructor where dept name = ’Biology’); Select count (distinct ID) from takes where (course id, sec id, semester, year) in (select course id, sec id, semester, year from teaches where teaches.ID= 10101); (Select course id from section where semester = ’Spring’ and year= 2010)Online Quizzes of gs117 Database Management System
