Question 1

When placing data into a table of records variable, you must indicate the field that will hold the value but you need not indicate the row.

Accepted Answer

A) True 
 B)False  False

Question 2

A(n) table of records can handle more than one row of data. _________________________

Accepted Answer

A) True 
 B)False  True

Question 3

Declaring a composite variable is different from declaring a scalar variable in that you must create your own data types.

Accepted Answer

A) True 
 B)False  True

Question 4

A(n) composite data type is one that can store and handle multiple values of different data types as one unit. _________________________

Accepted Answer

A) True 
 B)False

Question 5

A collection is a data type that can store multiple values of different data types as one unit.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following statements about collections is NOT True?

Accepted Answer

A)  Collections are similar to arrays. 
B)  An index allows references to individual values or rows within a collection. 
C)  A collection may hold many rows of data and many fields. 
D)  The values in each row of the collection must be of the same type. 
A)  Collections are similar to arrays. 
B)  An index allows references to individual values or rows within a collection. 
C)  A collection may hold many rows of data and many fields. 
D)  The values in each row of the collection must be of the same type.

Question 7

Declaring an associative array data type is quite similar to declaring a(n) table of records data type. _________________________

Accepted Answer

A) True 
 B)False

Question 8

A disadvantage of using the %TYPE attribute is that there is a slight performance hit in that the database server must look up the data type from the data dictionary.

Accepted Answer

A) True 
 B)False

Question 9

The ____________________ clause follows the SELECT clause and indicates which variables are to hold the values that are retrieved from the database.

Accepted Answer

The answer of The ____________________ clause follows the SELECT clause...

Question 10

One major advantage of using ____ as part of the physical database is being able to retrieve multiple values with a query of a single column.

Accepted Answer

A)  cursors 
B)  collections 
C)  index by tables 
D)  variables 
A)  cursors 
B)  collections 
C)  index by tables 
D)  variables

Question 11

The ____________________ attribute tells the system to look up the data type of a database column and use this data type for the declared variable.

Accepted Answer

The answer of The ____________________ attribute tells the system to...

Question 12

Which of the following allows a table of records value to persist for a user session?

Accepted Answer

A)  Declaring the table of records variable in a row specification. 
B)  Declaring the table of records variable in a cursor specification. 
C)  Declaring the table of records variable in a record specification. 
D)  Declaring the table of records variable in a package specification. 
A)  Declaring the table of records variable in a row specification. 
B)  Declaring the table of records variable in a cursor specification. 
C)  Declaring the table of records variable in a record specification. 
D)  Declaring the table of records variable in a package specification.

Question 13

Anchored data types are similar to arrays used on other languages.

Accepted Answer

A) True 
 B)False

Question 14

The REF attribute tells the system to look up the data type of a database column and use it for the declared variable. _________________________

Accepted Answer

A) True 
 B)False

Question 15

Which of the following associative array attributes checks to see if a value has been entered for the stated index number?

Accepted Answer

A)  COUNT 
B)  FIRST 
C)  EXISTS 
D)  PRIOR 
A)  COUNT 
B)  FIRST 
C)  EXISTS 
D)  PRIOR

Question 16

It is possible to perform SQL commands on an associative array.

Accepted Answer

A) True 
 B)False

Question 17

A(n) ____________________ is similar to a record data type except that it can handle more than one record or row of data.

Accepted Answer

The answer of A(n) ____________________ is similar to a record...

Question 18

One of the main differences between a nested table and a VARRAY is that a nested table has a set size upon creation.

Accepted Answer

A) True 
 B)False

Question 19

The _________________ attribute simplifies the creation of a record variable by referencing a table structure.

Accepted Answer

The answer of The _________________ attribute simplifies the creation of...

Question 20

tbl_basketitems(5).idproduct := :g_prod; According to the above statement, which of the following indicates the field into which a value will be placed?

Accepted Answer

A)  idproduct 
B)  tbl_basketitems 
C)  :g_row 
D)  :g_prod 
A)  idproduct 
B)  tbl_basketitems 
C)  :g_row 
D)  :g_prod

When placing data into a table of records variable, you must indicate the field that will hold the value but you need not indicate the row.

A(n) table of records can handle more than one row of data. _________________________

Declaring a composite variable is different from declaring a scalar variable in that you must create your own data types.

A(n) composite data type is one that can store and handle multiple values of different data types as one unit. _________________________

A collection is a data type that can store multiple values of different data types as one unit.

Which of the following statements about collections is NOT True?

Declaring an associative array data type is quite similar to declaring a(n) table of records data type. _________________________

A disadvantage of using the %TYPE attribute is that there is a slight performance hit in that the database server must look up the data type from the data dictionary.

The ____________________ clause follows the SELECT clause and indicates which variables are to hold the values that are retrieved from the database.

One major advantage of using ____ as part of the physical database is being able to retrieve multiple values with a query of a single column.

The ____________________ attribute tells the system to look up the data type of a database column and use this data type for the declared variable.

Which of the following allows a table of records value to persist for a user session?

Anchored data types are similar to arrays used on other languages.

The REF attribute tells the system to look up the data type of a database column and use it for the declared variable. _________________________

Which of the following associative array attributes checks to see if a value has been entered for the stated index number?

It is possible to perform SQL commands on an associative array.

A(n) ____________________ is similar to a record data type except that it can handle more than one record or row of data.

One of the main differences between a nested table and a VARRAY is that a nested table has a set size upon creation.

The _________________ attribute simplifies the creation of a record variable by referencing a table structure.

tbl_basketitems(5).idproduct := :g_prod; According to the above statement, which of the following indicates the field into which a value will be placed?

Introduction To PL/SQL

Basic PL/SQL Block Structures

Cursors and Exception Handling

Procedures

Functions

PL/SQL Packages

Program Unit Dependencies

Database Triggers

Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code

Filters

Exam 3: Handling Data In PL/SQL Blocks

When placing data into a table of records variable, you must indicate the field that will hold the value but you need not indicate the row.

A(n) table of records can handle more than one row of data. _________________________

Declaring a composite variable is different from declaring a scalar variable in that you must create your own data types.

A(n) composite data type is one that can store and handle multiple values of different data types as one unit. _________________________

A collection is a data type that can store multiple values of different data types as one unit.

Which of the following statements about collections is NOT True?

Declaring an associative array data type is quite similar to declaring a(n) table of records data type. _________________________

A disadvantage of using the %TYPE attribute is that there is a slight performance hit in that the database server must look up the data type from the data dictionary.

The ____________________ clause follows the SELECT clause and indicates which variables are to hold the values that are retrieved from the database.

One major advantage of using ____ as part of the physical database is being able to retrieve multiple values with a query of a single column.

The ____________________ attribute tells the system to look up the data type of a database column and use this data type for the declared variable.

Which of the following allows a table of records value to persist for a user session?

Anchored data types are similar to arrays used on other languages.

The REF attribute tells the system to look up the data type of a database column and use it for the declared variable. _________________________

Which of the following associative array attributes checks to see if a value has been entered for the stated index number?

It is possible to perform SQL commands on an associative array.

A(n) ____________________ is similar to a record data type except that it can handle more than one record or row of data.

One of the main differences between a nested table and a VARRAY is that a nested table has a set size upon creation.

The _________________ attribute simplifies the creation of a record variable by referencing a table structure.

tbl_basketitems(5).idproduct := :g_prod; According to the above statement, which of the following indicates the field into which a value will be placed?

Introduction To PL/SQL

Basic PL/SQL Block Structures

Cursors and Exception Handling

Procedures

Functions

PL/SQL Packages

Program Unit Dependencies

Database Triggers

Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code

Filters