Question 1

If the answer has ! at the end it means its guaranteed or the right answer

Ex: 1+1

Accepted Answer

2 !!

##Don't include the ! when reviewing/answering

Question 2

What is missing in the declaration section if we want to declare v_emp_record as type record of EMPLOYEES table?

Accepted Answer

EMPLOYEES%ROWTYPE

Question 3

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

Accepted Answer

False

Question 4

ROWTYPE is missing in line#11.

Accepted Answer

False

Question 5

The ___________ contains the exceptions handlers.

Accepted Answer

EXCEPTION SECTION

Question 6

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

Accepted Answer

EXCEPTION HANDLERS !!

Question 7

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

Accepted Answer

RAISE !!

Question 8

Code that defines the recovery actions to be performed when execution-time errors occur.

Accepted Answer

EXCEPTION

Question 9

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

Accepted Answer

THEN !

Question 10

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

Accepted Answer

True

Question 11

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

Accepted Answer

True

Question 12

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

Accepted Answer

True

Question 13

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 14

Exception section is mandatory in PL/SQL block.

Accepted Answer

False !

Question 15

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

Accepted Answer

True !

Question 16

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

Accepted Answer

True

Question 17

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

Accepted Answer

False !

Question 18

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

Accepted Answer

True !

Question 19

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

Accepted Answer

False

Question 20

The NO_DATA_FOUND is an example of:

Accepted Answer

Predefined exception !

Question 21

The NO_DATA_FOUND is a _______ exception.

Accepted Answer

PREDEFINED !

Question 22

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

Accepted Answer

WHEN !

Question 23

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

Accepted Answer

USER-DEFINED

Question 24

In trapping a user-defined exception, these steps must be followed: DECLARE -> RAISE -> __________.

Accepted Answer

Exception Handling

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 ( ) symbol is used to enclose the elements of the TYPE structure.

Accepted Answer

True !!

Question 27

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

Accepted Answer

True

Question 28

Given the code below:

DECLARE

     CURSOR cur_emps

                    SELECT employee_id, last_name  FROM employees;

BEGIN

    FOR  cur_emps IN v_emp_record LOOP 

    EXIT WHEN cur_emps%ROWCOUNT > 5;
    
Line 5 is valid or invalid?

Accepted Answer

Invalid

Question 29

Which line# will cause an error to the given code?

Accepted Answer

10 = FETCH cur_emps INTO v_empno, v_lname;

Question 30

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

Accepted Answer

5

Question 31

The __________ clause is used in conjunction  with the FOR UPDATE clause to refer to the most recently fetched row in an explicit cursor.

Accepted Answer

WHERE CURRENT OF

Question 32

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

Accepted Answer

NOWAIT !

Question 33

What is missing in line#9? ______

line #9 EXIT WHEN ___________%NOTFOUND;

Accepted Answer

COUNTRY_CURS

Question 34

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

Accepted Answer

True

Question 35

The NOWAIT keyword is optional in the FOR UPDATE clause.

Accepted Answer

True !

Question 36

TYPE and ________ are composite structures.

Accepted Answer

RECORD

Question 37

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

Accepted Answer

True

Question 38

Line #8 contains an error.

#8 OPEN cur_emps;

Accepted Answer

False

Question 39

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

Accepted Answer

EXCEPTION HANDLER

Question 40

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

Accepted Answer

OTHERS

Question 41

Error in PL/SQL is known as ____________.

Accepted Answer

EXCEPTION !

Question 42

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

Accepted Answer

False !!

Question 43

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

Accepted Answer

True !

Question 44

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

Accepted Answer

False !

Question 45

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

Accepted Answer

False

Question 46

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

Accepted Answer

False !

Question 47

The RAISE_APPLICATION_ERROR can be used in executable and exception section.

Accepted Answer

True

Question 48

Pragma declaration is used in declaring non-predefined exceptions.

Accepted Answer

True

Question 49

Pragma declaration is used in declaring user-defined exceptions.

Accepted Answer

False !!

Question 50

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 51

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

Accepted Answer

PREDEFINED !

Question 52

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

Accepted Answer

RAISE_APPLICATION_ERROR

Question 53

Given the code below, EMPLOYEES%ROWTYPE is missing in the declaration section to declare v_emp_record as type record of EMPLOYEES table.

DECLARE

               v_emp_record    _______________;

Accepted Answer

True !

Question 54

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

Accepted Answer

True

Question 55

Given the code below:

DECLARE

     CURSOR cur_emps

                    SELECT employee_id, last_name  FROM employees;

BEGIN

    FOR  cur_emps IN v_emp_record LOOP 

What will cause an error in the FOR section?

Accepted Answer

cur_emps IN v_emp_record !

Question 56

