Jul 31 2009 in Interviews

Oracle Interview Questions – Part E





-- Sponsored Ads -- 



-- Sponsored Ads -- 



  • A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?
  • Can a root window be made modal?
  • Can we create two blocks with the same name in form 3.0 ?
  • Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?
  • Can we use GO-BLOCK package in a pre-field trigger ?
  • Can you attach an alert to a field?
  • Can you attach an lov to a field at design time?
  • Can you attach an lov to a field at run-time? if yes, give the build-in name.?
  • Can you change the alert messages at run-time?
  • Committed block sometimes refer to a BASE TABLE ?
  • Deleting a page removes information about all the fields in that page ?
  • Error_Code is a package proecdure ?
  • EXIT_FORM is a restricted package procedure ?
  • Give the equivalent term in forms 4.0 for the following. Page, Page 0?
  • Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
  • Give the Types of modules in a form?
  • How can one optimize %XYZ% queries? (for DBA)
  • How do you control the constraints in forms ?
  • How do you pass the parameters from one form to another form?
  • How do you trap the error in forms 3.0 ?
  • How many maximum number of radio buttons can you assign to a radio group?
  • How many pages you can in a single form ?
  • Is a Key start up trigger fires as result of a operator pressing a key explicitly ?
  • Is it possible to attach same library to more than one form?
  • List some built-in routines used to manipulate images in image_item?
  • List system variables available in forms 4.0, and not available in forms 3.0?
  • List the built-in routine for controlling window during run-time?
  • List the built-in routine for controlling window during run-time?
  • List the editors available in forms 4.0?
  • List the system variables related in Block and Field?
  • List the Types of Items?
  • List the windows event triggers available in Forms 4.0?
  • My query was fine last week and now it is slow. Why? (for DBA)
  • Name the two files that are created when you generate the form give the filex extension ?
  • State the order in which these triggers are executed ?
  • Two popup pages can appear on the screen at a time ?Two popup pages can appear on the screen at a time ?
  • What are the different type of a record group?
  • What are the different types of key triggers ?
  • What are the different types of Package Procedure ?
  • What are the different types of windows?
  • What are the display styles of an alert?
  • What are the menu items that oracle forms 4.0 supports?
  • What are the triggers associated with a check box?
  • What are the triggers associated with the image item?
  • What are the type of User Exits ?
  • What are the types of Pop-up window ?
  • What are the types of TRIGGERS ?
  • What are the unrestricted procedures used to change the pop up screen position during run time ?
  • What built-in is used for changing the properties of the window dynamically?
  • What built-in is used for showing the alert during run-time?
  • What do you mean by a page ?
  • What does an on-clear-block Trigger fire?
  • What Enter package procedure does ?
  • What is a Layout Editor?
  • What is a list item?
  • What is a Package Procedure ?
  • What is a predefined exception available in forms 4.0?
  • What is a radio Group?
  • What is a Trigger ?
  • What is a visual attribute?
  • What is an Alert ?
  • What is an SQL *FORMS ?
  • What is an User Exits ?
  • What is the built-in function used for finding the alert?
  • What is the built-in routine used to count the no of rows in a group?
  • What is the built-in used to get and set lov properties during run-time?
  • What is the difference between a Function Key Trigger and Key Function Trigger ?
  • What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?
  • What is the difference between restricted and unrestricted package procedure ?
  • What is the difference between system.current_field and system.cursor_field ?
  • What is the maximum size of a form ?
  • What is the significance of PAGE 0 in forms 3.0 ?
  • What is the usage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ?
  • What package procedure used for invoke sql *plus from sql *forms ?
  • What the PAUSE package procedure does ?
  • What triggers are associated with the radio group?
  • When is cost based optimization triggered? (for DBA)
  • When should one rebuild an index? (for DBA)
  • Where can one find I/O statistics per table? (for DBA)
  • While specifying master/detail relationship between two blocks specifying the join condition is a must ?
  • Why is Oracle not using the damn index? (for DBA)
  • What built-in routines are used to display editor dynamically?
  • Share This Post

    This post was tagged with the following: , , , , , , ,

    Use the forms below to leave a comment. Name and e-Mail are required. e-Mail is never shared.

    You must be logged in to post a comment.