How will you force database to use particular rollback segment ?

ORACLE Interview Questions and Answers (Part 2)

(Continued from previous question...)

306. How will you force database to use particular rollback segment ?

SET TRANSACTION USE ROLLBACK SEGMENT rbs_name.

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