Tag: databases

The relation of the primary key of a base table with foreign key of the reference table is known as referential integriety.

The relation of the secondary key of a base table with foreign key of the reference table is known as referential integriety.

The relation of the primary key of a secondary table with foreign key of the reference table is known as referential integriety.

The relation of the primary key of a base table with index key of the reference table is known as referential integriety.

PCTFREE: percentage of each page to be left free and FREEPAGE: Number of pages to be loaded with data between each free page.

PCTFREE: percentage of each page to be loaded with data and FREEPAGE: Number of pages to be loaded with data between each free page.

PCTFREE: percentage of each page to be left free and FREEPAGE: Number of pages to be left free with data between each loaded page.

PCTFREE: percentage of each page to be loaded with data between each free page and FREEPAGE: Number of pages to be left free.

TSO and CICS

IMS and BATCH

TSO, CICS, IMS and DB2

TSO, CICS, IMS and VSAM

After a load

After mass updates

After a deletes

After a inserts

True

False

Type of Exception

Finally block

An Error Code

A message

Named System Exceptions

Unnamed System Exceptions

Implicit Exceptions

Explicit Exceptions

User-defined Exceptions

Not Declared explicitly

Raised implicitly when a predefined Oracle error occurs

caught by referencing the standard name within an exception-handling routine

All of the above

None of the above

True

False

DECLARE

RAISE

PRAGMA

INITIATE