gs gs117 SQL: Queries, Constraints and Triggers - Modification of Database - 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.
Delete from r where P;The above command
Insert into course (course id, title, dept name, credits) values (’CS-437’, ’Database Systems’, ’Comp. Sci.’, 4); Insert into instructor select ID, name, dept name, 18000 from student where dept name = ’Music’ and tot cred > 144;Insert into course values (’CS-437’, ’Database Systems’, ’Comp. Sci.’, 4); Delete from instructor where dept_name in 'Watson'; Delete from department where building='Watson'; Delete from instructor where dept_name in (select dept name from department where building = ’Watson’); Case when pred1 ... result1 when pred2 ... result2 . . . when predn ... resultn else result0 end Case when pred1 then result1 when pred2 then result2 . . . when predn then resultn else result0 end Case when pred1 then result1 when pred2 then result2 . . . when predn then resultn else result0 Update instructor set salary = salary * 1.03 where salary > 100000; update instructor set salary = salary * 1.05 where salary <= 100000; Update instructor set salary = salary * 1.05 where salary < (select avg (salary) from instructor); Update instructor set salary = case when salary <= 100000 then salary * 1.03 else salary * 1.05 endOnline Quizzes of gs117 Database Management System
