COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Observe the following code and fill in the blanks-DECLARE total ____ rows number(2);BEGIN UPDATE employees SET salary = salary + 500; IF ____ THEN dbms ____ output.put ____ line(’no employees selected’); ELSIF ____ THEN total ____ rows:= ____ ; dbms ____ output.put ____ line( total ____ rows || ‘ employees selected ‘); END IF; END;
|
|
%notfound, %found, %rowcount
|
|
|
sql%notfound, sql%found, sal%rowcount
|
|
|
sql%found, sql%notfound, sal%rowcount
|
|
|
%found, %notfound, %rowcount.
|
Explanation:
There is 1 question to complete.