Oracle Interview Questions – Part C

Posted by admin on July 31, 2009 under Interviews | Be the First to Comment






  • 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?
  • Share This Post

    Add A Comment

    You must be logged in to post a comment.