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

Fractions

First we increased the denominator of a positive fraction by 3 and then decrease it by 5.The sum of the resulting fractions proves to be equal to 2/3. Find the denominator of the fraction if its numerator is 2?

Simplification

If we divide a two digit number by the sum of its digits we get 4 as a quotient and 3 as a remainder. Now if we divide that two digit number by the product of its digits we get 3 as a quotient and 5 as a remainder . Find the two digit number?

Fractions

The denominators of an irreducible fraction is greater than the numerator by 2.If we reduce the numerator of the reciprocal fraction by 3 and subtract the given fraction from the resulting one,we get 1/15.Find the given fraction?

Simplification

If we add the square of the digit in the tens place of the positive two digit number to the product of the digits of that number we get 52,and if we add the square of the digit in the unit's place to the same product of the digits we get 117.Find the two digit number?

The sum of squares of the digits constituting a positive two digit number is 13, If we subtract 9 from that number we shall get a number written by the same digits in the reverse order. Find the number?

The arithmetic mean of two numbers is smaller by 24 than the larger of the two numbers and the GM of the same numbers exceeds by 12 the smaller of the numbers. Find the numbers?

A number being successively divided by 3,5,8 leaves remainder 1,4,7 respectively. Find the respective remainders if the order of divisors are reversed?

The sum of all possible two digit numbers formed from three different one digit natural numbers when divided by the sum of the original three numbers is equal to?

HCF and LCM

Find the HCF and LCM of the polynomial x2-5x+6 and x2-7x+10?

Simplification

When we multiply a certain two digit number by the sum of its digits , 405 is achieved. If we multiply the number written in reverse order of the same digits by the sum of the digits, we get 486. Find the number?

Average

The sum of two numbers is 15 and their geometric mean is 20% lower than their arithmetic mean. Find the numbers?

Numbers

The difference of 1025-7 and 1024+x is divisible by 3. find x=?

A number when divided by the sum of 555 and 445 gives two times their difference as quotient and 30 as remainder . The number is?

The sum of three prime numbers is 100.If one of them exceeds another by 36 then one of the numbers is?

Find the number of zeros in the factorial of the number 18?

If a number is multiplied by 22 and the same number is added to it then we get a number that is half the square of that number. Find the number?

In doing a division of a question with zero remainder,a candidate took 12 as divisor instead of 21.The quotient obtained by him was 35. The correct quotient is?

Fractions

A number when divided by 342 gives a remainder 47.When the same number is divided by 19 what would be the remainder?

Latest Job Notifications

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 अंतिम तिथि

Government Jobs

दिल्ली सबऑर्डिनेट सर्विस सिलेक्शन बोर्ड Delhi Subordinate Services Selection Board(DSSSB) - 5807 पद - 03/07/2021 अंतिम तिथि

Jobs in Madhya Pradesh

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

Government Jobs

इंडियन पोस्ट सर्विस Indian Post Service - 4368 पद - 29/05/2021 अंतिम तिथि

दिल्ली सबऑर्डिनेट सर्विस सिलेक्शन बोर्ड Delhi Subordinate Services Selection Board(DSSSB) - 7236 पद - 24/06/2021 अंतिम तिथि