Recognizing Data Types

1) A datatype specifies and restricts the possible data values that can be assigned to a variable. True or False?
*true

2) A datatype may specify a valid range of values. True or False?
 *true

3) Which of the following are PL/SQL data types? (Choose three.)
*Scalar
*Large Objects (LOB)
*Composite

4)Which of the following are scalar data types? (Choose three.)
*Date
*Boolean
*Character

5) A Scalar data type holds a ____ value.
*single

6) What are the data types of the variables in the following declaration?

DECLARE
fname VARCHAR2(20);
fname VARCHAR2(15) DEFAULT 'fernandez';
BEGIN
* Scalar

7) Which of the following is a composite data type?
*RECORD

Comments

Post a Comment