PL/SQL

The PL/SQL language uses which of the following:

• Variables

• Cursors

• Conditional logic

• . Data definition language

The three types of blocks that can make up a PL/SQL program are:

• Anonymous

• Procedures

• Manipulative

• Functions

In the LIKE operator, which symbol is used to represent a single text character or numeric digit?

• "_ "

• "/"

• "&"

• "%" asdf

Which of the following can be used in the SELECT statement to return all columns of data in a table?

• ALL

• ALL

• *

• DISTINCT

PL/SQL variables can be used for:

• Reusability

• Comments

• Stored values

• Default values

A reserved word can be used as an identifier in a PL/SQL program.

• True

• False

Select the correct method for declaring a variable of a previously declared variable or databasecolumn

• %LIKE

• %TYPE

• zxr v

Which group functions below act on text, number and date datatypes?

• SUM

• COUNT

• MAX

• MIN

• AVG

Is the following a valid statement? v_date_of_joining DATE:= 'February 02,2000';

• Yes

• No

Which of the following is a composite data type?

• VARCHAR

• RECORD

• CLOB