Hello!

These are the questions that I saw on pl/sql exam.But, I am still not sure what the corret answers are. Any Help??

1)7. EVALUATE THIS IF STATEMENT

IF V_VALUE > 100 THEN
V_NEW_VALUE := 2 * V_VALUE
ELSEIF V_VALUE >200 THEN
V_NEW_VALUE := 3 * V_VALUE
ELSEIF V_VALUE >300 THEN
V_NEW_VALUE := 4 * V_VALUE
ELSE
V_NEW_VALUE := 4 * V_VALUE
ENDIF;

WHAT VALUE BE ASSIGNED TO V_NEW_VALUE IF V_VALUE = 250:

My Ans: 500

16. EVALUATE THIS PL/SQL BLOCK

BEGIN
FOR I IN 1..10 LOOP
IF I=4 OR I=6 THEN NULL;
ELSE
INSERT INTO TEST(RESULT) VALUES(1);
END;
COMMIT;
END LOOP;
ROLL BACK;
END;

HOW MANY VALUES WILL BE INSERTED INTO THE TEST TABLE ?

my ans: 8

83. EXAMINE THIS CODE

SELECT EMPLOYEE.ENAME
FROM EMPLOYEE
WHERE EMPLOYEE.ENAME NOT IN (SELECT MANAGER.MGR FROM EMP.MANAGER);

WHAT IS NOT AN OPERATOR FOR EQUIVALENT TO THE ABOVE PARA
1) !=
2)!= ALL
3)...

38. GIVE THIS EXECUTABLE SECTION OF THE PL/SQL BLOCK

BEGIN
FOR EMPLOYEE_RECORD IN SALARY_CURSOR
LOOP
EMPLOYEE_ID_TABLE(EMPLOYEE) := EMPLOYEE_RECORD.LAST_NAME;
ENDLOOP
CLOSE SALARY_CURSOR;
END;

WHY DOES THIS SECTION CAUSE AN ERROR

my ANS: THE CURSOR DOES NOT NEED TO BE EXPLICITY CLOSED.


which table name is valid?
1. #667
2. number
3. catch_#22
4. 1996_invoices
5. invoices-1996