Font size
WorksheetsPL/SQL
Total questions: 10
Worksheet time: 6mins
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
