Oracle interview questions

One Comment on Oracle interview questions

1. Suresh
   Posted 3/27/2007 at 1:32 pm | Permalink

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

   Yes. Each window you create must have atleast 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.

   114. Is the After report trigger fired if the report execution
   fails?

   Yes.

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

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

   Yes

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

   Yes

   118. 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

   119. Can a field be used in a report without it appearing in any
   data group?

   Yes

   120. The join defined by the default data link is an outer join yes
   or no?

   Yes

   121. Can a formula column referred to columns in higher group?

   Yes

   122. Can a formula column be obtained through a select statement?

   Yes

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

   Yes

   124. Is it possible to disable the parameter from while running the
   report?

   Yes

   126. When a form is invoked with call_form, Does oracle forms issues
   a save point?

   Yes

   127. Can a property clause itself be based on a property clause?

   Yes

   128. If a parameter is used in a query without being previously
   defined, what diff. exist betw. 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.

   129. What are the sql clauses supported in the link property sheet?

   Where start with having.

   130. What is trigger associated with the timer?

   When-timer-expired.

   131. What are the trigger associated with image items?

   When-image-activated fires when the operators double clicks on an
   image itemwhen-image-pressed fires when an operator clicks or double
   clicks on an image item

   132. What are the different windows events activated at runtime?

   When_window_activated
   When_window_closed
   When_window_deactivated
   When_window_resized