Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?
by

1 Answer

Answer :

It is not possible. As triggers are defined for each table, if you use
COMMIT of ROLLBACK in a trigger, it affects logical transaction
processing.
by

Related questions

Can you use a commit statement within a database trigger?

Description : Can you use a commit statement within a database trigger?

Last Answer : No

In SQL, the CREATE TABLESPACE isused A. to createa place in the databasefor storageof scheme objects, rollback segments, andnaming the data files to comprise the tablespace B. to createa database trigger C. to add/rename data files, to change storage D. All of theabove E. None of the above

Description : In SQL, the CREATE TABLESPACE isused A. to createa place in the databasefor storageof scheme objects, rollback segments, andnaming the data files to comprise the tablespace B. to createa database trigger C. to add/rename data files, to change storage D. All of theabove E. None of the above

Last Answer : to createa place in the databasefor storageof scheme objects, rollback segments, andnaming the data files to comprise the tablespace

How will you force database to use particular rollback segment ?

Description : How will you force database to use particular rollback segment ?

Last Answer : SET TRANSACTION USE ROLLBACK SEGMENT rbs_name.

How will you create multiple rollback segments in a database ?

Description : How will you create multiple rollback segments in a database ?

Last Answer : Create a database which implicitly creates a SYSTEM Rollback Segment in a SYSTEM tablespace. Create a Second Rollback Segment name R0 in the SYSTEM tablespace. Make new rollback segment ... ) for rollback segments. Deactivate Rollback Segment R0 and activate the newly created rollback segments.

what are difference between post database commit and post-form commit?

Description : what are difference between post database commit and post-form commit?

Last Answer : Post-form commit fires once during the post and commit transactions process, after the database commit occurs. The post-form-commit trigger fires after inserts, updates and deletes have ... The post-database-commit trigger fires after oracle forms issues the commit to finalized transactions.

Can U disable database trigger? How?

Description : Can U disable database trigger? How?

Last Answer : Yes. With respect to table ALTER TABLE TABLE [[ DISABLE all_trigger ]]

What is Database Trigger ?

Description : What is Database Trigger ?

Last Answer : A Database Trigger is procedure (set of SQL and PL/SQL statements) that is automatically executed as a result of an insert in,update to, or delete from a table.

What are the uses of Database Trigger ?

Description : What are the uses of Database Trigger ?

Last Answer : Database triggers can be used to automatic data generation, audit data modifications, enforce complex Integrity constraints, and customize complex security authorizations.

What is a database trigger ? Name some usages of database trigger ?

Description : What is a database trigger ? Name some usages of database trigger ?

Last Answer : Database trigger is stored PL/SQL program unit associated with a specific database table. Usages are Audit data modifications, Log events transparently, Enforce complex business rules Derive column values automatically, Implement complex security authorizations. Maintain replicate tables.

What are two virtual tables available during database trigger execution ?

Description : What are two virtual tables available during database trigger execution ?

Last Answer : The table columns are referred as OLD.column_name and NEW.column_name. For triggers related to INSERT only NEW.column_name values only available. For triggers related to UPDATE only OLD. ... values only available. For triggers related to DELETE only OLD.column_name values only available.

What is WHEN-Database-record trigger?

Description : What is WHEN-Database-record trigger?

Last Answer : Fires when oracle forms first marks a record as an insert or an update. The trigger fires as soon as oracle forms determines through validation that the record should be processed by the next post or ... the first item in the record, and after the operator attempts to navigate out of the item.

What is database Trigger?

Description : What is database Trigger?

Last Answer : A database trigger is a PL/SQL block that can defined to automatically execute for insert, update, and delete statements against a table. The trigger can e defined to execute once for the ... define database triggers. A database trigger can call database procedures that are also written in PL/SQL.

Point out the wrong statement. a) Taken as a unit, “Request => Process => Response” is not an atomic transaction b) A coherent transaction either succeeds and is enacted, or fails and is rolled back c) When rollback is not possible due to optimistic transaction commitment in a multiuser application, durability requires correcting the condition d) None of the mentioned

Description : Point out the wrong statement. a) Taken as a unit, Request => Process => Response is not an atomic transaction b) A coherent transaction either succeeds and is enacted, or ... transaction commitment in a multiuser application, durability requires correcting the condition d) None of the mentioned

Last Answer : Taken as a unit, “Request => Process => Response” is not an atomic transaction

