Question 1

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

Accepted Answer

%ROWTYPE

Question 2

TYPE and RECORDS are ____ structures.

Accepted Answer

COMPOSITE

Question 3

The OPEN statement positions the cursor pointer at the first row

Accepted Answer

TRUE

Question 4

Given the code below:  4.1

Accepted Answer

TRUE

Question 5

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

Accepted Answer

OTHERS

Question 6

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

Accepted Answer

WHEN

Question 7

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

Accepted Answer

EXCEPTION HANDLER

Question 8

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 9

In exception section, the WHEN clause if followed by ____

Accepted Answer

EXCEPTION NAME

Question 10

The RAISE keyword is used by non-predefined exception.

Accepted Answer

FALSE

Question 11

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 statement

Accepted Answer

TRUE

Question 12

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

Accepted Answer

FALSE

Question 13

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

Accepted Answer

TRUE

Question 14

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

Accepted Answer

TRUE

Question 15

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

Accepted Answer

TRUE

Question 16

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

Accepted Answer

FALSE

Question 17

Pragma declaration is used in declaring user-defined exceptions.

Accepted Answer

FALSE

Question 18

Pragma declaration is used in declaring non-predefined exceptions.

Accepted Answer

TRUE

Question 19

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 20

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

Accepted Answer

PREDEFINED

Question 21

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

Accepted Answer

REFERENCE

Question 22

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 23

The NO_DATA_FOUND is a __ exception.

Accepted Answer

PREDEFINED

Question 24

The NO_DATA_FOUND is an example of

Accepted Answer

PREDEFINED EXCEPTION

Question 25

A user-defined PL/SQL record contains one or more fields of scalar data type.

Accepted Answer

FALSE

Question 26

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

Accepted Answer

FALSE

Question 27

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

Accepted Answer

TRUE

Question 28

Given the code below:  28 .1

Accepted Answer

CUR_EMPS

Question 29

Given the code below: 29 .1

Accepted Answer

V_EMP_RECORD

Question 30

Given the code below: 30.1

Accepted Answer

CUR_EMPS IN V_EMP_RECORD

Question 31

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. The block is tested using region 5(South America)

Accepted Answer

COUNTRY_REC

Question 32

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

Accepted Answer

ROWS

Question 33

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. The block (South America).(How many parameter is needed to be passed from the calling environment?)

Accepted Answer

1

Question 34

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 35

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

Accepted Answer

TRUE

Question 36

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 37

Given:
DECLARE                       v_emp_record   _______________;
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 38

Given the code below: 3.2

Accepted Answer

FALSE

Question 39

Give the code bellow 4.2

Accepted Answer

TRUE

Question 40

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

Accepted Answer

OTHERS

Question 41

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

Accepted Answer

THEN

Question 42

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

Accepted Answer

WHEN

Question 43

In exception section, the WHEN clause if followed by _______.

Accepted Answer

EXCEPTION NAME

Question 44

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

Accepted Answer

HANDLER

Question 45

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 statement

Accepted Answer

TRUE

Question 46

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 47

The RAISE keyword is used by non-predefined exception.

Accepted Answer

FALSE

Question 48

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

Accepted Answer

FALSE

Question 49

Exception section is mandatory in PL/SQL block.

Accepted Answer

FALSE

Question 50

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

Accepted Answer

TRUE

Question 51

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

Accepted Answer

TRUE

Question 52

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

Accepted Answer

TRUE

Question 53

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

Accepted Answer

TRUE

Question 54

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 55

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

Accepted Answer

USER DEFINED

Question 56

The NO_DATA_FOUND is an example of:

Accepted Answer

Predefined exception

Question 57

The ___________ and ___________ are the two types of Oracle Server Errors.

Accepted Answer

Predefined, Non-predefined

Question 58

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

Accepted Answer

RAISE…

Question 59

Given the code below, EMPLOYEES table must be specified at the DBMS_OUTPUT section. DECLARE       v_emp_record employees2%rowtype; BEGIN SELECT * INTO v_emp_record FROM employees2 WHERE  employee_id = 100; DBMS_OUTPUT.PUT_LINE('Email for ' || ____________

Accepted Answer

FALSE

Question 60

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

Accepted Answer

FALSE

Question 61

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 62

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

Accepted Answer

ACTIVE SET

Question 63

What will cause an error in the FOR section?

Accepted Answer

cur_emps IN v_emp_record

Question 64

Given the code below: 28.2

Accepted Answer

What is missing in line 2 and 3? IS

DBS idk FA2

baka mali to

"Know" box contains:
Time elapsed:
Retries: