Oracle Forms Interview Questions and Answers

What is property class, visual attributes and Difference between property class & visual attribute?

Property Class:-It is a global Property sheet where we can define the properties of different objects. 

Visual Attributes:-it is used to set the visual appearance of interface objects like items, records and canvases .There are three types of visual attributes. 
Default:-It is the visual attribute by default attached to the oracle form related objects. 
Custom:-When the default VA is amended with few properties. 
User Defined: - This can be attached to the objects at design time under VA Node as well as run time programmatically. 

We can change Visual Attribute properties dynamically at runtime,but we cannot change Property class properties.
When u inherit the both Visual Attribute properties and Property class properties to an item Visual Attribute properties overrides the Property class properties

Post comment
Cancel
Thanks for your comment.!
Write a comment(Click here) ...
What is a window?
This object specifies the window in which the canvas object is displayed at runtime.
What is a Canvas?
This object represents a background entity on which you place interface items, such as check boxes, radio groups, and text items. There are four types of canvas objects: Content, Stacked, Horizontal Toolbar, and Vertical Toolbar.
What is Model window and Modeless window?
Model windows -- require an end user to dismiss the window before any other user interaction can continue. Modeless window --requires no end user response.
Describe Call-Form, Open-form, New-Form?

Call Form: Runs an indicated form while keeping the parent form active. Form Builder runs the called form with the same. Run form preferences as the parent form. When the called form is exited Form Builder processing resumes in the calling form at the point from which you initiated the call to CALL_FORM.

Open Form: Opens the indicated form. Use OPEN_FORM to create multiple-form applications, that is, applications that open more than one form at the same time.

New Form: Exits the current form and enters the indicated form. The calling form is terminated as the parent form .If the calling form had been called by a higher form, Form Builder keeps the higher call active and treats it as a call to the new form. Form Builder runs the new form with the same Run form options as the parent form. If the parent form was a called form, Form Builder runs the new form with the same options as the parent form.

What is the difference b/w Data block and Control block?
Data block is a block, which connects to the database. Control block is a block, which is not connected to the database.
Difference b/w Pre-Query and Post-Query?
Pre-Query Validate the current query criteria or provide additional query criteria programmatically, just before sending the SELECT statement to the database. Post-Query Perform an action after fetching a record, such as looking up values in other tables based on a value in the current record. Fires once for each record fetched into the block.

Trigger sequence while opening a form?

Pre-Form, 
Pre-Block, 
Pre-Record, 
Pre-Item, 
When-new-form-Instance, 
When-new-block-Instance, 
When-new-Record-instance, 
When-new-Item-instance

Types of Record-Groups?

Static Record Group: - A static record group is not associated with a query; instead, we define its structure and row values at design time, and they remain fixed at runtime. Static record groups can be created and modified only at design time.

Query Based Record Group: - A query record group is a record group that has an associated SELECT statement. The columns in a query record group derive their default names, data types, and lengths from the database columns referenced in the SELECT statement. The records in a query record group are the rows retrieved by the query associated with that record group.

Non Query Record Group: - A non-query record group is a group that does not have an associated query, but whose structure and values can be modified programmatically at runtime. Non-query record groups can be created and modified only at runtime.

How many types of canvases available in forms & which is the default canvas?

Content:- it is the base view of window which occupies the entire surface of window. It can have any no of canvases but at a time only one is visible. It is the default canvas

Stacked:-It is always displayed above the content canvas, because the content Canvas is the base view. It can have any no of stacked canvases and more than one stacked canvas can be displayed at a time. It is mainly used as headers and footers to display the tittles, dates and times etc. 

Tool bar:- A toolbar canvas often is used to create toolbars for individual windows. There are two types of tool bars Horizontal and Vertical Tool bar Canvas.
Horizontal tool bar canvases are displayed at the top of window and only one horizontal tool bar can be attached to a form module.
Vertical tool bar is used to display top to bottom on the left side of the window. 

Tab:- It is a collection of one or more tab pages. It is mainly used to display a large amount of related information a single dynamic form builder canvas object.

What are the triggers types in master details forms and What are the procedures that will gets created when a master details form created?
Triggers ISOLATED:- ON_CLEAR_DETAILS AND ON_POPULATE_DETAILS NON ISOLATED:- ON_CLEAR_DETAILS, ON_POPULATE_DETAILS AND ON_CHECK_DELETE_MASTER CASCADING:- ON_CLEAR_DETAILS, ON_POPULATE_DETAILS AND PRE-DELETE Procedures CHECK_PACKAGE_FAILURE CHECK_ALL_MASTER_DETAILS QUERY_MASTER_DETAILS

Latest Updates

Pipes and Cistern

Two pipes A and B can fill a tank in 6 hours and 4 hours respectively. If they are opened on alternate hours and if pipe A s opened first, in how many hours, the tank shall be full?

A large tanker can be filled by two pipes A and B in 60 min and 40 min respectively. How many minutes will it take to fill the tanker from empty state if B is used for first half of the time, and A and B fill it together for the other half?

A tank is filled by 3 pipes with uniform flow. The first two pipes operating simultaneously fill the tank in the same time during which the tank is filled by the third pipe alone. The 2nd pipe fills the tank 5 hours faster than first pipe and 4 hours slower than third pipe. The time required by first pipe is?

Two pipes A and B together can fill a cistern in 4 hours. Had they been opened separately, then B would have taken 6 hours more than A to fill the cistern. How much time will be taken by A to fill the cistern separately?

Two pipes A and B can fill a tank in 24 min and 32 min respectively. If both the pipes are opened simultaneously, after how much time B should be closed so that the tank is full in 18 min?

Two pipes A and B can fill a tank in 36 min and 45 min respectively. A water pipe C can empty the tank in 30 min. First A and B are opened. after 7 min, C is also opened. In how much time, the tank is full?

Two pipes can fill a cistern in 14 hours and 16 hours respectively. The pipes are opened simultaneously and it is found that due to leakage in the bottom it took 32 min more to fill the cistern. When the cistern is full, in what time will the leak empty it?

Bucket P has thrice the capacity as Bucket Q. It takes 60 turns for Bucket P to fill the empty drum. How many turns it will take for both the buckets P and Q, having each turn together to fill the empty drum?

Probability

In a class , 30 % of the students offered English, 20 % offered Hindi and 10 % offered Both.If a student is offered at random, what is the probability that he has offered English or Hindi?

In a lottery ,there are 10 prizes and 25 blanks.A lottery is drawn at random. what is the probability of getting a prize ?

Two dice are thrown simultaneously .what is the probability of getting two numbers whose product is even?

Two diced are tossed the probability that the total score is a prime number?

Two cards are drawn at random from a pack of 52 cards What is the probability that either both are black or both are queens?

Two dice are thrown together .What is the probability that the sum of the number on the two faces is divisible by 4 or 6?

A bag contains 6 white and 4 black balls .Two balls are drawn at random .Find the probability that they are of the same colour?

In a simultaneous throw of a pair of dice,find the probability of getting a total more than 7?

An unbiased die is tossed.Find the probability of getting a multiple of 3?

Problems on Ages

My brother is 3 years elder to me. My father was 28 years of age when my sister was born while my mother was 26 years of age when i was born. If my sister was 4 years of age when my brother was born,then what was the age my father and mother respectively when my brother was born?

Latest Job Notifications

Banking Jobs

बैंकिंग कार्मिक चयन संस्थान Institute of Banking Personnel Selection(IBPS) - 7855 पद - 29/07/2022 अंतिम तिथि

SSC Recruitment

कर्मचारी चयन आयोग (एसएससी) Staff Selection Commission (SSC) - 1411 पद - 29/07/2022 अंतिम तिथि

Jobs in Rajasthan

राजस्थान अधीनस्थ और मंत्रिस्तरीय सेवा चयन बोर्ड Rajasthan Subordinate and Ministerial Services Selection Board (RSMSSB) - 5546 पद - 22-Jul-2022 अंतिम तिथि

Railway Recruitment

उत्तर मध्य रेलवे भर्ती प्रकोष्ठ Railway Recruitment Cell(NCR) - 1659 पद - 01/08/2022 अंतिम तिथि

Jobs in West Bengal

इंडियन पोस्ट सर्विस Indian Post Service - 2357 पद - 19/08/2021 अंतिम तिथि - पश्चिम बंगाल पोस्टल सर्कल

Banking Jobs

भारतीय स्टेट बैंक State Bank of India(SBI) - 6100 पद - 26/07/2021 अंतिम तिथि - CRPD/APPR/2021-22/10

SSC Recruitment

कर्मचारी चयन आयोग Staff Selection Commission(SSC) - 25271 पद - 31/08/2021 अंतिम तिथि

Jobs in Madhya Pradesh

राष्ट्रीय स्वास्थ्य मिशन मध्य प्रदेश National Health Mission MP(NRHM) - 5215 पद - 22/06/2021 अंतिम तिथि

Jobs in Punjab

पंजाब स्टेट पावर कॉर्पोरेशन लिमिटेड Punjab State Power Corporation Limited (PSPCL) - 2632 पद - 20/06/2021 अंतिम तिथि

Jobs in Chhattisgarh

स्वास्थ्य सेवा निदेशालय, छत्तीसगढ़ Department of Health & Family Welfare, Chhattisgarh - 267 पद - 26/06/2021 अंतिम तिथि