PLSQL-Introduction

Identify situations in which you can use the %ROWTYPE attribute

• When you are not sure about the structure of the underlying database table

• When you want to retrieve an entire row from a table

• When you want to declare a variable according to another previously declared variable or database column

Subprograms:

• Are named PL/SQL blocks and can be invoked by other applications

• Are compiled only once

• Are stored in the database

• Do not have to return values if they are functions

• Can take parameters

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

• Anonymous

• Procedures

• Manipulative

• Functions

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

PL SQL Stands for

• Programming Language for SQL

• Procedural Language for SQL

• Plain Language for SQL

• None of these

Which statements execute a sequence of statements multiple times?

• EXIT

• LOOP

• Both A & B

• None of the above

Assignment Operator

• :=

• =

• ::

• &

Correct syntax to declare a variable

• variablename datatype[:=value];

• variablename [:=value];

• variablename datatype[=value];

• datatype variablename[:=value];