Question 1

A ________ allows us to declare a variable as a record based on a particular table’s structure.

Accepted Answer

%ROWTYPE

Question 2

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

Accepted Answer

SCALAR

Question 3

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

Accepted Answer

TRUE

Question 4

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

Accepted Answer

RAISE

Question 5

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

Accepted Answer

EXCEPTION SECTION

Question 6

The exception section begins with the keyword _______.

Accepted Answer

EXCEPTION

Question 7

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

Accepted Answer

EXCEPTION HANDLING?????????

Question 8

Each exception handler is consists of a WHEN clause, which specifies an  exception name.
Group of answer choices

True

False

Accepted Answer

TRUE

Question 9

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

Accepted Answer

TRUE

Question 10

In exception section, the WHEN clause if followed by a condition.
Group of answer choices

True

False

Accepted Answer

FALSE

Question 11

Always add exception handlers whenever there is a possibility of an error occurring.
Group of answer choices

True

False

Accepted Answer

TRUE

Question 12

The term TRAP in exceptions is the same as handling any error by including corresponding exception handler.
Group of answer choices

True

False

Accepted Answer

TRUE

Question 13

Names for predefined exceptions must be declared in the declaration section.
Group of answer choices

True

False

Accepted Answer

FALSE

Question 14

User-defined exceptions are declared within the declarative section and are raised explicitly.
Group of answer choices

True

False

Accepted Answer

TRUE

Question 15

You can use the RAISE_APPLICATION_ERROR procedure to return user-defined error messages from stored subprograms.
Group of answer choices

True

False

Accepted Answer

TRUE

Question 16

The RAISE_APPLICATION_ERROR can be used in:

 

Group of answer choices

Exception section

Declaration and Exception section

Executable section

Executable and Exception section

Accepted Answer

Executable and Exception section

Question 17

What is the first parameter of the PRAGMA EXCEPTION_INIT function?

 

Group of answer choices

Oracle error number

EXCEPTION NAME

Accepted Answer

EXCEPTION NAME

Question 18

The ________ clause is used in non-predefined exception to tell the compiler to associate an exception name with a specific Oracle error

 

Group of answer choices

SQLERRM

RAISE_APPLICATION_ERROR

SQLCODE

PRAGMA EXCEPTION_INIT

Accepted Answer

PRAGMA EXCEPTION_INIT

Question 19

Each exception handler is consists of a _____ clause, which specifies an exception name.

 

Group of answer choices

IF

CONDITION

WHEN

Not in the options

Accepted Answer

WHEN

Question 20

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

Accepted Answer

Predefined, Non-predefined

Question 21

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

Accepted Answer

True

Question 22

TYPE and Records are composite structures.
Group of answer choices

True

False

Accepted Answer

TRUE

Question 23

The %ROWTYPE can be used to declare a record based on another record.
Group of answer choices

True

False

Accepted Answer

FALSE

Question 24

FOR  cur_emps IN v_emp_record LOOP 

    EXIT WHEN cur_emps%ROWCOUNT > 5;

    DBMS_OUTPUT.PUT_LINE(v_emp_record.employee_id || ' ' || v_emp_record.last_name);

END LOOP;
END;


Counter declaration

cur_emps IN v_emp_record

Accepted Answer

cur_emps IN v_emp_record

Question 25

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

Accepted Answer

NOWAIT

"Know" box contains:
Time elapsed:
Retries: