Question 1

Start with the _____ keyword to define a user-defined record structure.

Accepted Answer

TYPE

Question 2

What symbol is used to enclose the elements of the TYPE structure?

Note: Do not put space in your answer.

Accepted Answer

()

Question 3

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

Accepted Answer

False

Question 4

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

Accepted Answer

TRAP

Question 5

Handle named exceptions whenever possible, instead of using ______ in exception handlers.

Accepted Answer

OTHERS

Question 6

What is missing in the given exception syntax? ____ 

EXCEPTION

         WHEN  exception1  [OR  exception2  .  .  .]

                  statement1; statement2;

Accepted Answer

THEN

Question 7

Each exception handler is consists of a _____ clause, which specifies an  exception name.

Accepted Answer

WHEN

Question 8

The ___________ contains the exceptions handlers.

Accepted Answer

EXCEPTION SECTION

Question 9

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

Accepted Answer

True

Question 10

A block always terminates when PL/SQL raises an exception.

Accepted Answer

True

Question 11

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

Accepted Answer

True

Question 12

Exception section is mandatory in PL/SQL block.

Accepted Answer

False

Question 13

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

Accepted Answer

False

Question 14

You can use the EXCEPTION_INIT procedure to return user-defined error messages from stored subprograms.

Accepted Answer

False

Question 15

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

Accepted Answer

True

Question 16

Names for predefined exceptions must be declared in the declaration section.

Accepted Answer

False

Question 17

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

Accepted Answer

False

Question 18

exception

Accepted Answer

False

Question 19

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

Accepted Answer

Non-predefined, User-defined

Question 20

The declared non-predefined exception is raised ____________.

Accepted Answer

IMPLICITLY

Question 21

What is the first step in handing non-predefined exception?

Accepted Answer

Exception name declaration

Question 22

The RAISE statement can be used to raise either ________ or predefined exception.

Accepted Answer

USER-DEFINED

Question 23

The RAISE statement can be used to raise either user-defined or ________ exception.

Accepted Answer

PREDEFINED

Question 24

DECLARE

            v_emp_record employees2%rowtype; 

BEGIN

SELECT * INTO v_emp_record FROM employees2 WHERE  employee_id = 100;

DBMS_OUTPUT.PUT_LINE('Email for ' || _____________.first_name || ' ' || ____________.last_name);

END;

Accepted Answer

False

Question 25

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

Accepted Answer

False

Question 26

The %ROWTYPE can be used to declare a record based on another record.

Accepted Answer

True

Question 27

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

Accepted Answer

NOWAIT

Question 28

The NOWAIT keyword is optional in the FOR UPDATE clause.

Accepted Answer

True

Question 29

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

Accepted Answer

IS

Question 30

DECLARE
TYPE person_dept IS _________
   first_name  employees.first_name%TYPE,  
   last_name   employees.last_name%TYPE,
   department_name departments.department_name%TYPE;
What is missing in the TYPE section?__________

Accepted Answer

IS RECORD

Question 31

In explicit cursor, you need to fetch each row one at a time.

Accepted Answer

True

Question 32

In explicit cursor, you need to open each row one at a time.

Accepted Answer

False

Question 33

The exception section begins with the keyword _______.

Accepted Answer

EXCEPTION

Question 34

Always add ________ whenever there is a possibility of an error occurring.

Accepted Answer

EXCEPTION HANDLERS

Question 35

Error in PL/SQL is known as ____________.

Accepted Answer

EXCEPTION

Question 36

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

Accepted Answer

RAISE

Question 37

What is missing in the given exception syntax? ____ 

EXCEPTION

         WHEN  exception1  [OR  exception2  .  .  .]

                  statement1; statement2;

Accepted Answer

THEN

Question 38

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

Accepted Answer

True

Question 39

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

Accepted Answer

True

Question 40

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

Accepted Answer

True

Question 41

Always add exception handlers whenever there is a possibility of an error occurring.

Accepted Answer

True

Question 42

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

Accepted Answer

False

Question 43

Pragma declaration is used in declaring user-defined exceptions.

Accepted Answer

False

Question 44

Two methods for raising an exception:

Accepted Answer

Implicit, Explicit

Question 45

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

Accepted Answer

PRAGMA EXCEPTION_INIT

Question 46

What is the first parameter of the PRAGMA EXCEPTION_INIT function?

Accepted Answer

EXCEPTION NAME

Question 47

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.

Accepted Answer

True

Question 48

PL/SQL records contain one or more components/fields of any scalar or  composite type.

Accepted Answer

True

Question 49

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

Accepted Answer

True

Question 50

You must include the ________ clause in the cursor query so that the rows are locked on OPEN.

Accepted Answer

FOR UPDATE

Question 51

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

Accepted Answer

False

Question 52

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

Accepted Answer

True

Question 53

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

Accepted Answer

False

Question 54

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

Accepted Answer

True

Question 55

The ______ returns character data containing the message associated with the error number.

Accepted Answer

SQLERRM

Question 56

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

Accepted Answer

HYPEN

Question 57

In non-predefined exception, you must reference the ________ within a WHEN clause in the exception-handling section.

Accepted Answer

Declared exception name

Question 58

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

Accepted Answer

True

Question 59

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

Accepted Answer

False

Question 60

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

Accepted Answer

True

Question 61

The ______ returns character data containing the message associated with the error number.

Accepted Answer

SQLERRM

Question 62

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

Accepted Answer

HYPEN

Question 63

In non-predefined exception, you must reference the ________ within a WHEN clause in the exception-handling section.

Accepted Answer

Declared exception name

"Know" box contains:
Time elapsed:
Retries:

DBSA FA2