I am re-taking the Program Units Exam in a few days. I remember a few questions that stumped me. If anyone can answer some or all of them it would EXTREMELY appreciated . Thanks in advance…
•What is the number of cascading triggers limited by which db init parameter?
•Example: Two procedures are within a package. There is also a cursor and a loop in which both procedures use. Proc1 is executed. Then Proc2 is executed. What is returned by Proc2? - Each cycle through the loop caused a DBMS_OUTPUT.PUT_LINE message to appear stating the record number.
•Are the specification and the body of a pkg stored separately in the db?
•How do you invoke a procedure from within a procedure? Can SQL insert statements be in the declare section of a procedure?
MULTIPLE CHOICE QUESTIONS
•What are two ways stored procedures and stored functions improve performance?
A)Because the work is being done by the server PL/SQL engine
B)Because fewer round trips to the db
C)Because PL/SQL code is not parsed until runtime
•What happens during the parse phase of dynamic SQL?
A)Rows selected and ordered
B)# of rows processed and returned
C)Validity of SQL statement validated
D)Area of memory established to process SQL
E)Area of memory established to process SQL is released
•What happens during the execution phase of dynamic SQL?
A)Rows selected and ordered
B)# of rows processed and returned
C)Validity of SQL statement validated
D)Area of memory established to process SQL
E)Area of memory established to process SQL is released
•Which allows a PL/SQL user defined function?
A)Nextval
B)Having clause in a select command
C)Alter table command
D)From clause of an update or select commands
•Which 2 programming constructs can be in a group within a package?
A)Cursor
B)Constant
C)Trigger
D)Sequence
E)View
•What is the number of cascading triggers limited by which db init parameter?
•Example: Two procedures are within a package. There is also a cursor and a loop in which both procedures use. Proc1 is executed. Then Proc2 is executed. What is returned by Proc2? - Each cycle through the loop caused a DBMS_OUTPUT.PUT_LINE message to appear stating the record number.
•Are the specification and the body of a pkg stored separately in the db?
•How do you invoke a procedure from within a procedure? Can SQL insert statements be in the declare section of a procedure?
MULTIPLE CHOICE QUESTIONS
•What are two ways stored procedures and stored functions improve performance?
A)Because the work is being done by the server PL/SQL engine
B)Because fewer round trips to the db
C)Because PL/SQL code is not parsed until runtime
•What happens during the parse phase of dynamic SQL?
A)Rows selected and ordered
B)# of rows processed and returned
C)Validity of SQL statement validated
D)Area of memory established to process SQL
E)Area of memory established to process SQL is released
•What happens during the execution phase of dynamic SQL?
A)Rows selected and ordered
B)# of rows processed and returned
C)Validity of SQL statement validated
D)Area of memory established to process SQL
E)Area of memory established to process SQL is released
•Which allows a PL/SQL user defined function?
A)Nextval
B)Having clause in a select command
C)Alter table command
D)From clause of an update or select commands
•Which 2 programming constructs can be in a group within a package?
A)Cursor
B)Constant
C)Trigger
D)Sequence
E)View