FORMATIVE 3

Question 1

The block structure of the subprograms is similar to the structure of (ANONYMOUS) blocks.

True or False

Answer 1

True

Question 2

The (SUBPROGRAMS) are named PL/SQL bocks that are compiled and stored in the database.

True or False

Question 3

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

True or False

Answer 3

True

Question 4

You can invoke a procedure from inside an SQL statement.

True or False

Answer 4

False

Question 5

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

True or False

Answer 5

True

Question 6

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

True or False

Answer 6

False

Question 7

A procedure can be invoked in another procedure.

True or False

Answer 7

True

Question 8

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

True or False

Answer 8

True

Question 9

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

True or False

Answer 9

False

Question 10

Which can be used to assign a default value to IN parameters?

:=

Assignment operator

DEFAULT

All the options

Answer 10

All the options

Question 11

The parameter modes are specified in:

FORMAL PARAMETER

ACTUAL PARAMETER

Answer 11

FORMAL PARAMETER

Question 12

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

ACTUAL

FORMAL

Answer 12

FORMAL

Question 13

Which type of parameter passing uses an association operator?

Positional

Named

IN OUT

Combination

Answer 13

Named

Question 14

When invoking a function as part of a PL/SQL expression, you can use a (LOCAL VARIABLE) to store the returned result.

True or False

Answer 14

True

Question 15

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

True or False

Answer 15

True

Question 16

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

OUT

IN

Answer 16

OUT

Question 17

The (OR REPLACE) is added to CREATE PROCEDURE clause to overwrite an existing procedure.

True or False

Answer 17

True

Question 18

In Procedure, the default parameter mode is (IN).

True or False

Answer 18

True

Question 19

In anonymous block, DECLARE states “this is the start of a block”. In Procedure, (CREATE PROCEDURE) states “this is the start of a subprogram”.

True or False

Answer 19

True

Question 20

The positional parameter passing uses the associate operator.

True or False

Answer 20

False

Question 21

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

True or False

Answer 21

True

Question 21

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

True or False

Answer 21

False

Question 22

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

True or False

Answer 22

True

Question 23

The purpose of the OR REPLACE clause is to (OVERWRITE) an existing procedure.

True

False

Answer 23

True

Question 24

A procedure is compiled and stored in the database as a schema object. True False

Answer 24

True

Question 25

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

Answer 25

True

Question 26

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. True False

Answer 26

False

Question 27

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

Answer 27

False

Question 28

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

Answer 28

True

Question 29

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

Answer 29

POSITIONAL

Question 30

The _____ parameters can be literal values, vairables, or expressions that are sent to the paramter list ofa called subprogram. FORMAL ACTUAL

Answer 30

ACTUAL

Question 31

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

Answer 31

IN

Question 32

A stored function must return exactly (ONE) value. True False

Answer 32

True

Question 33

Subprograms are named PL/SQL blocks that are compiled and stored in the (DATABASE). True False

Answer 33

True

Question 34

Subprograms are implicitly shared. True False

Answer 34

False

Question 35

Subprograms are explicitly shared. True False

Answer 35

True

Question 36

The operator => is called ______. Referencing operator Reference operator Associate operator Association operator

Answer 36

Association operator

Question 37

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

Answer 37

IN OUT

Question 38

What follows the RETURN keyword at the function header? VARIABLE DATA TYPE IS PARAMETER

Answer 38

DATA TYPE

Question 39

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

Answer 39

True

Question 40

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

Answer 40

True

Question 41

We can assign a default value to parameters. True False

Answer 41

False

Question 42

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; Nothing is missing Not in the options IN

Answer 42

Not in the options

Question 43

A function can be called as a part of: Not in the options SQL statement SQL statement, PL/SQL expression PL/SL expressoin

Answer 43

SQL statement, PL/SQL expression

Question 44

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

Answer 44

True

Question 45

You cannot invoke a procedure from inside an SQL statement. True False

Answer 45

True

Question 46

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

Answer 46

False

Question 47

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

Answer 47

False

Question 48

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; 2 0 1 3

Answer 48

2

Question 49

In stored function, the parameter mode should only be (IN) True False

Answer 49

True

Question 50

What is missing in the code below? create or replace function sample return number is begin return 5+5; end; Variable Nothing is missing Formal parameter Expression evaluation

Answer 50

Nothing is missing