What are the uses of rollback segment?

Description : What are the uses of rollback segment?

Last Answer : A database contains one or more rollback segments to temporarily store "undo" information.

What are the uses of rollback segment?

Description : What are the uses of rollback segment?

Last Answer : A database contains one or more rollback segments to temporarily store "undo" information.

What is rollback segment?

Description : What is rollback segment?

Last Answer : A database contains one or more rollback segments to temporarily store "undo" information.

What is a Rollback segment entry ?

Description : What is a Rollback segment entry ?

Last Answer : It is the set of before image data blocks that contain rows that are modified by a transaction. Each Rollback Segment entry must be completed within one rollback segment. A single rollback segment can have multiple rollback segment entries.

How will you monitor rollback segment status ?

Description : How will you monitor rollback segment status ?

Last Answer : Querying the DBA_ROLLBACK_SEGS view IN USE - Rollback Segment is on-line. AVAILABLE - Rollback Segment available but not on-line. OFF-LINE - Rollback Segment off-line INVALID - Rollback ... corupted. PARTLY AVAILABLE - Contains data from an unresolved transaction involving a distributed database.

I've lost some Rollback Segments, how can I get my DB back? (for DBA

Description : I've lost some Rollback Segments, how can I get my DB back? (for DBA

Last Answer : Re-start your database with the following INIT.ORA parameter if one of your rollback segments is corrupted. You can then drop the corrupted rollback segments and create it from scratch. ... Please contact Oracle Support before using it. _Corrupted_rollback_segments = (rbs01, rbs01, rbs03, rbs04)

What does ROLLBACK do ?

Description : What does ROLLBACK do ?

Last Answer : ROLLBACK retracts any of the changes resulting from the SQL statements in the transaction.

What is Rollback Segment ?

Description : What is Rollback Segment ?

Last Answer : A Database contains one or more Rollback Segments to temporarily store "undo" information.

What are the options to directly raise an event to trigger an event-dependent job? Note: there are 2 correct answered to this question A. Execute program sapxpg on operating system level B. Execute program sapevt on operating system level C. Execute transaction CCMS Control Panel (RZ03) D. Execute the ABAP program BTC_EV,NT_RAISE

Description : What are the options to directly raise an event to trigger an event-dependent job? Note: there are 2 correct answered to this question A. Execute program sapxpg on operating system level B. ... level C. Execute transaction CCMS Control Panel (RZ03) D. Execute the ABAP program BTC_EV,NT_RAISE

Last Answer : D. Execute the ABAP program BTC_EV,NT_RAISE

What is a 2 Phase Commit

Description : What is a 2 Phase Commit

Last Answer : Two Phase commit is used in distributed data base systems. This is useful to maintain the integrity of the database so that all the users see the same values. It contains DML statements or Remote ... b) Commit Phase :: Commit all participants to coordinator to Prepared, Read only or abort Reply

What will happen after commit statement ?

Description : What will happen after commit statement ?

Last Answer : Cursor C1 is Select empno, ename from emp; Begin open C1; loop Fetch C1 into eno.ename; Exit When C1 %notfound;----- commit; end loop; end; The cursor having query as SELECT .... FOR ... after COMMIT/ROLLBACK. The cursor having query as SELECT.... does not get closed even after COMMIT/ROLLBACK.

Describe two phases of Two-phase commit ?

Description : Describe two phases of Two-phase commit ?

Last Answer : Prepare phase - The global coordinator (initiating node) ask a participants to prepare (to promise to commit or rollback the transaction, even if there is a failure) Commit - Phase - If ... , if all participants cannot prepare, the coordinator asks all nodes to roll back the transaction.

What is Two-Phase Commit ?

Description : What is Two-Phase Commit ?

Last Answer : Two-phase commit is mechanism that guarantees a distributed transaction either commits on all involved nodes or rolls back on all involved nodes to maintain data consistency across the global distributed database. It has two phase, a Prepare Phase and a Commit Phase.

What does COMMIT do ?

Description : What does COMMIT do ?

Last Answer : COMMIT makes permanent the changes resulting from all SQL statements in the transaction. The changes made by the SQL statements of a transaction become visible to other user sessions transactions that start only after transaction is committed.

When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

Description : When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

Last Answer : Break. SYSTEM VARIABLES

Can we use GO-BLOCK package in a pre-field trigger ?

