FORMATIVE 1

Question 1

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

SQL%FOUND

SQL&NOTFOUND

SQL%ROWCOUNT

Answer 1

SQL%NOTFOUND

Question 2

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

True or False

Answer 2

True

Question 3

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

True or False

Answer 3

True

Question 4

The (SELECT) SQL Rule: queries must retunr only one row.

True or False

Answer 4

True

Question 5

The (EXPLICIT) cursors are defined by the PL/SQL programmer

True or False

Answer 5

True

Question 6

Which DML statement make changes to the database?

DELETE

INSERT

All the options

UPDATE

Answer 6

All of the options

Question 7

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

CURSOR

VARIABLE

TABLE

VIEW

Answer 7

VARIABLE

Question 8

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

Explicit attributes

Attributes

Implicit attributes

Cursor attributes

Answer 8

Cursor Attributes

Question 9

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

SQL%FOUND

SQL%ROWCOUNT

SQL%COUNT

SQL%NOTFOUND

Answer 9

SQL%NOTFOUND

Question 10

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

True or False

Answer 10

True

Question 11

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

True or False

Answer 11

False

Question 12

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

True or False

Answer 12

False

Question 13

Applying the logical operator NOT to a null yields FALSE.

True or False

Answer 13

False

Question 14

Use the (BASIC) loop when the statement inside the loop must execute at least once.

True or False

Answer 14

True

Question 15

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

True or False

Answer 15

True

Question 16

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

True or False

Answer 16

False

Question 17

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

True or False

Answer 17

True

Question 18

The (SQL%ROWCOUNT) is an integer value that represents the number of rows affected by the most recent SQL statement.

True or False

Answer 18

True

Question 19

The INTO clause occurs between the SELECT and (FROM) clauses

True or False

Answer 19

True

Question 20

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

Condition

ELSE

Nested-if

Conditional statement

Answer 20

Condition

Question 21

The _____ is the symbol used for the assignment operator.

=

:=

Answer 21

:=

Question 22

An EXIT statement is used in order to come out of from the outer loop within a inner loop.

True

False

Answer 22

False

Question 23

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

True

False

Answer 23

False

Question 24

The DML statement: INSERT, DELETE, (UPDATE) make changes to the database.

True

False

Answer 24

True

Question 25

The (IMPLICIT) cursor are automatically defined by Oracle. True False

Answer 25

True

Question 26

Which SQL statements cannot be used directly in PL/SQL? DDL, DCL DML DML, TCL TCL

Answer 26

DDL, DCL

Question 27

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; -------- SET section WHERE section Variable declaration No error

Answer 27

Variable declaration

Question 28

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 View Implicit Cursor Explicit Cursor Cursor

Answer 28

Cursor

Question 29

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; ------ DELETE section No error Variable declaration WHERE section

Answer 29

DELETE section

Question 30

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

Answer 30

True

Question 31

A condition is an expression that returns true, false, or null. True False

Answer 31

True

Question 32

A (LOOP LABELS) is used in order to come out of from the outer loop within an inner loop. True False Not Sure

Answer 32

Not Sure

Question 33

The type of loop where the statement inside the loop must execute at least once. (BASIC LOOP) True False

Answer 33

True

Question 34

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

Answer 34

False

Question 35

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

Answer 35

True

Question 36

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

Answer 36

True

Question 37

The (MERGE) statement selects rows from one table to update and/or insert into another table. True False

Answer 37

True

Question 38

The memory area alloacted by Oracle server to the store the SQL statement and the data that i uses in known as (IMPLICIT CURSOR). True False

Answer 38

True

Question 39

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; ---- WHERE section Variable declaration No error SET section

Answer 39

No error

Question 40

The _____ statement selects rows from one table to update and/or insert into another table. SELECT, INSERT, UPDATE MERGE DML COMBINE

Answer 40

MERGE

Question 41

The code below must print the number of rows deleted. What is missing in the given code to satisfy the output? 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; ------- JOB_ID DEPARTMENTS JOBS DEPARTMENT_ID

Answer 41

DEPARTMENT_ID

Question 42

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; ------ Variable declaration No error WHERE section DELETE section

Answer 42

WHERE section

Question 43

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

Answer 43

True

Question 44

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; ------ True False

Answer 44

True

Question 45

All counter variables must be declared at the declaration section. True False

Answer 45

False

Question 46

The (SQL%FOUND) is a Boolean attribute that evaluates to True if the most recent SQL statement returned at least one row True False

Answer 46

True

Question 47

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) FROM employees WHERE department_id = v_deptno; DBMS_OUTPUT.PUT_LINE('Dep #60 Salary Total: ' || v_sum_sal); END; Group of answer choices Group function error Missing INTO clause Query returns more than 1 row Variable error

Answer 47

Missing INTO clause

Question 48

The ______ is an expression that returns true, false, or null. Counter variable CONDITION CASE STATEMENT IF STATEMENT

Answer 48

IF STATEMENT

Question 49

The use of CASE statement to test conditions such as <, >, >=, <= is known as: Search CASE statement Equality CASE statement Conditional CASE Expression Non-equality CASE statement

Answer 49

Searched CASE statement

Question 50

Use a DO.. WHILE loop when the statmeent inside the loop must execute at least once. True False

Answer 50

False

Question 51

The code below must print the number of rows updated, what is the missing part of the code? 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; SQL%ROWCOUNT SQL%FOUND ‘SQL%ROWCOUNT’ ‘SQL%FOUND’

Answer 51

SQL%ROWCOUNT

Question 52

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

Answer 52

Control structures