A stored procedure is typically written in SQL.

A stored procedure is a named PL/SQL block that can accept parameters.

A stored procedure is a type of PL/SQL subprogram that performs an action.

A stored procedure has three parts: the specification, the body, and the exception handler part.

The executable section of a stored procedure contains statements that assigns values, control execution, and return values to the calling environment.

Cursor table

Table filter

Dynamic procedure

View

Summary table

OS requirement

User analysis

Performance monitoring

Data dictionary specification

System requirement

Structure

Design issue

Data source

Storage issue

Operational process

Data about data

Describes a data dictionary

Self-describing

Includes user data

Supports its own structure

GROUP BY clause

INDEX command

HAVING clause

FROM clause

WHERE clause

Place the alias at the beginning of the statement to describe the table.

Place the alias after each column, separated by white space, to describe the column

Place the alias after each column, separated by a comma, to describe the column.

Place the alias at the end of the statement to describe the table.

Place the alias at the end of where clause to describe each table

True

False

True

False

True

False

Remote DBMS

Relative DBMS

Relational DBMS

Reliable DBMS

True

False

True

False

True

False

True

False

True

False

True

False

Chain

Network

Tree

Relational

Indexes

Public synonyms

Triggers

Packages

Between -20000 and -20999

Between -200000 and -209999

Between -20001 and -20999

Between -200001 and -209999