Deck 5: Procedures

Question 1

The values from the application that pass into parameters are called actual parameters; the parameters in the procedure declaration are called formal parameters.

Answer 1

True

Question 2

A(n) database trigger performs tasks automatically when a particular application event occurs such as when a user clicks a button on the screen. _________________________

Answer 2

False, application trigger

Question 3

A PL/SQL block that is created and named is known as a(n) named program unit. _________________________

Answer 3

True

Question 4

An application trigger performs a task automatically when a DML action occurs on the table with which it is associated.

Question 5

Exception handling refers to the logical group of DML actions that is affected by a transaction control statement.

Question 6

A PL/SQL block created and named is a named program unit or subprogram.

Question 7

A(n) application trigger performs tasks automatically when a DML action occurs on the table with which it is associated. _________________________

Question 8

The special syntax of =>> is used to accomplish named association.

Question 9

The reuse of code is an important contributor to programming efficiency.

Question 10

Exception handling is the process of identifying and removing errors from within program code.

Question 11

Three choices exist for parameter mode: INTO, OUT OF, and IN OUT.

Question 12

Only the program unit in which a subprogram is declared can use that subprogram.

Question 13

A program unit that is defined within another program unit is called a subprogram.

Question 14

A(n) procedure is used to accomplish one or more tasks, return none or many values, and can be used only in PL/SQL statements. _________________________

Question 15

Stored procedures and functions are saved in an Oracle11g application or library on the client-side. _________________________

Question 16

The term server-side refers to code that resides on the client machine.

Question 17

Stored procedures are saved in an Oracle11g application or library on the client-side.

Question 18

The term program unit implies that we typically create blocks of code to perform specific tasks that may be needed within a number of applications. _________________________

Question 19

Program units are made flexible by using parameters, which are mechanisms to send values into and out of the program unit. _________________________

Question 20

The term pragma refers to additional instructions for the PL/SQL compiler to use during program unit compilation.

Question 21

The term ____ refers to program code that resides on the user machine.

A) client-side
B) client/server
C) two-tier
D) server-side

Question 22

____ are saved in an Oracle11g application or library on the client-side.

A) Stored procedure and functions
B) Functions
C) Packages
D) Application procedures

Question 23

A(n) ____ performs tasks automatically when a DML action occurs on the table with which it is associated.

A) package
B) stored procedure
C) application trigger
D) database trigger

Question 24

A(n) ____ contains a RETURN clause and is used to manipulate data and return a single resulting value.

A) procedure
B) application
C) function
D) database trigger

Question 25

The parameters in the procedure declaration of an application are called actual parameters. _________________________

Question 26

The term autonomous transaction refers to additional instructions for the PL/SQL compiler to use during program unit compilation. _________________________

Question 27

The special syntax of := is used to accomplish named association. _________________________

Question 28

____ can accept and return none, one, or many parameters.

A) Triggers
B) Procedures
C) Packages
D) Programs

Question 29

One important item that needs to be considered when creating stored procedures is to make them flexible so that they can be ____.

A) executed
B) reused
C) packaged
D) triggered

Question 30

____ is an example of a function.

A) ROUND
B) IN
C) OUT
D) IN OUT

Question 31

Debugging is the process of identifying and removing errors from within program code. _________________________

Question 32

____ no longer exist after being executed.

A) Program units
B) Exception handlers
C) Anonymous blocks
D) Parameters

Question 33

The EXIT command can be used to remove procedures. _________________________

Question 34

When invoking a procedure list, the values are listed in the order in which the parameters are declared in the procedure. _________________________

Question 35

A(n) ____ performs tasks automatically when a particular application event occurs, such as when the user clicks a button on the screen.

A) package
B) application trigger
C) stored procedure
D) database trigger

Question 36

____ are stored on the server.

A) Stored procedures
B) Application procedures
C) Packages
D) Database triggers

Question 37

In a(n) positional method, you associate a value to each parameter by name in the invoke statement. _________________________

Question 38

The values from an application that pass into parameters are called formal parameters. _________________________

Question 39

____ a program unit or PL/SQL block of code allows the storage and reuse of the code.

A) Naming
B) Processing
C) Creating
D) Debugging

Question 40

____ are mechanisms used to send values into and out of a program unit.

A) Parameters
B) Procedures
C) Database triggers
D) Packages

Question 41

When creating a procedure, each parameter is listed, along with a mode and ____.

A) function
B) package
C) variable
D) data type

Question 42

____ is a compiler directive.

A) Autonomous
B) Pragma
C) Subprogram
D) EXCEPTION

Question 43

In the following code fragment, the IS keyword indicates that the ____. CREATE OR REPLACE PROCEDURE total_calc_sp
(p_basket IN bb_basket.idbasket%TYPE,
P_total OUT bb_basket.total%TYPE := 0 )
IS

