Question 1

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

Accepted Answer

implicit cursor. 1/1

Question 2

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

Accepted Answer

UPDATE

Question 3

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.');

Accepted Answer

DEPARTMENT_ID

Question 4

The use of INTO clause in PL/SQL select statement is to specify the name of: ____________.
Group of answer choices

TABLE

VARIABLE

CURSOR

VIEW

Accepted Answer

VARIABLE 1/1

Question 5

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_OUTPUT.PUT_LINE(' Salary is : ' || v_salary); 

END;

Accepted Answer

V_SALARY

Question 6

What could be the possible error of the given code below?

DECLARE

v_sal_increase employees.salary%TYPE = 800; 

BEGIN

UPDATE copy_emp

SET salary = salary + v_sal_increase

WHERE job_id = 'ST_CLERK'; 

END;

Accepted Answer

WHERE section (sabi ni gpt no error)

Question 7

What could be the possible error of the given code below?

DECLARE

v_sal_increase employees.salary%TYPE := 800; 

BEGIN

UPDATE copy_emp

SET salary = salary + v_sal_increase

WHERE job_id = 'ST_CLERK'; 

END;

Accepted Answer

no error (kilitiin ko lang si gpt)

Question 8

Refer to M1S2-code reference#3, data type for vmesg variable must be CHAR.
Group of answer choices

True

False

Accepted Answer

false

Question 9

The use of CASE statement to test conditions such as <, >, >=, <= is know as case expression. Group of answer choices True False

Accepted Answer

true

Question 10

Applying the logical operator NOT to a null yields FALSE.
Group of answer choices

True

False

Accepted Answer

false 1/1

Question 11

Refer to M1S2-code reference#2, the missing condition in (2) is vpop = 0.
Group of answer choices

True

False

Accepted Answer

true

Question 12

Refer to M1S2-code reference#3, what is the missing element in the where clause? (UPPER)

 

Group of answer choices

VARIABLE

Nothing is missing

Not in the options

UPPER

Accepted Answer

UPPER

Question 13

Refer to M1S2-code reference#2, what is the missing part of the condition in (1) ?_______
Group of answer choices

TRUE

0

NULL

FALSE

Accepted Answer

NULL

Question 14

The ______ is the symbol used for the assignment operator.
Group of answer choices

=

:=

Accepted Answer

= 1/1

Question 15

You can change the logical flow of statements within the PL/SQL block by using:

 

Group of answer choices

Control structures

Subprograms

Conditional statements

Looping statements

Accepted Answer

CONTROL STRUCTURES 1/1

Question 16

Refer to M1S2-code reference#3, what is missing in the creation of the implicit cursor?

 

Group of answer choices

Airport

Airports

Country_name

Country_code

Accepted Answer

Airports

Question 17

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

Accepted Answer

BASIC LOOP

Question 18

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

Accepted Answer

IN

Question 19

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 20

The BASIC LOOP control structures are statements that enable you to execute statements in a PL/SQL block repeatedly.
Group of answer choices

True

False

Accepted Answer

true

Question 21

All counter variables must be declared at the declaration section. 
Group of answer choices

True

False

Accepted Answer

false

Question 22

Refer to M1S3-code reference #4, the ‘>’ is the missing operator in the EXIT section.
Group of answer choices

True

False

Accepted Answer

true 1/1

Question 23

In BASIC and WHILE loop, the iteration will terminate when the counter is < than the upper bound.
Group of answer choices

True

False

Accepted Answer

false

Question 24

Refer to M1S3-code reference#1, the loop body will be performed 5 times.
Group of answer choices

True

False

Accepted Answer

true

Question 25

The _______cursor are automatically defined by Oracle.

Accepted Answer

IMPLICIT

Question 26

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

Accepted Answer

VARIABLE 1/1

Question 27

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

Accepted Answer

%NOTFOUND

Question 28

The INTO clause occurs between the _______ and FROM clauses.

Accepted Answer

SELECT

Question 29

The _______ statement selects rows from one table to update and/or insert into another table.
Group of answer choices

MERGE

SELECT, INSERT, UPDATE

COMBINE

DML

Accepted Answer

MERGE

Question 30

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 31

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.'); 

Print the number of rows deleted
Print all the deleted records

Accepted Answer

Print the number of rows deleted

Question 32

The memory area allocated by Oracle server to store the SQL statement and the data that it uses in known as:
Group of answer choices

Explicit Cursor

View

Implicit Cursor

Cursor

Accepted Answer

CURSOR

Question 33

Consider the given code fragment below. The condition will return a true value.      

A:=null; B:=null;

If A = B then . . . . .

Group of answer choices

True

False

Accepted Answer

FALSE

Question 34

A condition is an expression that returns true, false, or null.
Group of answer choices

True

False

Accepted Answer

TRUE

Question 35

Is there something 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;

Group of answer choices

True

False

Accepted Answer

TRUE

Question 36

Refer to M1S2-code reference#2, what is the missing condition in (2)?

 

Group of answer choices

vpop >= 0

vpop <= 0

vpop < 0

vpop = 0

Accepted Answer

VPOP = 0

Question 37

Refer to M1S2-code reference#3, what is the correct data type for vmesg?

Accepted Answer

VARCHAR

Question 38

The _______ are used to change the logical flow of statements within the PL/SQL block.
Group of answer choices

CASE statement

Control Structures

Conditional statement

Looping statement

Accepted Answer

CONTROL STRUCTURES

Question 39

Refer to M1S3-code reference#1, what type of looping is used in the code? ________

Accepted Answer

SIMPLE LOOP

Question 40

In for loop, counter variable is declared _______.

Accepted Answer

IMPLICITLY

Question 41

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

Accepted Answer

VCTR

Question 42

In for loop, counter must be explicitly declared.
Group of answer choices

True

False

Accepted Answer

FALSE

Question 43

An EXIT statement is used in order to come out of from the outer loop within an inner loop.
Group of answer choices

True

False

Accepted Answer

TRUE

Question 44

In BASIC and WHILE loop, the iteration will terminate when the counter value meets the upper bound value.
Group of answer choices

True

False

Accepted Answer

FALSE

"Know" box contains:
Time elapsed:
Retries: