Question 1

The purpose of the OR REPLACE clause is to ______ an existing procedure.

Accepted Answer

OVERWRITE

Question 2

In the given Procedure header, the ________clause is optional. 

CREATE  OR  REPLACE  PROCEDURE  name  [parameters]  IS|AS

Accepted Answer

OR REPLACE

Question 3

The _____ are named PL/SQL blocks that are compiled and stored in the database.

Accepted Answer

SUBPROGRAMS

Question 4

The block structure of the subprograms is similar to the structure of anonymous blocks.

Accepted Answer

True

Question 5

A procedure is a PL/SQL block containing local variables, a BEGIN, and an END. The  procedure_name after the END keyword is mandatory.

Accepted Answer

False

Question 6

The actual is 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.

Accepted Answer

True

Question 7

The symbol >> is used for association operator?

Accepted Answer

False

Question 8

The code below is a correct example of passing parameters by combination notation.

add_dept  (p_loc=>1400, 'EDUCATION' );

Accepted Answer

False

Question 9

The positional parameter passing uses the associate operator.

Accepted Answer

False

Question 10

The Named parameter passing is the common method of passing parameters.

Accepted Answer

False

Question 11

Given the procedure below, how many parameters will return a value to the calling environment?
CREATE  OR  REPLACE  PROCEDURE  show_emps
(p_emp_id  NUMBER,  p_department_id OUT number,
p_hiredate  IN OUT DATE) IS
begin
      . . . . . .
End;

Accepted Answer

2

Question 12

Which parameter mode can be assigned a default value?

IN
OUT
IN OUT

Accepted Answer

IN

Question 13

Given the procedure below, what is the correct way of invoking the procedure?

CREATE  OR  REPLACE  PROCEDURE  show_emps

(p_emp_id  IN  NUMBER,  p_department_id IN number,

p_hiredate  IN  DATE) IS

begin

      . . . . . .

End;

Accepted Answer

Show_emps(101, 10,  ’01-dec-2006’);

show_emps(p_department_id =>  10, p_hiredate  =>  ’01-dec-1007’,  p_emp_id  =>  101)

All the options

show_emps(101, p_hiredate  =>  ’01-dec-2007’, p_department_id  =  10)

ANSWER: ALL

Question 14

What missing in the given function construct? 
CREATE [OR REPLACE] function_name
[(parameter1 [mode1] datatype1, ...)]
RETURN datatype IS|AS
[local_variable_declarations; …]
BEGIN
            actions;
RETURN expression; 
END [function_name];

Accepted Answer

FUNCTION

Question 15

The functions used in SQL statements cannot use OUT or _____ modes.

Accepted Answer

IN OUT

Question 16

A function must have a _______ clause in the header and at least one RETURN statement in the executable section.

Accepted Answer

RETURN

Question 17

A function can be called as a part of:

Accepted Answer

Both options

Question 18

Which of the statement below is valid? Assuming that get_sal function exists with parameter.

Accepted Answer

get_sal() + 50;

Question 19

In Procedure, the default parameter mode is _______.

Accepted Answer

IN

Question 20

The executable section of the procedure body requires a minimum of _____ statement.

Accepted Answer

ONE

Question 21

Subprograms become the building blocks of packages and triggers.

Accepted Answer

True

Question 22

In Procedure, the default parameter mode is IN.

Accepted Answer

True

Question 23

If Combination notation is used, the positional parameters must come first before the named parameters.

Accepted Answer

True

Question 24

To invoke a procedure from another procedure, use a direct call inside an executable section of the block.

Accepted Answer

True

Question 25

The IN parameters can only be read within the procedure and cannot be modified.

Accepted Answer

True

Question 26

The formal parameters can be literal values, variables, or expressions that are sent to the parameter list of a called subprogram.

Accepted Answer

False

Question 27

A procedure can be invoked in another procedure.

Accepted Answer

True

Question 28

Howmnyparameter
CREATE or replace procedure raise_sal
           (empid my_employees.employee_id%TYPE := 1234, emp_raise number) IS
BEGIN
        update employees
        set salary = salary + (salary * (emp_raise/100) where employee_id =  emp;
END;

Accepted Answer

2

Question 29

The operator => is called _______.

Accepted Answer

Association operator

Question 30

What is the symbol used for association operator?

Accepted Answer

=>

Question 31

If Combination notation is used, the _______ parameters must come first.

Accepted Answer

POSITIONAL

Question 32

Three ways of passing parameters from the calling environment:

Accepted Answer

POSITIONAL, NAMED, COMBINATION

Question 33

A function must have a _______ clause in the header and  at least one RETURN statement in the executable section.

Accepted Answer

RETURN

Question 34

A ______ is a named PL/SQL block that returns exactly one value.

Accepted Answer

FUNCTIONS

Question 35

What is missing in the code below?

create or replace function sample

return number

is num number(2);

begin

   num := 5+5;

end;

Accepted Answer

No return value

Question 36

What is missing in the code below?

create or replace function sample

return number

is

begin

   return 5+5;

end;

Accepted Answer

Nothing is missing

Question 37

Subprograms are implicitly shared.
Group of answer choices

True

False

Accepted Answer

False, explicitly

Question 38

The OUT parameter mode supplies an input value, which can be returned (output) as a modified value.
Group of answer choices

True

False

Accepted Answer

False

The OUT parameter mode is used to return a value from a procedure to the calling environment, but it does not take an input value from the caller when the procedure begins execution.

Question 39

Which parameter mode can be assigned a default value?

IN
OUT
IN OUT

Accepted Answer

IN

The IN mode is designed to pass values into a subprogram. Because the subprogram relies on this input to begin execution

Question 40

Which type of parameter passing uses an association operator?

Accepted Answer

Named

Question 41

The type of parameter that is declared in procedure heading is called ________.

Accepted Answer

FORMAL

Question 42

The parameter modes are specified in:

Accepted Answer

FORMAL PARAMETER

Question 43

How many value is returned by a function?_____

Accepted Answer

1

Question 44

The functions used in SQL statements cannot use ____ or IN OUT modes.

Accepted Answer

out

Question 45

The ____ parameters can be literal values, variables, or expressions that are sent to the parameter list of a called subprogram.

Accepted Answer

ACTUAL

Question 46

In PL/SQL ___________, the function identifier acts like a variable whose value depends on the parameters passed  to it.

Accepted Answer

EXPRESSION

Question 47

The Positional parameter passing is the common method of passing parameters.

Accepted Answer

True

Question 48

What follows the RETURN keyword at the function header?

Accepted Answer

DATA TYPE

"Know" box contains:
Time elapsed:
Retries:

DBSA FA3