Posted by admin on July 31, 2009 under Interviews | 
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?
Posted by admin on under Interviews |
At what point of report execution is the before Report trigger fired?
How can a group in a cross products be visually distinguished from a group that does not form a cross product?
How can one dump internal database structures? (for DBA)
How does one create a RMAN recovery catalog? (for DBA)
How does Space allocation table place within a block ?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
How to implement the multiple control files for an existing database ?
How will you create multiple rollback segments in a database ?
How will you estimate the space required by a non-clustered tables?
How will you force database to use particular rollback segment ?
How will you monitor rollback segment status ?
How will you monitor the space allocation ?
How will you swap objects into a different table space for an existing database ?
It is possible to use raw devices as data files and what is the advantages over file. system files ?
I’ve lost my REDOLOG files, how can I get my DB back? (for DBA)
I’ve lost some Rollback Segments, how can I get my DB back? (for DBA)
List the Optional Flexible Architecture (OFA) of Oracle database? or How can we organize the tablespaces in Oracle database to have maximum performance ?
My database is down and I cannot restore. What now? (for DBA )
My database was terminated while in BACKUP MODE, do I need to recover? (for DBA)
To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?
What are disadvantages of having raw devices ?
What are the built -ins used for Modifying a groups structure?
What are the default extensions of the files created by forms modules?
What are the default extensions of the files created by menu module?
What are the differences between EBU and RMAN? (for DBA)
What are the different kind of export backups?
What are the different methods of backing up oracle database ?
What are the factors causing the reparsing of SQL statements in SGA?
What are the two panes that Appear in the design time pl/sql interpreter?
What are the two ways by which data can be generated for a parameters list of values?
What are the various methods of performing a calculation in a report ?
What are three panes that appear in the run time pl/sql interpreter?
What database events can be set? (for DBA)
What is a combo box?
What is a Control file ?
What is a database EVENT and how does one set it? (for DBA)
What is a logical backup?
What is a physical page ? & What is a logical page ?
What is a property clause?
What is a record group?
What is a Rollback segment entry ?
What is a Shared SQL pool?
What is a Static Record Group?
What is advantage of having disk shadowing/ Mirroring ?
What is an LOV?
What is an object group?
What is an user exit used for?
What is cold backup? What are the elements of it?
What is coordination Event?
What is Database Buffers ?
What is dictionary cache ?
What is hot backup and how it can be taken?
What is meant by free extent ?
What is meant by recursive hints ?
What is meant by redo log buffer ?
What is meant by Redo Log file mirroring ? How it can be achieved?
What is the difference between locks, latches, enqueues and semaphores? (for DBA)
What is the difference between OLE Server & Ole Container?
What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?
What is the frame & repeating frame?
What is the significance of having storage clause ?
What is the use of ANALYSE ( Ver 7) option in EXP command ?
What is the use of COMPRESS option in EXP command ?
What is the use of CONSISTENT (Ver 7) option in EXP command ?
What is the use of CONSTRAINTS option in EXP command ?
What is the use of FILE option in IMP command ?
What is the use of FULL option in EXP command ?
What is the use of GRANT option in EXP command?
What is the use of GRANT option in IMP command ?
What is the use of IGNORE option in IMP command ?
What is the use of INCTYPE option in EXP command ?
What is the use of INDEXES option in EXP command ?
What is the use of INDEXES option in IMP command ?
What is the use of PARFILE option in EXP command ?
What is the use of RECORD LENGTH option in EXP command ?
What is the use of RECORD option in EXP command?
What is the use of ROWS option in EXP command ?
What is the use of ROWS option in IMP command ?
What is the use of SHOW option in IMP command ?
What is the User-Named Editor?
When is PRE-QUERY trigger executed ?
Where can one get a list of all hidden Oracle parameters? (for DBA)
Where is a procedure return in an external pl/sql library executed at the client or at the server?
Where is the external query executed at the client or the server?
Which parameter in Storage clause will reduce no. of rows per block?
Why query fails sometimes ?
Posted by admin on under Interviews |
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
Atleast how many set of data must a data model have before a data model can be base on it?
Can one export to multiple files?/ Can one beat the Unix 2 Gig limit? (for DBA)
Can one import/export between different versions of Oracle? (for DBA)
Can you pass data parameters to forms?
Do user parameters appear in the data modal editor in 2.5?
Does a grouping done for objects in the layout editor affect the grouping done in the data model editor?
Does one need to drop/ truncate objects before importing? (for DBA)
From which designation is it preferred to send the output to the printed?
Give the sequence of execution of the various report triggers?
h of the above methods is the faster method?
How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?
How can a button be used in a report to give a drill down facility?
How can a square be drawn in the layout editor of the report writer?
How can a text file be attached to a report while creating in the report writer?
How can I message to passed to the user from reports?
How can one improve Import/ Export performance? (for DBA)
How can values be passed bet. precompiler exits & Oracle call interface?
How do you reference a Parameter?
How does one add users to a password file? (for DBA )
How does one connect to an administrative user? (for DBA )
How does one create a password file? (for DBA )
How is it possible to select generate a select set for the query in the query property sheet?
How is link tool operation different bet. reports 2 & 2.5?
How many windows in a form can have console?
If a break order is set on a column would it affect columns which are under the column?
Is it possible to link two groups inside a cross products after the cross products group has been created?
Is it possible to modify an external query in a report which contains it?
Name of the functions used to get/set canvas properties?
To execute row from being displayed that still use column in the row which property can be used?
Use the Add_group_row procedure to add a row to a static record group 1. true or false?
What are built-ins associated with timers?
What are built-ins used for Processing rows?
What are difference between post database commit and post-form commit?
What are different types of canvas views?
What are different types of images?
What are different types of modules available in oracle form?
What are modal windows?
What are parameters?
What are the built-in used for getting cell values?
What are the built-ins that are used for setting the LOV properties at runtime?
What are the built-ins used for Creating and deleting groups?
What are the built-ins used for finding object ID functions?
What are the built-ins used for Getting cell values?
What are the built-ins used for processing rows?
What are the common Import/ Export problems? (for DBA )
What are the default parameter that appear at run time in the parameter screen? What are the various sub events a mouse double click event involves?
What are the difference between lov & list item?
What are the different default triggers created when Master Deletes Property is set to Cascade?
What are the different default triggers created when Master Deletes Property is set to isolated?
What are the different default triggers created when Master Deletes Property is set to Non-isolated?
What are the different display styles of list items?
What are the different modals of windows?
What are the different styles of activation of ole Objects?
What are the different types of Delete details we can establish in Master-Details?
What are the different types of Record Groups?
What are the master-detail triggers?
What are the three types of user exits available ?
What are the two repeating frame always associated with matrix object?
What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?
What database aspects should be monitored? (for DBA)
What is a difference between pre-select and pre-query?
What is a Text_io Package?
What is a User_exit?
What is an administrative (privileged) user? (for DBA )
What is bind reference and how can it be created?
What is forms_DDL?
What is lexical reference? How can it be created?
What is relation between the window and canvas views?
What is synchronize?
What is system.coordination_operation?
What is the advantage of the library?
What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?
What is the difference between object embedding & linking in Oracle forms?
What is the Maximum allowed length of Record group Column?
What is the remove on exit property?
What is the use of hidden column? What are the various sub events a mouse double click event involves?
What is the use of place holder column? What are the various sub events a mouse double click event involves?
What is WHEN-Database-record trigger?
What third party tools can be used with Oracle EBU/ RMAN? (for DBA)
What use of command line parameter cmd file?
Where should the tuning effort be directed? (for DBA)
Which parameter can be used to set read level consistency across multiple queries?
Why and when should one tune? (for DBA)
Why are OPS$ accounts a security risk in a client/server environment? (for DBA)
Why is it preferable to create a fewer no. of queries in the data model?
With which function of summary item is the compute at options required?
