PL/SQL Section 8 Quiz

 1. Suppose you set up a parameter with an explicit IN mode. What is true about that parameter?

Tandai untuk Ditinjau

(1) Point

It must be the same type as the matching OUT parameter.

It inherits its type from the matching OUT parameter.

It acts like a constant (its value cannot be changed inside the subprogram). (*)

It must have a DEFAULT value.

It cannot have a DEFAULT value.

Incorrect. Refer to Section 8 Lesson 3.

---

2. A procedure is invoked by this command:

myproc('Smith',salary=>5000);

What is the method of passing parameters used here?

Tandai untuk Ditinjau

(1) Point

Positional

Named

A combination of positional and named (*)

None of these.

Incorrect. Refer to Section 8 Lesson 3.

---

3. Procedure SOMEPROC has five parameters named A, B, C, D, E in that order. The procedure was called as follows:

SOMEPROC(10,20,30,D=>50,E=>60);

How was parameter D referenced?

Tandai untuk Ditinjau

(1) Point

Defaulted

Positionally

A combination of positionally and named

Named (*)

A combination of named and defaulted

Incorrect. Refer to Section 8 Lesson 3.

---

4. Which parameter mode is the default?

Tandai untuk Ditinjau

(1) Point

OUT

NUMBER

CONSTANT

VARIABLE

IN (*)

Incorrect. Refer to Section 8 Lesson 3.

---

5. Three IN parameters for procedure ADD_EMPLOYEE are defined as:
(p_name VARCHAR2 ,
p_salary NUMBER := 1000,
p_hired DATE DEFAULT SYSDATE)

The procedure is invoked by:

    add_employee('Jones');

What is the value of P_SALARY when the procedure starts to execute?

Tandai untuk Ditinjau

(1) Point

NULL

The procedure will not compile because P_SALARY should have been coded as DEFAULT 1000

1000 (*)

6. PL/SQL subprograms, unlike anonymous blocks, are compiled each time they are executed. True or False?

Tandai untuk Ditinjau

(1) Point

True

False (*)

Incorrect. Refer to Section 8 Lesson 1.

---

7. A stored PL/SQL procedure can be invoked from which of the following?

A. A PL/SQL anonymous block
B. A calling application
C. A SELECT statement
D. Another PL/SQL procedure

Tandai untuk Ditinjau

(1) Point

A and C

B and C

A only

A and B

A, B, and D (*)

Incorrect. Refer to Section 8 Lesson 1.

---

8. A PL/SQL procedure named MY_PROC1 has been successfully created in the database. The procedure has no parameters. Which of the following will successfully invoke the procedure in Application Express? (Choose two.)

Tandai untuk Ditinjau

(1) Point

DECLARE
    v_var1 NUMBER := 20;
BEGIN
    my_proc1(v_var1);
END;

CREATE OR REPLACE PROCEDURE my_proc2 IS
BEGIN
    my_proc1;
END my_proc2;(*)

SELECT my_proc1 FROM DUAL;

EXECUTE my_proc1;

BEGIN
    my_proc1;
END;(*)

Incorrect. Refer to Section 8 Lesson 1.

---

9. When modifying procedure code, the procedure code statement must be re-executed to validate and store it in the database. True or False?

Tandai untuk Ditinjau

(1) Point

True (*)

False

Correct

---

10. Subprograms and anonymous blocks can be called by other applications. True or False?

Tandai untuk Ditinjau

(1) Point

True

False (*)

11. You have created procedure MYPROC with a single parameter PARM1 NUMBER. Now you want to add a second parameter to the procedure. Which of the following will change the procedure successfully?

Tandai untuk Ditinjau

(1) Point

REPLACE PROCEDURE myproc
(parm1 NUMBER, parm2 NUMBER)
IS
BEGIN ...

ALTER PROCEDURE myproc ADD (parm2 NUMBER);

The procedure cannot be modified. Once a procedure has been created, the number of parameters cannot be changed.

CREATE OR REPLACE PROCEDURE myproc
(parm1 NUMBER, parm2 NUMBER);
(You do not need to repeat the detailed code of the procedure, only the header)

CREATE OR REPLACE PROCEDURE myproc
(parm1 NUMBER, parm2 NUMBER)
IS
BEGIN ... (*)

Incorrect. Refer to Section 8 Lesson 2.

---

12. Procedure SUBPROC was created as:

CREATE PROCEDURE subproc
  (p_param VARCHAR2)
IS BEGIN ...

You invoke the procedure by:

DECLARE
  v_param VARCHAR2(20) := 'Smith';
BEGIN
  subproc(v_param);
END;

Which of the following is the actual parameter?

Tandai untuk Ditinjau

(1) Point

v_param (*)

None of these.

Smith'

p_param

Incorrect. Refer to Section 8 Lesson 2.

---

13. Parameters are a special form of a variable, whose input values are initialized by the calling environment when the subprogram is called, and whose output values are returned to the calling environment when the subprogram returns control to the caller.

Tandai untuk Ditinjau

(1) Point

True (*)

False

Correct

---

14. What is the correct syntax to create procedure MYPROC that accepts two number parameters X and Y?

Tandai untuk Ditinjau

(1) Point

CREATE PROCEDURE (x NUMBER, y NUMBER) myproc IS ...

CREATE PROCEDURE myproc (x NUMBER, y NUMBER) IS ... (*)

CREATE PROCEDURE myproc IS (x NUMBER, y NUMBER) ...

CREATE PROCEDURE IS myproc (x NUMBER, y NUMBER) …

Correct

---

15. Which of the following best describes the difference between a parameter and an argument?

Tandai untuk Ditinjau

(1) Point

They are both names of variables. A parameter is passed into the procedure, while an argument is passed out of the procedure.

There is no difference; parameters and arguments are the same thing.

A parameter is a variable that accepts a value that is passed to it, while an argument is the value that is passed. (*)