Which Of The Following Relation Updates All Instructors With #311
Which of the following relation updates all instructors with salary over $100,000 receive a 3 percent raise, whereas all others receive a 5 percent raise.
This multiple choice question (MCQ) is related to the book/course
gs gs117 Database Management System.
It can also be found in
gs gs117 SQL: Queries, Constraints and Triggers - Modification of Database - Quiz No.1.
Which of the following relation updates all instructors with salary over $100,000 receive a 3 percent raise, whereas all others receive a 5 percent raise.
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 end
None of the mentioned
Similar question(s) are as followings:
Online Quizzes of gs117 Database Management System
Indexing and Hashing - Bitmap Indices - Quiz No.1
gs gs117 Database Management System
Online Quizzes
