Perform Object Java Oriented

Plain Object Java Old

Platform Oriented Java Object

Plain Old Java Object

All extents are released.

All rows of the table are deleted.

Any associated indexes are truncated.

No undo data is generated for the table's rows.

Control file authentication

Password file authentication

Data dictionary authentication

Operating system authentication

The resulting index may contain deleted entries.

A new index is built using an existing index as the data source.

Queries cannot use the existing index while the new index is being built.

During a rebuild, sufficient space is needed to accommodate both the old and the new

STARTUP

STARTUP OPEN

STARTUP MOUNT

STARTUP NOMOUNT

DBA_EXTENTS

V$FREESPACE

DBA_FREE_SPACE

DBA_FREE_EXTENTS

Connection Management

Bean Management

Transaction Management

Object relational mapping

Relational Management

True

False

1,147,483,647

2,147,483,647

3,147,483,647

4,147,483,647

50

up to 1000

10,000

N number

5

1

five times 1

one time 5

GROUP BY controls presentation of rows and ORDER BY controls presentation of columns for results of SELECT statement

GROUP BY controls presentation of columns and ORDER BY controls presentation of rows for results of SELECT statement

GROUP BY orders rows in query's return and ORDER BY orders columns in query's return

none

FILE AID

BIND

PLAN

NONE

True

False

DBD

PSB

PCB

IMSCB

True

False

SEARCH FIELD

KEY FIELD

BOTH

NONE

BATCH DL/I

MPP

BMP

ALL

15

255

1

NO LIMITATIONS

15

255

1000

1