What is scrollable cursor?The use of HAVING, WHERE and GROUPBY in one SQL?What is SORTING and GROUPING?What are the different types of OUTER JOINS?Explain the UNION operation in SQL . What is meant by

What is Log Switch? - The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch. What is On-line Redo Log? - The On-line Redo Log is a set

What does ROLLBACK do? - ROLLBACK retracts any of the changes resulting from the SQL statements in the transaction. What is SAVE POINT? - For long transactions that contain many SQL statements, interm

What are the dictionary tables used to monitor a database spaces? - DBA_FREE_SPACE DBA_SEGMENTS DBA_DATA_FILES. What are the roles and user accounts created automatically with the database? - DBA - ro

Is the After report trigger fired if the report execution fails? - Yes. Does a Before form trigger fire when the parameter form is suppressed? - Yes. Is it possible to split the print reviewer into mo

What is a timer? - Timer is an “internal time clock” that you can programmatically create to perform an action each time the times. What are the two phases of block coordination? - There are two phase

How do you call other Oracle Products from Oracle Forms? - Run_product is a built-in, Used to invoke one of the supported oracle tools products and specifies the name of the document or module to be r

What are the different default triggers created when Master Deletes Property is set to Non-isolated? - Master Deletes Property Resulting Triggers: Non-Isolated (the default) On-Check-Delete-Master On-

What are different types of modules available in oracle form? - Form module - a collection of objects and code routines Menu modules - a collection of menus and menu item commands that together make u

What are different types of images? - Boiler plate images, Image Items What is the difference between boiler plat images and image items? - Boiler plate Images are static images (Either vector or bit