I've lost some Rollback Segments, how can I get my DB back? (for DBA

ORACLE Interview Questions and Answers (Part 2)

(Continued from previous question...)

283. I've lost some Rollback Segments, how can I get my DB back? (for DBA

Re-start your database with the following INIT.ORA parameter if one of your rollback segments is corrupted. You can then drop the corrupted rollback segments and create it from scratch.
Caution is advised when enabling this parameter, as uncommitted transactions will be marked as committed. One can very well end up with lost or inconsistent data!!! Please contact Oracle Support before using it. _Corrupted_rollback_segments = (rbs01, rbs01, rbs03, rbs04)

(Continued on next question...)

Other Interview Questions

• 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 ?