ORACLE Interview Questions for Preparations Part 2

on 8:34 AM

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

0 comments:

Post a Comment