A) executable section follows
B) exception handlers follow
C) PL/SQL block follows
D) function follows

Question 44

Which of the following statements is True?

A) If an exception is raised in procedure B that has been called from procedure A, the control initially moves to the exception handler section of procedure B.
B) If an exception is raised in procedure B that has been called from procedure A, the control initially moves to the BEGIN section of procedure B.
C) If an exception is raised in procedure B that has been called from procedure A, the control initially moves to the exception handler section of procedure A.
D) If an exception is raised in procedure B that has been called from procedure A, the control initially moves to the header section of procedure B.

Question 45

The ____ command can be used to list details about the structure of a procedure, such as information regarding the parameters.

A) UPDATE
B) DESCRIBE
C) TYPE
D) %TYPE

Question 46

If values are calculated or retrieved from the database within the procedure, ____ parameters are used to return these values to the calling environment.

A) IN
B) OUT
C) IN OUT
D) INOUT

Question 47

____are transactions created within another transaction.

A) Pragma transactions
B) Dynamic transactions
C) Autonomous transactions
D) Subprograms

Question 48

The ____ mode type is considered constant because it cannot be changed within the procedure.

A) IN
B) OUT
C) INOUT
D) IN OUT

Question 49

____ is an acceptable error number for the RAISE_APPLICATION_ERROR function.

A) -18,000
B) -19,000
C) -20,002
D) -21,000

Question 50

The ____ area of a block determines what happens if an error occurs.

A) transaction scope
B) mode
C) data type
D) exception handling

Question 51

The variable name ____ conforms to Oracle11g naming standards.

A) $quantity
B) ship_date
C) :p_ship
D) _ship_date

Question 52

The DBMS_OUTPUT statement is used to ____.

A) create error messages
B) create exceptions
C) display exceptions to the screen
D) display a message to the screen

Question 53

The error message argument of the RAISE_APPLICATION_ERROR function can accept up to ____ characters.

A) 300
B) 450
C) 512
D) 600

Question 54

A(n) ____ must be assigned one of three available modes: IN, OUT, IN OUT.

A) function
B) parameter
C) package
D) procedure

Question 55

The RAISE_APPLICATION_ERROR built-in function is provided by Oracle to ____.

A) create error messages
B) display error messages
C) track error messages
D) display functions

Question 56

The DBMS_OUTPUT.PUT_LINE statement can be used to ____.

A) assist with the creation of a cursor
B) assist with the creation of an exception
C) assist with creating functions
D) assist with debugging your code

Question 57

A parameter with a(n) ____ only mode can receive a value, but this value cannot be changed in the procedure.

A) IN OUT
B) IN
C) OUT
D) INOUT

Question 58

If a table column data type is modified, no changes to associated variables are required because the ____ attribute always uses the column's current data type.

A) TYPE
B) :=
C) =>
D) %TYPE

Question 59

The RAISE_APPLICATION_ERROR function accepts the ____ arguments.

A) Error ID
B) Error name
C) Error length
D) Error message

Question 60

The following code is considered to be a ____. CREATE OR REPLACE PROCEDURE total_calc_sp
(p_basket IN bb_basket.idbasket%TYPE,
P_total OUT bb_basket.total%TYPE := 0 )
IS

A) function header section
B) PL/SQL block
C) procedure header section
D) DECLARE section

Question 61

What information must be provided in the header section of a PL/SQL block for each parameter? Provide an explanation for each.

Question 62

In a(n) ____________________, you associate a value to each parameter by name in the invoke statement.

Question 63

____________________ indicate which way the value provided for the parameter flows: into the procedure, out of the procedure, or both.

Question 64

With a(n) ____________________ only parameter, the parameter is empty when the procedure is invoked and a value is assigned to the parameter during the execution of the procedure and returned upon completion.

Question 65

A subprogram is created in the ____________________ section of the procedure block.

Question 66

The ____________________ area of a block determines what happens if an error occurs.

Question 67

Three pieces of information for each parameter must be provided in the header: name, mode, and ____________________.

Question 68

What is the difference between a database trigger and an application trigger?

Question 69

If no mode is indicated in a parameter, the default value of ____________________ is applied.

Question 70

____________________ refers to the logical group of DML actions that is affected by a transaction control statement.

Question 71

A(n) ____________________ contains a RETURN clause and is used to manipulate data and return a single resulting value.

Question 72

What is the difference between a function and a procedure?

Question 73

The ____ command can be used to remove procedures.

A) DEL
B) DROP
C) DELETE
D) REMOVE

Question 74

The ____________________ combined mode can achieve the passing of a value both into and out of a procedure with a single parameter.

Question 75

____________________ is the process of identifying and removing errors from within program code.