SECTION 2

1. A
Scalar Mark for Review
data (1) Points
type
holds
a(n)
____
value.

Single (*)
Multi
Large
image

Correct

2. _____ are meant to store large amounts of data.

Mark for Review
(1) Points

VARCHAR2s
LOBs (*)
Scalar data types
Variables

Incorrect. Refer to Section 2 Lesson 3.

3. Which of the following declarations is invalid?

Mark for Review
(1) Points

v_start_date DATE := sysdate+1;

v_count PLS_INTEGER:=0;
v_pages CONSTANT NUMBER; (*)
college_name VARCHAR2(20):='Harvard';

Incorrect. Refer to Section 2 Lesson 4.

4. If you use the %TYPE attribute, you can avoid hard-coding the column name. True
or False? Mark for Review
(1) Points
 True
False (*)

Correct

5. What will be displayed when the following block is executed?

Mark for Review
<< outer >> (1) Points
DECLARE
v_myvar VARCHAR2(10) := 'Hello' ;
BEGIN
<< inner >>
DECLARE
v_myvar VARCHAR2(10) := 'World';
BEGIN
v_myvar := v_myvar || ' ' || outer.v_myvar;
END;
DBMS_OUTPUT.PUT_LINE(inner.v_myvar);
END;

World
HelloWorld
The code will fail since the inner variable is not within the scope of the outer
block. (*)
Hello World

Incorrect. Refer to Section 2 Lesson 6.

6. If an
outer Mark for Review
block is (1) Points
labeled,
the
inner
block
must
be
labeled
also.
True or
False?

True
False (*)

Incorrect. Refer to Section 2 Lesson 6.

7. Assignment statements can continue over several lines in PL/SQL. True or False?
Mark for Review
(1) Points
 True (*)
False

Correct

8. Constants must be initialized. True or False?

Mark for Review
(1) Points

True (*)
False

Correct

9. What good programming practice would make this code easier to follow?
Mark for Review
DECLARE (1) Points
v_myvar VARCHAR2(20);
BEGIN
DECLARE
v_myvar VARCHAR2(15);
BEGIN
...
END;
END;

Developing a case convention for the code

Avoid using column names as identifiers
Using a consistent naming convention for variables
Labeling the blocks (*)

Incorrect. Refer to Section 2 Lesson 7.

10. Which of the following makes PL/SQL code easier to read and maintain?
Mark for Review
(1) Points

Type everything in lowercase.

Use suitable comments in the code. (*)
Place multiple statements on the same line.

Correct
11. Which of
the Mark for Review
following (1) Points
is
correct?

V_FAMILY_NAME = SMITH;
v_family_name := 'SMITH'; (*)
v_family_name := SMITH;
v_family_name = SMITH;

Correct

12. What will happen when the following code is executed?

DECLARE v_new_date DATE; Mark for Review
BEGIN (1) Points
v_new_date := 'Today';
DBMS_OUTPUT.PUT_LINE(v_new_date);
END;

The block will fail because the character value "Today" cannot be implicitly
converted to a date. (*)
The block will execute and display today's date.
The block will execute and display the word "Today".

Correct

13. PL/SQL statements must be written on a single line.

Mark for Review
(1) Points

True
False (*)

Correct

14. Delimiters are _____ that have special meaning to the Oracle database.
Mark for Review
(1) Points

variables
identifiers
symbols (*)

Incorrect. Refer to Section 2 Lesson 2.

 15. Which of the following symbols can be used to enclose a comment in PL/SQL?
Mark for Review
(1) Points

*/ / *
/* */ (*)
??
:: ::

Correct

1. What good
programming Mark for Review
practice would (1) Points
make this code
easier to
follow?

DECLARE
v_myvar
VARCHAR2(20);
BEGIN
DECLARE
v_myvar
VARCHAR2(15);
BEGIN
...
END;
END;

Using a consistent naming convention for variables

Labeling the blocks (*)
Avoid using column names as identifiers
Developing a case convention for the code

Incorrect. Refer to Section 2 Lesson 7.

2. Comments change how a PL/SQL program executes, so an unsuitable

comment can cause the program to fail. True or False? Mark for Review
(1) Points

True
False (*)

Correct
 3. Which of the following is a composite data type?
Mark for Review
(1) Points

CLOB
VARCHAR2
RECORD (*)
DATE

Correct

4. A datatype specifies and restricts the possible data values that can be
assigned to a variable. True or False? Mark for Review
(1) Points

True (*)
False

Correct

5. Which of the following is NOT a good guideline for declaring variables?

Mark for Review
(1) Points

Use column names as identifiers (*)

Use NOT NULL when the variable must have a value
Declare one identifier per line

Correct
6. A
variable Mark for Review
must (1) Points
have a
value if
NOT
NULL is
specified.
True or
False?

True (*)
False

Correct
 7. The LENGTH and ROUND functions can be used in PL/SQL statements. True or
False? Mark for Review
(1) Points

True (*)
False

Correct

8. If today's date is 14th June 2007, which statement will correctly convert today's
date to the value: June 14, 2007 ? Mark for Review
(1) Points

TO_DATE(sysdate,'Month DD, YYYY')

TO_CHAR(sysdate)
TO_DATE(sysdate)
TO_CHAR(sysdate, 'Month DD, YYYY') (*)

Incorrect. Refer to Section 2 Lesson 5.

9. What is the output when the following program is executed?

Mark for Review
set serveroutput on (1) Points
DECLARE
a VARCHAR2(10) := '333';
b VARCHAR2(10) := '444';
c PLS_INTEGER;
d VARCHAR2(10);
BEGIN
c := TO_NUMBER(a) + TO_NUMBER(b);
d := a || b;
DBMS_OUTPUT.PUT_LINE(c);
DBMS_OUTPUT.PUT_LINE(d);
END;

c=777 and d=777

c=777 and d=333444 (*)
c=333444 and d=777
Nothing. The code will result in an error.

Correct

10. Is the following variable declaration correct or not?

Mark for Review
DECLARE (1) Points
test NUMBER(5);
 Correct. (*)
Not correct.

Correct

11. Which of
the Mark for Review
following (1) Points
are
required
when
declaring
a
variable?
(Choose
two.)

(Choose all correct answers)

CONSTANT
Data type (*)
Identifier name (*)
NOT NULL

Correct

12. The name of a variable is an example of an identifier. True or False?

Mark for Review
(1) Points

True (*)
False

Correct

13. Which of the following are valid identifiers? (Choose two.)

Mark for Review
(1) Points

(Choose all correct answers)

yesterday (*)
yesterday's date
number_of_students_in_the_class
#students
 v$testresult (*)

Correct

14. Examine the following code. What is the scope of variable v_myvar?
DECLARE Mark for Review
v_myvar NUMBER; (1) Points
BEGIN
v_myvar := 6;
DECLARE
v_hervar NUMBER;
BEGIN
v_hervar := 4;
END;
END;

Neither block
Only the outer block
Only the inner block
Both the inner and the outer block (*)

Correct

15. For the anonymous block below, what is the correct reference to the father's
date of birth in the inner block? Mark for Review
(1) Points
<< outer>>
DECLARE
v_father_name VARCHAR2(20):='Patrick';
v_date_of_birth DATE:='20-Apr-1972';
BEGIN
DECLARE
v_child_name VARCHAR2(20):='Mike';
v_date_of_birth DATE:='12-Dec-2002';
...

outer.v_date_of_birth (*)
<< outer.v_date_of_birth >>
<< outer>>v_date_of_birth
v_date_of_birth.outer

Correct