Subscribe Feed (RSS)General Oracle Interview Questions – Some Basic Job Conceptual Questions – Biggest Collection
Explain the points of difference between DBMS and RDBMS.
Is it possible to have two or more canvas views attached with a window?
List the various Built-ins used to send parameters to forms.
What happens if there is failure of report execution?
When is the After report trigger run?
Can we refer a formula column to higher group columns?
Method of indirect reference of paramter?
What do you mean by a timer?
Explain the points of difference between call_form and open_form?
Can we use a field in report without having it in data group?
Explain the various types of calculated columns.
Describe the visual attributes.
How do two null values in a column differ from each other?
Which trigger is used with the timer?
What do you mean by new_form built in?
Why does a where clause work quicker than a group filter?
Can we maek a repeating frame without a data group as a base?
Why is a hidden column needed?
What is the use of select statement? Can we get a formula column using select statement?
Where do we use data parameter type?
Explain the various windows events taking place at runtime?
Benefit of place holder column.
What do you mean by lexical reference?
What do you know about content canvas views?
How can you get the 4th largest value from a tab?
Explain the use of cmd file
What do you mean by tansactional triggers?
Explain the function of break group.
Various different types of parameters.
When is the before form trigger fired?
Can the print reviewer be cut into regions?
Which parameter can be seen by default at run time in parameter screen?
Name the external query executed at the client or server?
What is the use of procedure return?
What do you mean by bind reference?
How can we make a bind reference?
How can we disable the paramter when the report is running?
Which designation is used to send output to the printer?
List the various file extensions made by oracle reports.
Different panes which are seen in runtime pl/sql interpreter. Which panes are seen in design time?
How can we generate data for a parameter value list?
How can we provide a drill down in a report?
Explain the difference between Flex mode on and mode off.
Explain the difference between confine mode on and off.
Can we see user parameters in data modal editor in 2.5?
What happens if we use a undefined parameter in a query – in report 2.0 and report 2.5?
How can we use select set in query property sheet?
Explain the various views available in object navigator in report 2.5?
Method for passing data parameters to forms?
What do you mean by a physical and a logical page?
What is do understand by anchoring object?
If we want to display each page number in a report, which source and logical page number we use?
What term panel means in pages?
How to draw a square in the layout editor?
Does a grouping in layout editor affect the grouping in data model editor?
Which two frames are associated with matrix objects?
How do we center an object in a frame with a varying size?
Is it possible to attach a text file to a report while the report writer is being created?
Explain the hierarchy between two groups not linked in data model editor.
What do you mean by a term?
What is the function of a term?
Which parameter is required to have consistent read level in multiple queries?
How can we insert comments into sql statements?
How will we calculate a summary value if we set the maximum record retrieved property of the query to 10?
Which sql clauses are supported by link property sheet?
Which property do we use to stop a row being displayed which has column in the row?
How do we set a filter condition in matrix reports?
Which columns are affected when we set a break order in one column?
Which summary item function needs compute at options?
Why do we need product order option in case of column property sheet?
How do we use a break order on an existing column?
How can we make receipts from bill receivables transactions?
Method to refernce a parameter.
How can we use Oracle forms to call other oracle apps?
How many chars can a parameter store?
What do you mean by parameters?
Various styles used for activation of ole objects?
Various points of difference between Ole container and OLE Server.
What do you understand by Object embedding and linking in case of Oracle forms?
What do you understand by OLE?
Various objects that can’t be copied in object groups?
What do you understand by object group?
Which built-ins are required to find object ID Function?
What is the use of ADD_GROUP_COLUMN function?
How can we add a column to a record group built at design stage?
How can we use built-in to get cell values?
How can we process various rows using built-in?
Explain the various types of modules in oracle form.
Which default file extensions are used by forms modules?
Which file extensions are made by menu module by default?
Name the default file extension in case of library module.
Explain the different sub events involved in a single mouse click and double click.
Various system variables in case of mouse events.
When a new form is made, how do we make a new session?
Is it possible to go to disabled form in call_form stack using the program?
Is there a save point in oracle forms after call_form is used to invoke a form?
Explain the various built-ins used for row processing.
Which built-ins are used to get cell values?
What is the use of Populate_Group function?
How do we use built-ins to modify a group structure?
How can we create or delete groups using built-ins?
What do you understand by Static Record Group?
What do you understand by Query record group?
Various types of record groups used.
How long can be the record group column?
How many maximum columns are possible in a record group?
What do you mean by a record group?
Explain the built-ins to set LOV Properties at runtime?
How can we disply LOV using Built-ins?
Explain the property “Lov of validation” of an item.
How can we use a basic data structure to make a LOV?
Explain the points of difference between Show_Editor and Edit_Textitem.
Explain the built-ints used for user-named editor.
What do you mean by user-named editor?
How does the master coordinate with detail block?
Explain the various coordination properties in case of Master-Detail links.
Explain the various default triggers set when a Master Delete property is isolated?
What happens when a master delete property is set to cascade?
Explain the various types of master-detail linkages? What do you know about master-detail relationships?
Explain the various phases of block coordination.
What do you mean by coordination event?
Why do we need image_zoom built-in?
Various triggers used with large items?
Explain the points of difference between boiler plate images and image items?
Explain the various types of images.
What do you mean by forms_DDL?
Define the term ’synchronize’
What do you mean by user_exit?
Describe the Text_io Package.
Explain the method of passing values between prcompiler exits and oracle call interface?
Explain the various types of user exits.
Can we link groups inside cross products?
How can we identify a group in cross products from a group with no cross product?
Explain the method of cross product creation.
List various functions used to get or set canvas properties.
What do you know about horizontal or vertical canvas tool bar views?
Explain the various types of canvas views.
Explain the points of difference between property clause and visual attributes.
How can be have a property cause based on another property clause?
For how many windows in a form, is it possible to have console?
What do you mean by ‘remove on exit’ property?
Explain the method to display console on window.
What do you know about modal windows?
What do you understand by modalless windows?
Explain the different modals of windows.
Explain the relaionship between window and canvas views.
List the various points of difference between pre-query and pre-select?
Tell the difference between post form commit and post database commit.
Can you name some built-ins used with timers?
Describe some vbx controls.
What is the importance of library?
What do you understand by a combo box?
What do you mean by text list?
Explain the pop list.
Benefit of display items.
Explain the various display styles used in list items.
Explain the points of difference in lov and list item.
What do you understand by system.coordination_operation?
What do you mean by master-detail triggers?
What is the use of WHEN-Database-record trigger?
What is the difference in link tool in case of report 2 and report 2.5?
What is the difference in features of Reports 2.5 and Reports 2.0?
What do you mean by name space?
What is the difference between name space and schema?
Explain the different methods for calculation in a report.
What do you mean by frame and repeating frame?
List the various trigger options we have in reports.
When do we use the before report trigger?
Can you tell about the sequence of execution of different report triggers?
How can we alter the external query in a report?
How can we know how our report performed?
Explain the various clauses existing in the Create Table command.
Why do we prefer to have a lesser number of queries in the data model?
We have to increase memory if we increase database size. How much should be the memory increase relative to the increase in database size?
