PLSQL online test, online practice test, exam, quiz

PLSQL Online Test

The purpose of this online test is to help you evaluate your PLSQL knowledge yourself. These Multiple Choice Questions (MCQs) on PLSQL will prepare you for technical round of job interview, written test and many certification exams.

The test contains 22 questions and there is no time limit. You will get 1 point for each correct answer. You will get your online test score after finishing the complete test.
(Total 22 questions)        (Time spent 0:0)

1. What output will come in following program? DECLARE
TYPE EmpRec IS RECORD (last_name employees.last_name%TYPE, salary employees.salary%TYPE);
emp_info EmpRec;
emp_id NUMBER := 100;
BEGIN
UPDATE employees SET salary = salary * 1.1 WHERE employee_id = emp_id
RETURNING last_name, salary INTO emp_info;
dbms_output.put_line('Just gave a raise to ' || emp_info.last_name ||
', who now makes ' || emp_info.salary);
ROLLBACK;
END;




   View Test Answer
Advertisement