Tag: databases

Querying with the SELECT * notification.

Declaring variables with the %TYPE attribute.

Specifying schema names when referencing objects.

Declaring records by using the %ROWTYPE attribute.

Specifying package.procedure notation while executing procedures.

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