Miscellaneous Test 2 - Online Test

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 ?

BEGIN
UPDATE emp
SET salary = salary * 1.10
WHERE class_code = 'A';
SAVEPOINT ClassA_FloorAdjusted;

UPDATE emp
SET salary = salary * 1.07
WHERE class_code = 'B';
SAVEPOINT ClassB_FloorAdjusted;

UPDATE emp
SET salary = salary * 1.05
WHERE class_code = 'C';
SAVEPOINT ClassC_FloorAdjusted;

ROLLBACK TO SAVEPOINT ClassB_FloorAdjusted;

UPDATE taxes
SET max_tax = 76200*0.075
WHERE tax_type = 'FICA';
SAVEPOINT MaxTax;

ROLLBACK to MaxTax;
ROLLBACK to ClassA_FloorAdjusted;
END;
COMMIT;

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.

Start this Test






Comments

prasanna prasanna on 2012-07-19 04:04:18 wrote,

good