Question 1

The ______ clause is used in DML statement to specify variable(s) that will hold the value(s) that SQL returns from the SELECT clause.

Accepted Answer

INTO

Question 2

The DDL and _______ SQL statements cannot be used directly in PL/SQL.

Accepted Answer

DCL

Question 3

The _____ statement selects rows from one table to update and/or insert into another table.

Accepted Answer

MERGE

Question 4

The INTO clause occurs between the SELECT and _______ clauses.

Accepted Answer

FROM

Question 5

The _______cursor are automatically defined by Oracle.

Accepted Answer

IMPLICIT

Question 6

Boolean attribute that evaluates to TRUE if the most recent SQL statement did not return even one row. A.

Accepted Answer

SQL%NOTFOUND

Question 7

What is the output of the given code below?
DECLARE
v_deptno copy_emp.department_id%TYPE := 50; 
BEGIN
DELETE FROM copy_emp
WHERE department_id = v_deptno;
DBMS_OUTPUT.PUT_LINE(SQL%ROWCOUNT || ' rows deleted.'); 
END;

Accepted Answer

Print the number of rows deleted

Question 8

What could be the possible error of the given code below?
DECLARE
v_sum_sal NUMBER(10,2);
v_deptno           	NUMBER NOT NULL := 60; 
BEGIN
SELECT SUM(salary)
INTO v_sum_sal FROM employees  WHERE department_id = v_deptno;
DBMS_OUTPUT.PUT_LINE('Dep

Accepted Answer

No error

Question 9

Applying the logical operator NOT to a null yields NULL.

Accepted Answer

True

Question 10

Refer to M1S2-code reference#3, data type for vmesg variable must be CHAR.

Accepted Answer

False

Question 11

The use of CASE statement to test conditions such as <, >, >=, <= is know as case expression.

Accepted Answer

False

Question 12

Consider the given code fragment below. The condition will return a false value. 
  	A:=null; B:=null;
If A = B then . . . . .

Accepted Answer

True

Question 13

A _______ is an expression with a TRUE or FALSE value that is used to make a decision.

Accepted Answer

Condition

Question 14

The use of CASE statement to test conditions such as <, >, >=, <= is know as:

Accepted Answer

Searched CASE statement

Question 15

The type of loop where the statement inside the loop must execute at least once.

Accepted Answer

BASIC LOOP

Question 16

All counter variables must be declared at the declaration section.

Accepted Answer

False

Question 17

In BASIC and WHILE loop, the iteration will terminate when the counter value meets the upper bound value.

Accepted Answer

False

Question 18

Without the EXIT statement, the loop would never end  (an infinite loop).

Accepted Answer

True

Question 19

In BASIC and WHILE loop, initialization of counter variable is necessary.

Accepted Answer

True

Question 20

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

Accepted Answer

FALSE

Question 21

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

Accepted Answer

TRUE

Question 22

The RAISE_APPLICATION_ERROR can be used in executable and exception section.

Accepted Answer

TRUE

Question 23

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

Accepted Answer

FALSE

Question 24

Pragma declaration is used in declaring user-defined exceptions.

Accepted Answer

FALSE

Question 25

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

Accepted Answer

HYPEN

Question 26

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

Accepted Answer

SQLERRM

Question 27

Two methods for raising an exception:

Accepted Answer

Implicit, Explicit

Question 28

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 29

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 30

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

Accepted Answer

True

Question 31

What step is missing in the given code?
DECLARE
 	CURSOR cur_emps
                	SELECT employee_id, last_name  FROM employees;
BEGIN
	FOR v_emp_record IN cur_emps LOOP 
	EXIT WHEN cur_emps%ROWCOUNT > 5;
	DBMS_OUTPUT.PUT_LINE(v_emp_record.employe

Accepted Answer

Nothing is missing

Question 32

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 33

The NOWAIT keyword is mandatory in the FOR UPDATE clause.

Accepted Answer

FALSE

Question 34

What symbol is used to enclose the elements of the TYPE structure?

Accepted Answer

()

Question 35

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

Accepted Answer

FALSE

Question 36

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

Accepted Answer

TRUE

Question 37

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

Accepted Answer

FALSE

Question 38

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

Accepted Answer

Exception name declaration

Question 39

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

Accepted Answer

WHEN

Question 40

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

Accepted Answer

True

"Know" box contains:
Time elapsed:
Retries: