Question 1

The ______ are automatically declared variables that allow you to evaluate what happened when a cursor was last used.

Accepted Answer

Cursor Attributes

Question 2

The memory area allocated by Oracle server to store the SQL statement and the data that it uses in known as __________.

Accepted Answer

CURSOR

Question 3

The _______cursor are automatically defined by Oracle.

Accepted Answer

IMPLICIT

Question 4

The use of INTO clause in PL/SQL select statement is to specify the name of ________.

Accepted Answer

VARIABLES

Question 5

The ______ is a Boolean attribute that evaluates to True if the most recent SQL statement returned at least one row.

Accepted Answer

SQL%FOUND

Question 6

Which SQL statements cannot be used directly in PL/SQL?

Accepted Answer

DDL, DCL

Question 7

DECLARE
v_deptno copy_emp.department_id%TYPE := 50; 
BEGIN
DELETE FROM copy_emp
WHERE _____________ = v_deptno;
DBMS_OUTPUT.PUT_LINE(SQL%ROWCOUNT || ' rows deleted.'); 
END;

Accepted Answer

DEPARTMENT_ID

Question 8

What could be the possible error of the given code below?
DECLARE
v_deptno  employees.department_id%TYPE := 10;
BEGIN
DELETE FROM copy_emp
WHERE department_id = v_deptno;
END;

Accepted Answer

No error

Question 9

Which DML statement make changes to the database?

Accepted Answer

ALL THE OPTIONS

Question 10

The code below

Declare
v_cal_increase employees.salary%type := 800;
begin
update copy_emp
set salary = salary + v_sal_increase
where job_id = ‘ST_CLERK’;
dbms_output.put_line(_____________ || ‘ rows updated.’);
End;

Accepted Answer

SQL%ROWCOUNT

Question 11

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

Accepted Answer

True  

pero false daw

Question 12

Refer to M1S2-code reference#3, is the symbol used for the assignment operator correct?

Accepted Answer

True

Question 13

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

Accepted Answer

False

Question 14

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

Accepted Answer

False

Question 15

Refer to M1S2-code reference#2, the missing condition in (2) is vpop = 0.

Accepted Answer

True

Question 16

Refer to M1S2-code reference#1, what is that last missing element?

Accepted Answer

end if;

Question 17

Refer to M1S2-code reference#2, what should be the condition in (3)?

Accepted Answer

vpop >= 1000000000  ***

Question 18

The ______ is the symbol used for the assignment operator.

Accepted Answer

=

Question 19

Refer to M1S2-code reference#3, what is missing in the given CASE structure?

Accepted Answer

Nothing is missing

Question 20

What is missing in the given code?
DECLARE
 	v_myage NUMBER := 31; 
BEGIN
IF v_myage < 11 
DBMS_OUTPUT.PUT_LINE('I am a child'); 
END IF;
END;

Accepted Answer

Not in the option

Question 21

Use the ______ loop when the statement inside the loop must execute at least once.

Accepted Answer

BASIC

Question 22

Refer to M1S3-code reference #4, what is the missing operator in the EXIT section?

Accepted Answer

>

Question 23

Refer to M1S3-code reference#1, what should be the initial value of vctr?

Accepted Answer

51

Question 24

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

Accepted Answer

False

Question 25

The lower and upper bound of a for loop must be a numeric literals.

Accepted Answer

False  ***

Question 26

In BASIC and WHILE loop, the iteration will terminate when the counter is > than the upper bound.

Accepted Answer

False

Question 27

Use a DO..WHILE loop when the statement inside the loop must execute at least once.

Accepted Answer

True

Question 28

In BASIC and WHILE loop, the iteration will terminate when the counter is < than the upper bound.

Accepted Answer

False

Question 29

The _____ is an integer value that represents the number  of rows affected by the most recent SQL  statement.

Accepted Answer

SQL%ROWCOUNT

Question 30

The _________ cursors are defined by the PL/SQL  programmer.

Accepted Answer

EXPLICIT

Question 31

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

Accepted Answer

DCL

Question 32

v_sum_sal NUMBER(10,2);
v_deptno           	
NUMBER NOT NULL := 60; 
BEGIN
SELECT SUM(salary) FROM employees  WHERE department_id = v_deptno;
DBMS_OUTPUT.PUT_LINE('Dep #60 Salary Total: ' || v_sum_sal); 
END;

Accepted Answer

Missing INTO clause

Question 33

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

Accepted Answer

MERGE

Question 34

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 35

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

Accepted Answer

SQL%NOTFOUND

Question 36

What could be the possible error of the given code below?
DECLARE
v_salary employees.salary%TYPE; 
BEGIN
SELECT salary INTO v_salary
FROM employees where employee_id = 100;
DBMS_OUTPUT.PUT_LINE(' Salary is : ' || v_salary); 
END;

Accepted Answer

NO ERROR

Question 37

A counter variable is an expression that returns true, false, or null.

Accepted Answer

False

Question 38

Refer to M1S2-code reference#3, what must be displayed in the dbms_output?

Accepted Answer

VMESG

Question 39

Refer to M1S2-code reference#3, what is missing in the last case selection?

Accepted Answer

> 10000

Question 40

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

Accepted Answer

Condition

Question 41

Refer to M1S2-code reference#2, what is the missing condition in (2)?

Accepted Answer

vpop = 0

Question 42

The _______ is an expression that returns true, false, or null.

Accepted Answer

CONDITION

Question 43

Refer to M1S3-code reference#2, what is missing in the SELECT statement? _________

Accepted Answer

V_LOC_ID

Question 44

In for loop, counter variable is declared _______.

Accepted Answer

IMPLICITLY

Question 45

All counter variables must be declared at the declaration section.

Accepted Answer

False ***

Question 46

Refer to M1S3-code reference#1, the loop body will be performed 5 times.

Accepted Answer

True

Question 47

Refer to M1S3-code reference #4, the ‘>’ is the missing operator in the EXIT section.

Accepted Answer

True ***

Question 48

The BASIC LOOP control structures are statements that enable you to execute statements in a PL/SQL block repeatedly.

Accepted Answer

True

Question 49

The INTO clause occurs between the SELECT and _______ clauses.

Accepted Answer

FROM

Question 50

The DML statement: INSERT, DELETE, ________ make changes to the database.

Accepted Answer

UPDATE

Question 51

The _________ SQL Rule: queries must return only one row.

Accepted Answer

EMBEDDED  OR IMPLICIT***

Question 52

Declare

v_sal_increase employees.salary%type := 800;

begin

update copy_emp

set salary = salary + v_sal_increase

where job_id = ‘ST_CLERK’;

dbms_output.put_line(SQL%FOUND || ‘ rows updated.’);

end;

Accepted Answer

SQL%FOUND

Question 53

. What is missing in the given code below?
DECLARE
v_salary employees.salary%TYPE;
BEGIN
SELECT salary INTO ________
FROM employees where employee_id = 100;
DBMS_O

Accepted Answer

V_SALARY

Question 54

Refer to M1S2-code reference#3, the table name AIRPORT is missing in the creation of the implicit cursor.

Accepted Answer

False

Question 55

Control structures are used to change the logical flow of statements within the PL/SQL block.

Accepted Answer

True

Question 56

The _______ are used to change the logical flow of statements within the PL/SQL block.

Accepted Answer

Control Structures

Question 57

Refer to M1S2-code reference#3, what is missing in the creation of the implicit cursor?

Accepted Answer

Airports  ***

Question 58

What is missing in the given WHILE loop syntax? ________

WHILE condition

statement1; 

statement2;

. . .

END ;

Accepted Answer

LOOP

Question 59

Refer to M1S3-code reference#1, how many time the loop body will be performed? __________

Accepted Answer

5

Question 60

Refer to M1S3-code reference#1, what is missing in the creation of the implicit cursor inside the loop body? _______

Accepted Answer

V_LOC_ID

Question 61

In for loop, counter must be explicitly declared.

Accepted Answer

FALSE (While loop)

Question 62

Refer to M1S3-code reference#2, the VLOC_ID is missing in the SELECT statement?

Accepted Answer

False (V_LOC_ID)

Question 63

The INTO clause occurs between the _______ and FROM clauses.

Accepted Answer

SELECT

Question 64

The ______ is a  Boolean attribute that evaluates to TRUE if the most recent SQL statement did not return  even one row.

Accepted Answer

SQL%NOTFOUND

"Know" box contains:
Time elapsed:
Retries:

DBSA