FORMATIVE 2

Question 1

Start with the (TYPE) keyword to define a user-defined record structure.

True or False

Answer 1

True

Question 2

Use the ISOPEN cursor attribute before performing a fetch to test whether the cursor is open.

True or False

Answer 2

False

Question 3

The term (TRAPPING) in exceptions is the same as handling any error by including corresponding exception handler.

True or False

Answer 3

True

Question 4

Error in PL/SQL is known as (EXCEPTION)

True or False

Answer 4

True

Question 5

When an exception is raised, control immediately shifts to the (EXCEPTION SECTION) and the appropriate handler in the exception section is executed.

True or False

Answer 5

True

Question 6

Each exception handler is consists of a (WHEN) clause, which specifies an exception name.

True or False

Answer 6

True

Question 7

The RAISE keyword is used in user-defined exception for error notification.

True or False

Answer 7

True

Question 8

The term TRAP in exceptions is the same as handling any error by including corresponding exception handler.

True

False

Answer 8

True

Question 9

The (OTHERS) is an optional exception-handling clause that traps any exceptions that have not been explicitly handled.

True or False

Answer 9

True

Question 10

The OTHERS is mandatory exception-handling clause that traps any exceptions that have not been explicitly handled.

True or False

Answer 10

False

Question 11

Non-predeffined errors are raised explicitly

True or False

Answer 11

False

Question 12

Non-predefined exceptions has a standard Oracle error number (ORA-#####) and error message, but not a predefined name.

True or False

Answer 12

True

Question 13

Pragma declaration is used in declaring user-defined exceptions.

True

False

Answer 13

False

Question 14

You can use the __________ procedure to return userr-defined error messages from stored subprograms

EXCEPTION_INIT

RAISE_APPLICATION_ERROR

Answer 14

RAISE_APPLICATION_
ERROR

Question 15

User-defined exceptions are declared within the declarative section and are raised explicitly.

True or False

Answer 15

True

Question 16

The oracle error number, at the PRAGMA EXCEPTION_INIT function, starts with _____.

UNDERSCORE

0

1

HYPEN

Answer 16

HYPEN

Question 17

The _____ is used in non-predefined exception to tell the compiler to associate an exception name with a specific Oracle error.

PRAGMA EXCEPTION INIT

EXCEPTION_INIT

EXCEPTION INIT

PRAGMA EXCEPTION_INIT

Answer 17

PRAGRA EXCEPTION_INIT

Question 18

The NO_DATA_FOUND is an example of:

Non-predefined exception

Predefined exception

Answer 18

Predefined exception

Question 19

The RAISE statement can be used to raise either ____ or predfined exception.

USER-DEFINED

NON-PREDEFINED

Answer 19

USER-DEFINED

Question 20

What are/is the type of exception can be raised using the RAISE statement?

Pre-defined, Non-predefined

User-defined

Pre-defined, User-defined

Non-predefined, User-defined

NON-PREDEFINED

Answer 20

Pre-defined, Non-predefined

Question 21

Type and record declared in the outer block are visible only in the outer block.

True or False

Answer 21

False

Question 22

The type and the record declared in the outer block are visible within the outer block and the inner block.

True or False

Answer 22

True

Question 23

You must include the FOR UPDATE clause in the cursor query so that the rows are locked on (OPEN).

True or False

Answer 23

True

Question 24

PL/SQL record is a (COMPOSITE) data type, you can refer to the whole record by its name and/or to individual fields by their names.

True

False

Answer 24

True

Question 25

PL/SQL records contain one or more components/fields of any (SCALAR) or composite type. True False

Answer 25

True

Question 26

In explicit cursor operations, the set of rows returned by a multiple-row query is called RECORD SET. True False

Answer 26

False

Question 27

Always add (EXCEPTION HANDLERS) whenever there is a possibility of an error occurring. True False

Answer 27

True

Question 28

The exception section begins with the keyword (EXCEPTION) True False

Answer 28

True

Question 29

Always add exception handlers whenever there is a possibility of an error occuring. True False

Answer 29

True

Question 30

The following statements are examples of exception handler. Entering an expiration date that has passed Selecting more than one row into a single variable Receiving “no rows returned” from a select statement True False

Answer 30

True

Question 31

When code does not work as expected, PL/SQL raises an exception handler. True False

Answer 31

False

Question 32

Exception handlers are code that defines the recovery actions to be performed when execution-time errors occur. True False

Answer 32

True

Question 33

The RAISE_APPLICATION_ERROR can be used in executable and exception section. True False

Answer 33

True

Question 34

Pragma declaration is used in declaring non-predefined exceptions. True False

Answer 34

True

Question 35

There are 2 parameters needed in the pragma declaration of an exception. True False

Answer 35

True

Question 36

The RAISE statement can be used to raise either user-defined or predefined exception. True False

Answer 36

True

Question 37

The ________ clause is used in user-defined exception to tell the compiler to associate an exception name with a specific Oracle error PRAGMA EXCEPTION_INIT Not in the options SQLCODE, SQLERRM RAISE_APPLICATION_ERROR

Answer 37

PRAGMA EXCEPTION_INIT

Question 38

Two methods for raising an exception: Predefined, Non-predefined Implicit, Explicit

Answer 38

Implicit and Explicit

Question 39

The %ROWTYPE cannot be used to declare a record based on another record. True False

Answer 39

False

Question 40

Types and records are composite structures that can be declared anywhere that scalar variables can be declared. True False

Answer 40

True

Question 41

In explicit cursor operations, the set of rows returned by a multiple-row query is called ________. Cursor Active Cursor Record set Active set

Answer 41

Active Set

Question 42

If you omit the NOWAIT keyword, then the Oracle server waits indefinitely until the rows are available. True False

Answer 42

True

Question 43

TYPE and (RECORDS) are composite structures. True False

Answer 43

True

Question 44

The user-defined exceptions are declared within the declarative section and are raised implicitly. True False

Answer 44

False

Question 45

The PRAGMA clause is used in predefined exception to tell the compiler to associate an exception name with a specific Oracle error number. True False

Answer 45

False

Question 46

You can use the _______ procedure to return user-defined error messages from stored subprograms. RAISE_APPLICATION_ERROR SQLCODE SQLERRM PRAGRAM EXCEPTION_INIT

Answer 46

RAISE_APPLICATION_ ERROR

Question 47

What is the first step in handin non-predefined exception? Pragram declaration? Exceptino name declaration

Answer 47

Exception name declaration

Question 48

The () symbol is used to enclose the elements of the TYPE structure. True False

Answer 48

True

Question 49

The given syntax in declaring a user-define record is incorrect. TYPE type_name IS RECORD (field_declaration[,field_declaration]...); identifier type_name ; ------ True False

Answer 49

False

Question 50

The NOWAIT keyword is mandatory in the FOR UPDATE clause. True False

Answer 50

False

Question 51

What symbol is used to terminate the TYPE statement? DECLARE TYPE person_dept IS . . . . . . . . (;) True False

Answer 51

True

Question 52

The FETCH statement positions the cursor pointer at the first row. True False

Answer 52

False

Question 53

The OPEN will populate the cursor's active set with the result of the SELECT statement in the cursor's definition? True False

Answer 53

True

Question 54

When an exception is raised, the rest of the execution section of the PL/SQL block is not executed. True False

Answer 54

True

Question 55

An exception hanlder for a particular expression must contain only one statement. True False

Answer 55

False

Question 56

Exception section is mandatory in PL/SQL block. True False

Answer 56

False

Question 57

The EXECUTE keyword is used in user-defined exception for error notification. True False

Answer 57

False

Question 58

The SQLCODE function returns the numeric value for the error code. True False

Answer 58

True

Question 59

The RAISE_APPLICATION_ERROR can be used in: Executable and Exception section Executable section Declaration and Exception section Exception section

Answer 59

Executable and Exception Section

Question 60

In non-predefined exception, you must reference the ________ within a WHEN clause in the exception-handling section. All the options are possible Oracle associated error# Exception name Declared exception name

Answer 60

Declared exception name

Question 61

The declared non-predefined exception is raised _________. EXPLICITLY IMPLICITLY

Answer 61

IMPLICITLY

Question 62

The ___________ and ___________ are the two types of Oracle Server Errors. Predefined, Non-predefined Implicit, Explicit

Answer 62

Predefined, Non-predefined

Question 63

What keyword is missing in the given syntax of user-define record? (RECORD) TYPE type_name IS (field_declaration[,field_declaration]...); identifier typename ; True False

Answer 63

True

Question 64

An exception occurs when an error is discovered during the execution of a program that disrupts the normal operation of the program. True False

Answer 64

True

Question 65

In exception section, the WHEN clause if followed by a condition. True False

Answer 65

False

Question 66

Non-predefined errors are raised explicitly. True False

Answer 66

False

Question 67

Names for predefined exceptinos must be declared in the declaration section. True False

Answer 67

False

Question 68

When we declare a cursor FOR UPDATE, each row is locked as we open the cursor and prevent other users from reading the rows. True False

Answer 68

False