Description : Can we use GO-BLOCK package in a pre-field trigger ?

Last Answer : No

Can we use a restricted package procedure in ON- VALIDATE-FIELD Trigger ?

Description : Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?

Last Answer : No

Which trigger related to mouse?

Description : Which trigger related to mouse?

Last Answer : When-Mouse-Click When-Mouse-DoubleClick When-Mouse-Down When-Mouse-Enter When-Mouse-Leave When-Mouse-Move When-Mouse-Up

What is transactional trigger property?

Description : What is transactional trigger property?

Last Answer : Identifies a block as transactional control block. i.e. non - database block that oracle forms should manage as transactional block.(NON- ORACLE datasource) default - FALSE.

If you have property class attached to an item and you have same trigger written for the item . Which will fire first?

Description : If you have property class attached to an item and you have same trigger written for the item . Which will fire first?

Last Answer : Item level trigger fires , If item level trigger fires, property level trigger won't fire. Triggers at the lowest level are always given the first preference. The item level trigger fires first and then the block and then the Form level trigger.

What are property classes ? Can property classes have trigger?

Description : What are property classes ? Can property classes have trigger?

Last Answer : Property class inheritance is a powerful feature that allows you to quickly define objects that conform to your own interface and functionality standards. Property classes also allow you to make global ... all objects that inherit properties from that class. Yes . All type of triggers .

Which trigger are created when master -detail rela?

Description : Which trigger are created when master -detail rela?

Last Answer : master delete property * NON-ISOLATED (default) a) on check delete master b) on clear details c) on populate details * ISOLATED a) on clear details b) on populate details * CASCADE a) per-delete b) on clear details c) on populate details

What is a Trigger ?

Description : What is a Trigger ?

Last Answer : A piece of logic that is executed at or triggered by a SQL *forms event.

What is the difference between a Function Key Trigger and Key Function Trigger ?

Description : What is the difference between a Function Key Trigger and Key Function Trigger ?

Last Answer : Function key triggers are associated with individual SQL*FORMS function keys You can attach Key function triggers to 10 keys or key sequences that normally do not perform any SQL * FORMS operations. These keys referred as key F0 through key F9.

What does an on-clear-block Trigger fire?

Description : What does an on-clear-block Trigger fire?

Last Answer : It fires just before SQL * forms the current block.

Is a Key startup trigger fires as result of a operator pressing a key explicitly ?

Description : Is a Key startup trigger fires as result of a operator pressing a key explicitly ?

Last Answer : No

What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?

Description : What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?

Last Answer : On-validate-field trigger fires, when the field Validation status New or changed. Post-field-trigger whenever the control leaving form the field, it will fire.

A query fetched 10 records How many times does a PRE- QUERY Trigger and POST-QUERY Trigger will get executed ?

Description : A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?

Last Answer : PRE-QUERY fires once. POST-QUERY fires 10 times.

When is PRE-QUERY trigger executed ?

Description : When is PRE-QUERY trigger executed ?

Last Answer : When Execute-query or count-query Package procedures are invoked.

What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?

Description : What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?

Last Answer : When you changes the Existing value to null, the On-validate field trigger will fire post change trigger will not fire. At the time of execute- query post-change trigger will fire, on-validate field trigger will not fire.

At what point of report execution is the before Report trigger fired?

Description : At what point of report execution is the before Report trigger fired?

Last Answer : After the query is executed but before the report is executed and the records are displayed.

What are the trigger associated with image items?

Description : What are the trigger associated with image items?

Last Answer : When-image-activated fires when the operators double clicks on an image itemwhen-image-pressed fires when an operator clicks or double clicks on an image item

What is trigger associated with the timer?

Description : What is trigger associated with the timer?

Last Answer : When-timer-expired.

Does a Before form trigger fire when the parameter form is suppressed?

Description : Does a Before form trigger fire when the parameter form is suppressed?

Last Answer : Yes.

Is the After report trigger fired if the report execution fails?

Description : Is the After report trigger fired if the report execution fails?

Last Answer : Yes.

Is it possible to backup your database without the use of an RMAN database to store the catalog?

Description : Is it possible to backup your database without the use of an RMAN database to store the catalog?

Last Answer : Yes, but the catalog would be stored in the controlfile.

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

Description : You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

Last Answer : I would create a text based backup control file, stipulating where on disk all the data files where and then issue the recover command with the using backup control file clause.