Part-13

What is Distributed database? -

A distributed database is a network of databases managed by multiple database servers that appears to a user as single logical database. The data of all databases in the distributed database can be simultaneously accessed and modified.
How can we reduce the network traffic? -

Replication of data in distributed environment. - Using snapshots to replicate data. - Using remote procedure calls.

Differentiate simple and complex, snapshots? -

A simple snapshot is based on a query thaat does not contains GROUP BY clauses, CONNECT BY clauses, JOINs, sub-query or snapshot of operations. - A complex snapshots contain at least any one of the above.

What are the Built-ins used for sending Parameters to forms? -

You can pass parameter values to a form when an application executes the call_form, New_form, Open_form or Run_product.

Can you have more than one content canvas view attached with a window? -

Yes. Each window you create must have at least one content canvas view assigned to it. You can also create a window that has manipulated content canvas view. At run time only one of the content canvas views assign to a window is displayed at a time

Is the After report trigger fired if the report execution fails? - Yes.

Does a Before form trigger fire when the parameter form is suppressed? - Yes.

Is it possible to split the print reviewer into more than one region? - Yes

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size? - Yes

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame? - Yes

Can a field be used in a report without it appearing in any data group? - Yes

The join defined by the default data link is an outer join yes or no? - Yes

Can a formula column referred to columns in higher group? - Yes

Can a formula column be obtained through a select statement? - Yes

Is it possible to insert comments into sql statements return in the data model editor? - Yes

Is it possible to disable the parameter from while running the report? - Yes

When a form is invoked with call_form, Does oracle forms issues a save point? - Yes

Can a property clause itself be based on a property clause? - Yes

If a parameter is used in a query without being previously defined, what diff. exist between report 2.0 and 2.5 when the query is applied? - While both reports 2.0 and 2.5 create the parameter, report 2.5 gives a message that a bind parameter has been created.