If you are preparing for an Oracle developer role interview then you must be well versed with Oracle Forms and Reports. Reviewing these interview questions will help you to crack any interview and hence this article is strongly recommended for the job seekers. Q 1 What do you understand by Oracle Forms and why are they required? Answer: Oracle Forms are the user interfaces that are developed to present the data to the user. This data can be presented once retrieved from the Oracle database. If required, forms can be integrated with web services or Java to follow SOA architecture.
|Country:||Central African Republic|
|Published (Last):||9 July 2009|
|PDF File Size:||13.42 Mb|
|ePub File Size:||17.79 Mb|
|Price:||Free* [*Free Regsitration Required]|
If you are preparing for an Oracle developer role interview then you must be well versed with Oracle Forms and Reports. Reviewing these interview questions will help you to crack any interview and hence this article is strongly recommended for the job seekers. Q 1 What do you understand by Oracle Forms and why are they required?
Answer: Oracle Forms are the user interfaces that are developed to present the data to the user. This data can be presented once retrieved from the Oracle database. If required, forms can be integrated with web services or Java to follow SOA architecture. Forms are created at source as. Q 2 Explain the different levels at which Oracle Form Services interact. Answer: Oracle Form Services is a three-tier application and hence it will interact at the below levels:.
At the client level, HTTP requests will be sent by a client to the system. This request will be received by the Forms Listener Servlet at the server and it will initiate Forms Runtime process. This process will send the request to the database to retrieve the information and send it back to the client. Q 3 Can we invoke one form from another in a multi-forms application? Answer: Yes, we can invoke one form from another with the help of the below built-in functions:.
Q 4 What do you understand by LOV and how can it be used? Answer: LOV is a list of values populated in a pop-up window and is displayed to the end-user for selection. These values can be assigned and invoked statically or dynamically in LOV. If the value does not match, LOV will be displayed and a search will happen based on the text item. Answer: Canvas is a layer within a window where the visual objects like interface items or graphics can be placed. Q 6 In what sequence do triggers get fired by Oracle Forms?
Q 7 Explain the Master-Detail relationship with some examples. Answer: Master-Detail relationship is the relationship among different business entities which follows the parent-child relationship pattern. There will be one parent entity linked to many child entities.
This relationship can be implemented with the help of two data blocks where the first data block represents the master table while the other represents a detailed table. Q 8 Name the different triggers associated with Oracle Forms having a master-detail relationship. Answer: Enlisted triggers gets created during the creation of the master-detail block:.
Q 9 What are the various configuration files that are used by Oracle Forms? Using the above config files, a user can specify different parameters for the forms as per the requirement. Q 10 What do we mean by record group in Oracle Forms? Answer: A record group is a framework of rows and columns within the Oracle Forms similar to a table in the Oracle database.
Q 11 What is an Oracle Report? List its various types. Answer: Oracle Report is a tool provided by Oracle Fusion Middleware, which is used to generate reports based on the data stored in the Oracle database. Q 12 What is an implicit anchor and how is it a different form explicit anchor in a report builder?
Answer: An anchor is used to determine the position of an object in horizontal and vertical directions.
This position of an object will always be relative to the position of the other objects, which can be called parent objects for these child objects.
During runtime, an implicit anchor will be generated by the Oracle Forms Builder for each layout object, which is not holding an explicit anchor.
The implicit anchor will be created during the runtime of a report while explicit anchors are created by a user explicitly. Q 13 Name different triggers supported by Oracle Reports and their firing order.
Q 14 What is the difference between bind and lexical parameter? Q 15 List the different types of columns in Oracle Reports. Answer: There are three types of columns in Oracle reports. They are:. Q 16 What is a User exit program in Oracle Reports? Answer: User exit is a program that is written to perform some relevant action.
They can be called from report triggers and once executed, it gives back the control to Report Builder. Q 18 What is the difference between flex mode and confined mode? Answer: Confined mode, if set restricts the child object within enclosing parent objects. If not set on, the child objects can move out of parent objects. During flex mode, parent objects will adjust its border if the child object expands or moves.
If not set, parent borders stay fixed when the child objects move. Q 19 What is a matrix report and how many minimum groups are required to prepare the same? Answer: A matrix is a kind of report that looks like an information grid with one row of labels and one column of columns. At least 4 groups are required in the data model to prepare a matrix report. Q 20 Is it possible to have multiple layouts in a report? Answer: Yes, it is possible to have multiple layouts. We can use an additional layout option in the layout editor tool.
I hope the above article will help you to prepare for your interview and increase your knowledge of the concept of Oracle Forms and Reports. Last Updated: April 16, Recommended Reading Interview Questions and Answers.
50 TOP Real Time Oracle D2K Interview Questions and Answers pdf download
In Oracle reports only 2 parameters 1. Bind parameter replaces single value in SQL, it is prefixed with :symbol 2. Bind variables are used for replacing the single parameter in the select statement, where as Lexical Parameter is used to replace the where, order by conditions at run time. If the number of records returned by cursor is more, it results in a performance issue. It is advised to use collections in this case. Stacked canvas is load above content canvas, which is used for popup windows. We can show additional details for example if you want to show the customer details while click details button.
Report Triggers :-
Oracle forms are usually used for developing screens which interact with the database. It was developed in order to run server-side in character mode terminal sessions. The main focus of having Oracle forms is to have data entry of systems that access the Oracle database. Interviews for Oracle have questions related to Oracle Forms. Below are a few questions which can be asked in an interview and will help you clear it.