Database Administration Questions

The database schema is written in DDL. A data definition language or data description language (DDL) is a syntax similar to a computer programming language for defining data structures, especially database schemas.

Fires when oracle forms first marks a record as an insert or an update. The trigger fires as soon as oracle forms determines through validation that the record should be processed by the next post or commit as an insert or update. Generally occurs only when the operators modifies the first item in the record, and after the operator attempts to navigate out of the item.

An OLE server application creates ole Objects that are embedded or linked in OLE Containers ex. OLE servers are ms_word & ms_excel. OLE containers provide a place to store, display and manipulate objects that are created by ole server applications. Ex. oracle forms is an example of an OLE Container.

All the above listed actions are the functions of cursor

Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint.

Coalescing is only valid for dictionary-managed tablespaces and de-fragments space by combining neighboring free extents into large single extents.

Group of tables physically stored together because they share common columns and are often used together is called Cluster.

Before form , After form , Before report, Between page, After report.