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