Interview Questions : ORACLE 500 Interview Questions Page 9

401. What are the different types of Package Procedure ? 1. Restricted package procedure. 2. Unrestricted package procedure.

402. What are the types of TRIGGERS ? 1. Navigational Triggers. 2. Transaction Triggers.

403. Identify package function from the following ? 1. Error-Code 2. Break 3. Call 4. Error-text 5. Form-failure 6. Form-fatal 7. Execute-query 8. Anchor View 9. Message_code? 1. Error_Code 2. Error_Text 3. Form_Failure 4. Form_Fatal 5. Message_Code

403. Can you attach an lov to a field at run-time? if yes, give the build-in name.? Yes. Set_item_proprety

404. Is it possible to attach same library to more than one form? Yes

405. Can you attach an lov to a field at design time? Yes

406. List the windows event triggers available in Forms 4.0? When-window-activated, when-window-closed, when-window-deactivated, when-window-resized

407. What are the triggers associated with the image item? When-Image-activated(Fires when the operator double clicks on an image Items) When-image-pressed(fires when the operator selects or deselects the image item)

408. What is a visual attribute? Visual Attributes are the font, color and pattern characteristics of objects that operators see and intract with in our application.

409. How many maximum number of radio buttons can you assign to a radio group? Unlimited no of radio buttons can be assigned to a radio group

410. How do you pass the parameters from one form to another form? To pass one or more parameters to a called form, the calling form must perform the following steps in a trigger or user named routine execute the create_parameter_list built-in function to programmatically. Create a parameter list to execute the add parameter built-in procedure to add one or more parameters list. Execute the call_form, New_form or run_product built_in procedure and include the name or id of the parameter list to be passed to the called form.

411. What is a Layout Editor? The Layout Editor is a graphical design facility for creating and arranging items and boilerplate text and graphics objects in your application's interface.

412. List the Types of Items? Text item. Chart item. Check box. Display item. Image item. List item. Radio Group. User Area item.

413. List system variables available in forms 4.0, and not available in forms 3.0? System.cordination_operation System Date_threshold System.effective_Date System.event_window System.suppress_working

414. What are the display styles of an alert? Stop, Caution, note

415. What built-in is used for showing the alert during run-time? Show_alert.

416. What built-in is used for changing the properties of the window dynamically? Set_window_property Canvas-View

417. What are the different types of windows? Root window, secondary window.

418. What is a predefined exception available in forms 4.0? Raise form_trigger_failure

419. What is a radio Group? Radio groups display a fixed no of options that are mutually Exclusive. User can select one out of n number of options.

419. What are the different type of a record group? Query record group Static record group Non query record group

420. What are the menu items that oracle forms 4.0 supports? Plain, Check,Radio, Separator, Magic

421. Give the equivalent term in forms 4.0 for the following. Page, Page 0? Page - Canvas-View Page 0 - Canvas-view null.

422. What triggers are associated with the radio group? Only when-radio-changed trigger associated with radio group Visual Attributes. 423. What are the triggers associated with a check box? Only When-checkbox-activated Trigger associated with a Check box. 424.Can you attach an alert to a field? No 425. Can a root window be made modal? No

426. What is a list item? It is a list of text elements.

427. List some built-in routines used to manipulate images in image_item? Image_add Image_and Image_subtract Image_xor Image_zoom 428. Can you change the alert messages at run-time? If yes, give the name of the built-in to change the alert messages at run-time. Yes. Set_alert_property. 429. What is the built-in used to get and set lov properties during run-time? Get_lov_property Set_lov_property Record Group 430. What is the built-in routine used to count the no of rows in a group? Get_group _row_count System Variables

431. Give the Types of modules in a form? Form Menu Library

432. Write the Abbreviation for the following File Extension 1. FMB 2. MMB 3. PLL? FMB ----- Form Module Binary. MMB ----- Menu Module Binary. PLL ------ PL/SQL Library Module Binary.

433. List the built-in routine for controlling window during run- time? Find_window, get_window_property, hide_window, move_window, resize_window, set_window_property, show_View

434. List the built-in routine for controlling window during run- time? Find_canvas Get-Canvas_property Get_view_property Hide_View Replace_content_view Scroll_view Set_canvas_property Set_view_property Show_view Alert

435. What is the built-in function used for finding the alert? Find_alert Editors

436. List the editors availables in forms 4.0? Default editor User_defined editors system editors.

437. What buil-in routines are used to display editor dynamicaly? Edit_text item show_editor LOV

438. What is an Lov? A list of values is a single or multi column selection list displayed in a pop-up window

439. What is a record Group? A record group is an internal oracle forms data structure that has a similar column/row frame work to a database table 440. Give built-in routine related to a record groups? Create_group (Function) Create_group_from_query(Function) Delete_group(Procedure) Add_group_column(Function) Add_group_row(Procedure) Delete_group_row(Procedure) Populate_group(Function) Populate_group_with_query(Function) Set_group_Char_cell(procedure)

441. List the built-in routines for the controlling canvas views during run-time? Find_canvas Get-Canvas_property Get_view_property Hide_View Replace_content_view Scroll_view Set_canvas_property Set_view_property Show_view Alert

442. System.effective_date system variable is read only True/False? False

443. What are the built_in used to trapping errors in forms 4? Error_type return character Error_code return number Error_text return char Dbms_error_code return no. Dbms_error_text return char

444. what is a display item? Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains. 445. What are the design facilities available in forms 4.0? Default Block facility. Layout Editor. Menu Editor. Object Lists. Property Sheets. PL/SQL Editor. Tables Columns Browser. Built-ins Browser. 446. What are the types of visual attribute settings? Custom Visual attributes Default visual attributes Named Visual attributes. Window

447. What are the types of canvas-views? Content View, Stacked View. 448. What are the two ways to incorporate images into a oracle forms application? Boilerplate Images Image_items

449. What do you mean by a block in forms4.0? Block is a single mechanism for grouping related items into a functional unit for storing, displaying and manipulating records.

450. Explain types of Block in forms4.0? Base table Blocks. Control Blocks. 1. A base table block is one that is associated with a specific database table or view. 2. A control block is a block that is not associated with a database table. ITEMS

Page: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10

«Previous            Next»