201⟩ What is a User_exit?
Calls the user exit named in the user_exit_string. Invokes a 3Gl program by name which has been properly linked into your current oracle forms executable.
Database Administrator (DBA)
Home Databases Programming Database Administrator (DBA)
“If you a Database Administrator and need to update DBA technical knowledge or need to prepare for a job interview? Then you are at eht right place explore this collection of DATABASE Administrator (DBA) Interview Questions and Answers here. This DBA Interview Questions and Answers are basic and advance level so every one who is DBA can get more help with these database interview questions and answers tutorial and guide.”
253 Database Administrator (DBA) Questions And Answers
202⟩ How can a text file be attached to a report while creating in the report writer?
By using the link file property in the layout boiler plate property sheet.
203⟩ How can a square be drawn in the layout editor of the report writer?
By using the rectangle tool while pressing the (Constraint) key.
204⟩ How can values be passed between precompiler exits & Oracle call interface?
By using the statement EXECIAFGET & EXECIAFPUT.
205⟩ How is it possible to select generate a select set for the query in the query property sheet?
By using the tables/columns button and then specifying the table and the column names.
206⟩ How can I message to passed to the user from reports?
By using SRW.MESSAGE function.
207⟩ How is possible to restrict the user to a list of values while entering values for parameters?
By setting the Restrict To List property to true in the parameter property sheet.
208⟩ What are different types of images?
Boiler plate images, Image Items
209⟩ How can a button be used in a report to give a drill down facility?
By setting the action associated with button to Execute pl/SQL option and using the SRW.Run_report function.
210⟩ How can a cross product be created?
By selecting the cross products tool and drawing a new group surrounding the base group of the cross products.
211⟩ What is the difference between boiler plat images and image items?
Boiler plate Images are static images (Either vector or bit map) that you import from the file system or database to use a graphical elements in your form, such as company logos and maps. Image items are special types of interface controls that store and display either vector or bitmap images. Like other items that store values, image items can be either base table items (items that relate directly to database columns) or control items. The definition of an image item is stored as part of the form module FMB and FMX files, but no image file is actually associated with an image item until the item is populate at run time.
212⟩ What is bind reference and how can it be created?
Bind reference are used to replace the single value in sql, pl/sql statements a bind reference can be created using a (:) before a column or a parameter name.
213⟩ What are the triggers available in the reports?
Before report, Before form, After form , Between page, After report.
214⟩ Give the sequence of execution of the various report triggers?
Before form , After form , Before report, Between page, After report.
215⟩ Why is a Where clause faster than a group filter or a format trigger?
Because in a where clause the condition is applied during data retrieval, then after retrieving the data.
216⟩ Why is it preferable to create a fewer no. of queries in the data model?
Because for each query, report has to open a separate cursor and has to rebind, execute and fetch data.
217⟩ Where is the external query executed at the client or the server?
At the server.
218⟩ Where is a procedure return in an external pl/SQL library executed at the client or at the server?
At the client.
219⟩ What is coordination Event?
Any event that makes a different record in the master block the current record is a coordination causing event.
220⟩ What is the difference between OLE Server & OLE Container?
An Ole server application creates ole Objects that are embedded or linked in ole Containers ex. Ole servers are ms_word & ms_excel. OLE containers provide a place to store, display and manipulate objects that are created by ole server applications. Ex. oracle forms is an example of an ole Container.
