When A Query Is Sent To The Database And An Index Is Not Being Used, What Type Of Execution Is Taking Place? This is useful to ensure data integrity when referential integrity constraints aren’t appropriate, or when table check constraints limit checking to the current table only. to check against other data in the table or in other tables.This is useful for maintaining relationships between data or in keeping audit trail information. to run other non-database operations coded in user-defined functions.This is useful if you need to transform data from the way the user sees it to some internal database format. to check or modify values before they are actually updated or inserted in the database.Triggers enhance the security, efficiency, and standardization of databases. What Are The Pros And Cons Of Using Triggers?Ī trigger is one or more statements of SQL that are being executed in event of data modification in a table to which the trigger belongs. You learn more about the process of database creation, such as what options are available and why. You can log the output and review it for errors. You can put your create database script in CVS for version control, so as you make changes or adjustments to it, you can track them like you do changes to software code.

You can script the process to include it in a set of install scripts you deliver with a product. What Are Some Advantages To Using Oracle's Create Database Statement To Create A New Database Manually? A UNION ALL conversely just dumps collection of both sets together in random order, not worrying about duplicates. This is obviously computationally intensive, and uses significant memory as well. To perform this feat of magic, a SORT operation is done on both tables.

It will *NOT* however produce duplicate or redundant rows. The union operation, you will recall, brings two sets of data together. The g stands for 'grid' to indicate that 10g is 'grid-computing ready'. Oracle 10g is a version of the Oracle Database.

Oracle 10g certification questions