The given code below declares an explicit cursor. What will cause an error in the code?

DECLARE

CURSOR cur_depts

SELECT * FROM departments  WHERE location_id = 1700 

ORDER BY department_name;

Accepted Answer

IS

Question 57

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.

What is missing in line#4?

Accepted Answer

COUNTRY_CURS

Question 58

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

Accepted Answer

ROWS

Question 59

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

Accepted Answer

False

Question 60

The NOWAIT keyword is mandatory in the FOR UPDATE clause.

Accepted Answer

False

Question 61

Given the code below:

            v_emp_record employees%rowtype; 

DBMS_OUTPUT.PUT_LINE('Email for ' || _____________.first_name ||

' ' || ____________.last_name);

END;

What is missing in the DBMS_OUTPUT section?

Accepted Answer

V_EMP_RECORD

Question 62

Given the declaration below:

TYPE person_dept IS _________

   first_name  employees.first_name%TYPE,  

   last_name   employees.last_name%TYPE,

What is missing in the TYPE section?__________

Accepted Answer

RECORD !

Question 63

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

Accepted Answer

True

Question 64

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

Accepted Answer

True !

&Z5w6!9qc;XZXo-a

)xd2)nq]QpFe[NO/

Question	Answer
If the answer has ! at the end it means its guaranteed or the right answer Ex: 1+1	2 !! ##Don't include the ! when reviewing/answering
What is missing in the declaration section if we want to declare v_emp_record as type record of EMPLOYEES table?	EMPLOYEES%ROWTYPE
The FETCH statement positions the cursor pointer at the first row.	False
ROWTYPE is missing in line#11.	False
The ___________ contains the exceptions handlers.	EXCEPTION SECTION
Always add ________ whenever there is a possibility of an error occurring.	EXCEPTION HANDLERS !!
The __________ keyword is used in user-defined exception for error notification.	RAISE !!
Code that defines the recovery actions to be performed when execution-time errors occur.	EXCEPTION
What is missing in the given exception syntax? ____ EXCEPTION WHEN exception1 [OR exception2 . . .] statement1; statement2;	THEN !
The term TRAP in exceptions is the same as handling any error by including corresponding exception handler.	True
The RAISE keyword is used in user-defined exception for error notification.	True
Always add exception handlers whenever there is a possibility of an error occurring.	True
When an exception is raised, control immediately shifts to the exception section and the appropriate handler in the exception section is executed.	True !
Exception section is mandatory in PL/SQL block.	False !
Non-predefined exceptions has a standard Oracle error number (ORA-#####) and error message, but not a predefined name.	True !
The SQLCODE function returns the numeric value for the error code.	True
The RAISE statement can be used to raise either user-defined or predefined exception.	False !
The RAISE statement can be used to raise either user-defined or non-predefined exception.	True !
Names for predefined exceptions must be declared in the declaration section.	False
The NO_DATA_FOUND is an example of:	Predefined exception !
The NO_DATA_FOUND is a _______ exception.	PREDEFINED !
Each exception handler is consists of a _____ clause, which specifies an exception name.	WHEN !
The RAISE statement can be used to raise either ________ or predefined exception.	USER-DEFINED
In trapping a user-defined exception, these steps must be followed: DECLARE -> RAISE -> __________.	Exception Handling
The given syntax in declaring a user-define record is incorrect. TYPE type_name IS RECORD (field_declaration[,field_declaration]...); identifier type_name ;	False
The ( ) symbol is used to enclose the elements of the TYPE structure.	True !!
The %ROWTYPE cannot be used to declare a record based on another record.	True
Given the code below: DECLARE CURSOR cur_emps SELECT employee_id, last_name FROM employees; BEGIN FOR cur_emps IN v_emp_record LOOP EXIT WHEN cur_emps%ROWCOUNT > 5; Line 5 is valid or invalid?	Invalid
Which line# will cause an error to the given code?	10 = FETCH cur_emps INTO v_empno, v_lname;
Given the code below, assume that the cursor contains 20 rows. How many rows will be fetched from the cursor?	5
The __________ clause is used in conjunction with the FOR UPDATE clause to refer to the most recently fetched row in an explicit cursor.	WHERE CURRENT OF
If you omit the ______ keyword, then the Oracle server waits indefinitely until the rows are available.	NOWAIT !
What is missing in line#9? ______ line #9 EXIT WHEN ___________%NOTFOUND;	COUNTRY_CURS
You must include the FOR UPDATE clause in the cursor query so that the rows are locked on OPEN.	True
The NOWAIT keyword is optional in the FOR UPDATE clause.	True !
TYPE and ________ are composite structures.	RECORD
Use the %ISOPEN cursor attribute before performing a fetch to test whether the cursor is open.	True
Line #8 contains an error. #8 OPEN cur_emps;	False
Each ________ is consists of a WHEN clause, which specifies an exception name.	EXCEPTION HANDLER
Handle named exceptions whenever possible, instead of using ______ in exception handlers.	OTHERS
Error in PL/SQL is known as ____________.	EXCEPTION !
The EXECUTE keyword is used in user-defined exception for error notification.	False !!
Exception handlers are code that defines the recovery actions to be performed when execution-time errors occur.	True !
In exception section, the WHEN clause if followed by a condition.	False !
A block always terminates when PL/SQL raises an exception.	False
The PRAGMA clause is used in predefined exception to tell the compiler to associate an exception name with a specific Oracle error number.	False !
The RAISE_APPLICATION_ERROR can be used in executable and exception section.	True
Pragma declaration is used in declaring non-predefined exceptions.	True
Pragma declaration is used in declaring user-defined exceptions.	False !!
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
The RAISE statement can be used to raise either user-defined or ________ exception.	PREDEFINED !
You can use the ________________ procedure to return user-defined error messages from stored subprograms.	RAISE_APPLICATION_ERROR
Given the code below, EMPLOYEES%ROWTYPE is missing in the declaration section to declare v_emp_record as type record of EMPLOYEES table. DECLARE v_emp_record _______________;	True !
The type and the record declared in the outer block are visible within the outer block and the inner block.	True
Given the code below: DECLARE CURSOR cur_emps SELECT employee_id, last_name FROM employees; BEGIN FOR cur_emps IN v_emp_record LOOP What will cause an error in the FOR section?	cur_emps IN v_emp_record !
The given code below declares an explicit cursor. What will cause an error in the code? DECLARE CURSOR cur_depts SELECT * FROM departments WHERE location_id = 1700 ORDER BY department_name;	IS
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. What is missing in line#4?	COUNTRY_CURS
If you omit the NOWAIT keyword, then the Oracle server waits indefinitely until the _____ are available.	ROWS
When we declare a cursor FOR UPDATE, each row is locked as we open the cursor and prevent other users from reading the rows.	False
The NOWAIT keyword is mandatory in the FOR UPDATE clause.	False
Given the code below: v_emp_record employees%rowtype; DBMS_OUTPUT.PUT_LINE('Email for ' \|\| _____________.first_name \|\| ' ' \|\| ____________.last_name); END; What is missing in the DBMS_OUTPUT section?	V_EMP_RECORD
Given the declaration below: TYPE person_dept IS _________ first_name employees.first_name%TYPE, last_name employees.last_name%TYPE, What is missing in the TYPE section?__________	RECORD !
Use the ISOPEN cursor attribute before performing a fetch to test whether the cursor is open.	True
In explicit cursor, you need to fetch each row one at a time.	True !
The OTHERS is an optional exception-handling clause that traps any exceptions that have not been explicitly handled.	True
Each exception handler is consists of a WHEN clause, which specifies an exception name.	True
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	False
User-defined exceptions are declared within the declarative section and are raised explicitly.	True
Non-predefined errors are raised explicitly.	False
There are 2 parameters needed in the pragma declaration of an exception.	True
The ___________ and ___________ are the two types of Oracle Server Errors.	Predefined, Non-predefined !
PL/SQL records contain one or more components/fields of any _______ or composite type.	SCALAR !!
What are/is the type of exception can be raised using the RAISE statement?	Pre-defined, User-defined
In trapping a user-defined exception, these steps must be followed: DECLARE -> RAISE -> __________.	Not in the options
The declared non-predefined exception is raised ____________.	IMPLICITLY
The %ROWTYPE can be used to declare a record based on another record.	True
Given the code below, EMPLOYEES table must be specified at the DBMS_OUTPUT section. v_emp_record employees2%rowtype; DBMS_OUTPUT.PUT_LINE('Email for ' \|\| _____________.first_name \|\| ' ' \|\| ____________.last_name); END;	False
Given the code below: #8 OPEN ____; What is missing in line 8?	Cur_emps
Given the code below: #11 EXIT WHEN cur_emps%_______; What is missing in line#11?	NOTFOUND
You must include the FOR UPDATE clause in the cursor query so that the rows are locked on _____.	OPEN
Given the code below: #7 FOR country_rec(5,2000000) in country _curs LOOP What is the counter variable?	COUNTRY_REC
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. How many parameter is needed to be passed from the calling environment? _____	1
Refer to the code below. The missing element in line 9 is COUNTRY_REC. #9 EXIT WHEN ___________ %NOTFOUND;	False
Refer to the code below. The missing element in line 9 is COUNTRY_CURS. #9 EXIT WHEN ___________ %NOTFOUND;	True !

"Know" box contains:
Time elapsed:
Retries: