Only when it is Committed

Only when it is Rolledback

When it is Committed or Rolledback

None of the above

$$dbtime$$

$$time$$

$$datetime$$

None of the above

To protect some of the columns of a table from other users

Ocuupies data storage space

To hide complexity of a query

To hide complexity of a calculations

SELECT CALC_PLAYER_AVG(PLAYER_ID) FROM PLAYER_BAT_STAT;

EXECUTE CALC_PLAYER_AVG(31);

CALC_PLAYER(‘RUTH’);

CALC_PLAYER_AVG(31);

An object with status of invalid cannot be a referenced object.

The Oracle server automatically records dependencies among objects.

All schema objects have a status that is recorded in the data dictionary.

You can view whether an object is valid or invalid in the USER_STATUS data dictionary view.

SYS privileges

Your privileges

Public privileges

User A’s privileges

add_dept;

add_dept(‘Accounting’);

add_dept(, ‘New York’);

add_dept(p_location=>’New York’);

Cursor

Trigger

Sequence

View

It persists across transactions within a session.

It persists from session to session for the same user.

It does not persist across transaction within a session.

It persists from user to user when the package is invoked.

Use a drop procedure statement to drop a standalone procedure.

Use a drop procedure statement to drop a procedure that is part of a package. Then recompile the package specification.

Use a drop procedure statement to drop a procedure that is part of a package. Then recompile the package body.

For faster removal and re-creation, do not use a drop procedure statement. Instead, recompile the procedure using the alter procedure statement with the REUSE SETTINGS clause.

If errors occur during the compilation of a trigger, the trigger is still created.

If errors occur during the compilation of a trigger you can go into SQL *Plus and query the USER_TRIGGERS data dictionary view to see the compilation errors.

If errors occur during the compilation of a trigger you can use the SHOW ERRORS command within iSQL *Plus to see the compilation errors.

If errors occur during the compilation of a trigger you can go into SQL *Plus and query the USER_ERRORS data dictionary view to see compilation errors.

USER_SOURCE

UTL_DEPTREE

USER_OBJECTS

DEPTREE_TEMPTAB

The rows are selected and ordered.

The validity of the SQL statement is established.

An area of memory is established to process the SQL statement.

The SQL statement is run and the number of rows processed is returned.

Trigger type

Trigger body

Trigger event

Trigger timing

USER_PROCEDURES

USER_PROCS

USER_OBJECTS

USER_PLSQL_UNITS

a record

a field

a table

an entity

section name, age

name

undergraduate

name, class name

major, gender

Visio

ERwin

ER/Studio

Data Builder

empowER

Design logical data systems

Design physical storage system

Define data entities relevant to the enterprise

All of the above

Business Data Model

Logical Data Model

Data Management Process Model

Data entity/business function Matrix

Data Interface requirements