gs gs117 SQL: Queries, Constraints and Triggers - Basic SQL Operations - 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 employee where dept_name="Comp Sci";In the SQL given above there is an error . Identify the error.
Select * from instructor order by salary ____, name ___;To display the salary from greater to smaller and name in ascending order which of the following options should be used?
Select name from instructor where salary <= 100000 and salary >= 90000;This query can be replaced by which of the following ?
Select name from instructor where salary between 90000 and 100000; Select name from employee where salary <= 90000 and salary>=100000; Select name from employee where salary between 90000 and 100000; Select name from instructor where salary between 100000 and 90000; Select instructor.* from instructor, teaches where instructor.ID= teaches.ID;This query does which of the following operation?
Online Quizzes of gs117 Database Management System
