Question 1

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

RECORD

Question 2

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

Accepted Answer

COMPOSITE

Question 3

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

Accepted Answer

TRUE

Question 4

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 5

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

Accepted Answer

OTHERS

Question 6

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

Accepted Answer

TRAPPING

Question 7

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

Accepted Answer

OTHERS

Question 8

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

Accepted Answer

EXCEPTION HANDLERS

Question 9

he RAISE keyword is used by non-predefined exception.

Accepted Answer

False

Question 10

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

Accepted Answer

TRUE

Question 11

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 12

Exception section is mandatory in PL/SQL block.

Accepted Answer

FALSE

Question 13

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 14

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

Accepted Answer

TRUE

Question 15

Pragma declaration is used in declaring non-predefined exceptions.

Accepted Answer

TRUE

Question 16

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

Accepted Answer

FALSE

Question 17

Pragma declaration is used in declaring user-defined exceptions.

Accepted Answer

FALSE

Question 18

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

Accepted Answer

TRUE

Question 19

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

Accepted Answer

PREDEFINED

Question 20

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

Accepted Answer

SQLERRM

Question 21

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

Accepted Answer

Exception name declaration

Question 22

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 23

The ________ clause is used in user-defined exception to tell the compiler to associate an exception name with a specific Oracle error

Accepted Answer

PRAGMA EXCEPTION_INIT

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.

Accepted Answer

True

Question 25

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

Accepted Answer

TRUE

Question 26

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

Accepted Answer

False

Question 27

Given the code below, assume that the cursor contains 20 rows. How many rows will be fetched from the cursor?

4

6

5

0

Accepted Answer

6

Question 28

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

Accepted Answer

NOWAIT

Question 29

The block below will display the country name and the area of each country in a chosen region. The region_id should be passed to the cursor as a parameter. Test the block using region 5 (South America). What is missing in line#6?

Accepted Answer

5

Question 30

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

Accepted Answer

FALSE

Question	Answer
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?__________	RECORD
PL/SQL record is a _____ data type, you can refer to the whole record by its name and/or to individual fields by their names.	COMPOSITE
In explicit cursor, you need to fetch each row one at a time.	TRUE
When an exception is raised, control immediately shifts to the _______ and the appropriate handler in the exception section is executed.	EXCEPTION SECTION
The _______ is an optional exception-handling clause that traps any exceptions that have not been explicitly handled.	OTHERS
The term ________ in exceptions is the same as handling any error by including corresponding exception handler.	TRAPPING
Handle named exceptions whenever possible, instead of using ______ in exception handlers.	OTHERS
Always add ________ whenever there is a possibility of an error occurring.	EXCEPTION HANDLERS
he RAISE keyword is used by non-predefined exception.	False
Each exception handler is consists of a WHEN clause, which specifies an exception name.	TRUE
The term TRAP in exceptions is the same as handling any error by including corresponding exception handler. Group of answer choices True False	TRUE
Exception section is mandatory in PL/SQL block.	FALSE
An exception occurs when an error is discovered during the execution of a program that disrupts the normal operation of the program.	TRUE
The RAISE statement can be used to raise either user-defined or non-predefined exception.	TRUE
Pragma declaration is used in declaring non-predefined exceptions.	TRUE
Names for predefined exceptions must be declared in the declaration section.	FALSE
Pragma declaration is used in declaring user-defined exceptions.	FALSE
There are 2 parameters needed in the pragma declaration of an exception.	TRUE
The RAISE statement can be used to raise either user-defined or ________ exception.	PREDEFINED
The ______ returns character data containing the message associated with the error number.	SQLERRM
What is the first step in handing non-predefined exception?	Exception name declaration
The _______________ is used in non-predefined exception to tell the compiler to associate an exception name with a specific Oracle error	PRAGMA EXCEPTION_INIT
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
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
Types and records are composite structures that can be declared anywhere that scalar variables can be declared.	TRUE
The %ROWTYPE can be used to declare a record based on another record.	False
Given the code below, assume that the cursor contains 20 rows. How many rows will be fetched from the cursor? 4 6 5 0	6
If you omit the ______ keyword, then the Oracle server waits indefinitely until the rows are available.	NOWAIT
The block below will display the country name and the area of each country in a chosen region. The region_id should be passed to the cursor as a parameter. Test the block using region 5 (South America). What is missing in line#6?	5
You must include the FOR UPDATE clause in the cursor query so that the rows are unlocked on OPEN.	FALSE

"Know" box contains:
Time elapsed:
Retries:

Data endmin F-1