Posted by admin on July 31, 2009 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 ?
Add A Comment
You must be logged in to post a comment.