Question 1

Which keyword is omitted in the declaration section of the procedure? _____

Accepted Answer

DECLARE

Question 2

Subprograms become the building blocks of packages and triggers.

Accepted Answer

True

Question 3

Subprograms are implicitly shared.

Accepted Answer

False

Question 4

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

Accepted Answer

False

Question 5

A procedure can be invoked in another procedure.

Accepted Answer

True

Question 6

The positional parameter passing uses the associate operator.

Accepted Answer

False

Question 7

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

Accepted Answer

True

Question 8

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

Accepted Answer

True

Question 9

How many parameters are there in the given code?
CREATE or replace procedure raise_sal (empid my_employees.employee_id%TYPE := 1234, emp_raise number) ISBEGINupdate employees set salary = salary + (salary * (emp_raise/100) where employee_id =  emp;
END;

Accepted Answer

2

Question 10

Three ways of passing parameters from the calling environment:

Accepted Answer

POSITIONAL, NAMED, COMBINATION

Question 11

Which type of parameter passing uses an association operator?

Accepted Answer

Named

Question 12

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

Accepted Answer

IN OUT

Question 13

In stored function, the RETURN clause is used instead of ____ mode.

Accepted Answer

OUT

Question 14

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

Accepted Answer

EXPRESSION

Question 15

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

Accepted Answer

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

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

Accepted Answer

SUBPROGRAMS

Question 18

Subprograms are named PL/SQL blocks that are compiled and stored in the _______.

Accepted Answer

DATABASE

Question 19

You cannot invoke a procedure from inside an SQL statement.

Accepted Answer

True

Question 20

Subprograms are explicitly shared.

Accepted Answer

True

Question 21

The OUT parameter mode supplies an input value, which can be returned (output) as a modified value.

Accepted Answer

False

Question 22

False

Accepted Answer

True

Question 23

The DEFAULT keyword is used to assign a default value for formal parameters.

Accepted Answer

False

Question 24

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

Accepted Answer

IN

Question 25

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 26

What is the error of the given code?

BEGIN

add_dept(name  =>'new  dept',  'new  location');

END;

Accepted Answer

Positional parameter must come before named parameter

Question 27

Subprograms are implicitly shared.

Accepted Answer

False

Question 28

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

Accepted Answer

False

Question 29

A procedure can be invoked in another procedure.

Accepted Answer

True

Question 30

The positional parameter passing uses the associate operator.

Accepted Answer

False

Question 31

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

Accepted Answer

True

Question 32

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

Accepted Answer

True

Question 33

How many parameters are there in the given code?
CREATE or replace procedure raise_sal (empid my_employees.employee_id%TYPE := 1234, emp_raise number) ISBEGINupdate employees set salary = salary + (salary * (emp_raise/100) where employee_id =  emp;
END;

Accepted Answer

2

Question 34

Three ways of passing parameters from the calling environment:

Accepted Answer

POSITIONAL, NAMED, COMBINATION

Question 35

Which type of parameter passing uses an association operator?

Accepted Answer

Named

Question 36

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

Accepted Answer

IN OUT

Question 37

In stored function, the RETURN clause is used instead of ____ mode.

Accepted Answer

OUT

Question 38

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

Accepted Answer

EXPRESSION

Question 39

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

Accepted Answer

OUT

Question 40

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

Accepted Answer

RETURN

Question 41

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

Accepted Answer

SUBPROGRAMS

Question 42

Subprograms are named PL/SQL blocks that are compiled and stored in the _______.

Accepted Answer

DATABASE

Question 43

You cannot invoke a procedure from inside an SQL statement.

Accepted Answer

True

Question 44

Subprograms are explicitly shared.

Accepted Answer

True

Question 45

The OUT parameter mode supplies an input value, which can be returned (output) as a modified value.

Accepted Answer

False

Question 46

False

Accepted Answer

True

Question 47

The DEFAULT keyword is used to assign a default value for formal parameters.

Accepted Answer

False

Question 48

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

Accepted Answer

IN

Question 49

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 50

What is the error of the given code?

BEGIN

add_dept(name  =>'new  dept',  'new  location');

END;

Accepted Answer

Positional parameter must come before named parameter

Question 51

In stored function, the ______ clause is used instead of OUT mode.

Accepted Answer

RETURN

Question 52

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

Accepted Answer

HEADER

Question 53

What follows the RETURN keyword at the function header?

Accepted Answer

DATA TYPE

Question 54

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 55

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

Accepted Answer

OVERWRITE

Question 56

In Procedure, all parameter modes must be specified.

Accepted Answer

True

Question 57

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

Accepted Answer

True

Question 58

The symbol >> is used for association operator?

Accepted Answer

False

Question 59

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

Accepted Answer

True

Question 60

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

Accepted Answer

False

Question 61

Another way of initializing a default value for parameter is by using assignment operator.

Accepted Answer

True

Question 62

What is the symbol used for association operator?

Accepted Answer

=>

Question 63

What is missing in the given code below?
CREATE or replace procedure raise_sal
 (empid my_employees.employee_id%TYPE := 1234, emp_raise number)
BEGIN
 update employees
 set salary = salary + (salary * (emp_raise/100) where employee_id =  emp;
END;

Accepted Answer

Not in the options

Question 64

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

Accepted Answer

OUT

Question

Question

Question

Database SA2

summative

"Know" box contains:
Time elapsed:
Retries: