10 Apr, 2007
Database Interview Questions
- 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.
- What are the SQL clauses supported in the link property sheet? - Where start with having.
- What is trigger associated with the timer? - When-timer-expired.
