What is a difference between pre-select and pre-

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

353. What is a difference between pre-select and pre-query?

Fires during the execute query and count query processing after oracle forms constructs the select statement to be issued, but before the statement is actually issued. The pre-query trigger fires just before oracle forms issues the select statement to the database after the operator as define the example records by entering the query criteria in enter query mode. Pre-query trigger fires before pre-select trigger.

(Continued on next question...)

Other Job Interview Questions

• How can a group in a cross products be visually distinguished from a group that does not form a cross product?
• Can a Tablespace hold objects from different Schemes?
• I know the nvl function only allows the same data type(ie. number or char or date Nvl(comm, 0)), if commission is null then the text ?Not Applicable? want to display, instead of blank space. How do I write the query?
• What are the different type of Segments?
• When should you increase copy latches? What parameters control copy latches?
• What cursor type do you use to retrieve multiple recordsets?
• What?s the command to see the current user name?
• How can you Enforce Referential Integrity in snapshots?
• What are the uses of rollback segment?
• How would you determine the time zone under which a database was operating?
• More...