Test Difficulty Level: Easy
Syllabus of Test
Covering all general topics of SQL.
Sample Question from this online test:
Question: With regard to the following PL/SQL block, which of the following options is most correct ?
SET salary = salary * 1.10
WHERE class_code = 'A';
SET salary = salary * 1.07
WHERE class_code = 'B';
SET salary = salary * 1.05
WHERE class_code = 'C';
ROLLBACK TO SAVEPOINT ClassB_FloorAdjusted;
SET max_tax = 76200*0.075
WHERE tax_type = 'FICA';
ROLLBACK to MaxTax;
ROLLBACK to ClassA_FloorAdjusted;
Option A: No changes occur to the EMP, but the TAXES table is changed.
Option B: Both the EMP and TAXES tables are changed.
Option C: Only EMP rows with class_code equal to 'A' are changed.
Option D: Only EMP rows with class_codes equal to 'C' are changed.
To answer, click the "Start This Test" button below.
Related Online Tests:
prasanna prasanna on 2012-07-19 04:04:18 wrote,