Describe two phases of Two-phase commit ?

Describe two phases of Two-phase commit ?
by

1 Answer

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 all
participants respond to the coordinator that they are prepared, the
coordinator asks all nodes to commit the transaction, if all participants
cannot prepare, the coordinator asks all nodes to roll back the
transaction.
by

Related questions

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 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

Can you use a commit statement within a database trigger?

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

Last Answer : No

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.

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

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

Last 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.

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.

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.

What are the two phases of block coordination?

Description : What are the two phases of block coordination?

Last Answer : There are two phases of block coordination: the clear phase and the population phase. During, the clear phase, Oracle Forms navigates internally to the detail block and flushes the obsolete ... with the new master record. These operations are accomplished through the execution of triggers.

What are the different phases of transaction?

Description : What are the different phases of transaction?

Last Answer : Different phases are ∙ Analysis phase ∙ Redo Phase ∙ Undo phase

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 ... prepare b) Commit Phase : Commit all participants to coordinator to Prepared, Read only or abort Reply

Describe what redo logs are.

Description : Describe what redo logs are.

Last Answer : Redo logs are logical and physical structures that are designed to hold all the changes made to a database and are intended to aid in the recovery of a database.

Describe Referential Integrity ?

Description : Describe Referential Integrity ?

Last Answer : A rule defined on a column (or set of columns) in one table that allows the insert or update of a row only if the value for the column or set of columns (the dependent value) matches a value ... data and the action to be performed on dependent data as a result of any action on referenced data.

Describe the three levels of data abstraction?

Description : Describe the three levels of data abstraction?

Last Answer : There are three levels of abstraction: ∙ Physical level: The lowest level of abstraction describes how data are stored. ∙ Logical level: The next higher level of abstraction, describes what data are ... data. ∙ View level: The highest level of abstraction describes only part of entire database.

(4) Water drops in a dispersion medium of air Explanation: A colloid is a substance microscopically dispersed evenly throughout another substance. A colloidal system consists of two separate phases: a dispersed phase (or internal phase) and a continuous phase (or dispersion medium) in which the colloid is dispersed. A colloidal system may be solid, liquid, or gas. Cloud is a colloidal dispersion of Water drops in a dispersion medium of air.

Description : (4) Water drops in a dispersion medium of air Explanation: A colloid is a substance microscopically dispersed evenly throughout another substance. A colloidal system consists of two separate phases: a dispersed ... or gas. Cloud is a colloidal dispersion of Water drops in a dispersion medium of air.

Last Answer : Conduction band electrons have more mobility than holes because they – (1) are lighter (2) experience collision less frequently (3) have negative charge (4) need less energy to move them

(2) Fat is dispersed in water Explanation: A colloid is a substance microscopically dispersed evenly throughout another substance. A colloidal system consists of two separate phases: a dispersed phase (or internal phase) and a continuous phase (or dispersion medium) in which the colloid is dispersed. A colloidal system may be solid, liquid, or gas. Milk is an emulsified colloid of liquid butterfat globules dispersed within a water-based solution.

Description : (2) Fat is dispersed in water Explanation: A colloid is a substance microscopically dispersed evenly throughout another substance. A colloidal system consists of two separate phases: a dispersed ... Milk is an emulsified colloid of liquid butterfat globules dispersed within a water-based solution.

Last Answer : The presence of ozone in the stratosphere is responsible for – (1) increasing the average global temperature in recent years (2) higher rate of photosynthesis (3) checking the penetration of ultra-violet rays to the earth (4) supplying oxygen for people travelling in jets

(2) Fat is dispersed in water Explanation: A colloid is a substance microscopically dispersed evenly throughout another substance. A colloidal system consists of two separate phases: a dispersed phase (or internal phase) and a continuous phase (or dispersion medium) in which the colloid is dispersed. A colloidal system may be solid, liquid, or gas. Milk is an emulsified colloid of liquid butterfat globules dispersed within a water-based solution.

Description : (2) Fat is dispersed in water Explanation: A colloid is a substance microscopically dispersed evenly throughout another substance. A colloidal system consists of two separate phases: a dispersed ... Milk is an emulsified colloid of liquid butterfat globules dispersed within a water-based solution.

Last Answer : The presence of ozone in the stratosphere is responsible for – (1) increasing the average global temperature in recent years (2) higher rate of photosynthesis (3) checking the penetration of ultra-violet rays to the earth (4) supplying oxygen for people travelling in jets

A three-phase electrical system is equipped with ground detecting lamps. If one of the lamp goes dark and the other two burn normally before and after the test switch is operated, this indicates _______________. A. the dark lamp must be replaced B. there is a ground in the line with the dark lamp C. there are grounds in two of the three phases D. the voltage to the dark lamp is less than that of the system

Description : A three-phase electrical system is equipped with ground detecting lamps. If one of the lamp goes dark and the other two burn normally before and after the test switch is operated, this indicates _______________. ... of the three phases D. the voltage to the dark lamp is less than that of the system

Last Answer : Answer: A

To get high tray efficiency (A) Interfacial surface between liquid and gas phase should be large (B) Time of contact between the two phases should be less (C) Gas velocity should be very low (D) Liquid entrainment should be severe

Description : To get high tray efficiency (A) Interfacial surface between liquid and gas phase should be large (B) Time of contact between the two phases should be less (C) Gas velocity should be very low (D) Liquid entrainment should be severe

Last Answer : (A) Interfacial surface between liquid and gas phase should be large

The necessary and sufficient condition for equilibrium between two phases is (A) The concentration of each component should be same in the two phases (B) The temperature of each phase should be same (C) The pressure should be same in the two phases (D) The chemical potential of each component should be same in the two phases

Description : The necessary and sufficient condition for equilibrium between two phases is (A) The concentration of each component should be same in the two phases (B) The temperature of each phase should be same ( ... the two phases (D) The chemical potential of each component should be same in the two phases

Last Answer : (D) The chemical potential of each component should be same in the two phases

The reaction A (l) → R(g) is allowed to reach equilibrium conditions in an autoclave. At equilibrium, there are two phases, one a pure liquid phase of A and the other a vapor phase of A, R and S. Initially A alone is present. The numbers of degrees of freedom are: (A) 1 (B) 2 (C) 3 (D) 0

Description : The reaction A (l) → R(g) is allowed to reach equilibrium conditions in an autoclave. At equilibrium, there are two phases, one a pure liquid phase of A and the other a vapor phase of A, R and S. Initially A alone is present. The numbers of degrees of freedom are: (A) 1 (B) 2 (C) 3 (D) 0

Last Answer : (B) 2

One of the methods of purification of leach liquor is ion exchange, which involves (A) Exchange between two liquid phases (B) Exchange between a gaseous phase and a liquid phase (C) Exchange between a liquid phase and an organic resin phase (D) Exchange between a solid phase and a gas phase

Description : One of the methods of purification of leach liquor is ion exchange, which involves (A) Exchange between two liquid phases (B) Exchange between a gaseous phase and a liquid phase (C) Exchange between a liquid phase and an organic resin phase (D) Exchange between a solid phase and a gas phase

Last Answer : (C) Exchange between a liquid phase and an organic resin phase

If a system involves two phases, it is in ______ equilibrium when the mass of each phase reaches an equilibrium level and stays there.  A. Chemical  B. Thermal  C. Mechanical  D. Phase

Description : If a system involves two phases, it is in ______ equilibrium when the mass of each phase reaches an equilibrium level and stays there.  A. Chemical  B. Thermal  C. Mechanical  D. Phase

Last Answer : Phase

Given below is a schematic break-up of the phases/stages of cell cycle :- Which one of the following is the correct indication of the stage/phase in t

Description : Given below is a schematic break-up of the phases/stages of cell cycle :- Which one of the following is the correct indication of the stage/phase in t

Last Answer : Given below is a schematic break-up of the phases/stages of cell cycle :- Which one of the ... Metaphase C. C- Karyokinesis D. D- Synthesis phase

What are the phases of the cell cycle and what happens during each phase?

Description : What are the phases of the cell cycle and what happens during each phase?

Last Answer : What is the answer ?

Growth curve does not include following phases of bacteria – a. Decline phase b. Stationary phase c. Lag phase d. Synchronous growth

Description : Growth curve does not include following phases of bacteria – a. Decline phase b. Stationary phase c. Lag phase d. Synchronous growth

Last Answer : Ans: D

As shown in the illustration, which of the listed actions of the synchroscope pointer is occurring? EL-0002 A. Revolving slowly in the slow direction. B. Revolving rapidly in the slow direction. C. Revolving rapidly in the fast direction. D. It would be stationary at the 12 o'clock position since the leading edges of the A phases are in phase.

Description : As shown in the illustration, which of the listed actions of the synchroscope pointer is occurring? EL-0002 A. Revolving slowly in the slow direction. B. Revolving rapidly in the slow direction. C. ... stationary at the 12 o'clock position since the leading edges of the A phases are in phase.

Last Answer : Answer: C

In a three-phase electrical system, three ground detecting lamps are provided. If all three lamps REMAIN at half-brilliance when the ground detecting test switch is operated, ______________. A. there is a slight ground on all three phases B. the switch must be replaced C. there are no grounds present D. the light bulbs are of improper voltage

Description : In a three-phase electrical system, three ground detecting lamps are provided. If all three lamps REMAIN at half-brilliance when the ground detecting test switch is operated, ______________. A. there is a ... must be replaced C. there are no grounds present D. the light bulbs are of improper voltage

Last Answer : Answer: C

When paralleled, AC generators must have the same _________. A. frequency B. number of phases C. phase rotation D. all of the above

Description : When paralleled, AC generators must have the same _________. A. frequency B. number of phases C. phase rotation D. all of the above

Last Answer : Answer: D

If the illustrated motor fails to start and gives a loud hum when the start button is pushed, the problem is ________. EL-0007 A. one of the phases to the motor is not energized because of an open motor lead B. the 'Disc.sw.' is open C. power to 'L1' at the 'Disc.sw.' is not energized because of a problem with the ship's electrical distribution system D. 'OL1' is open because of 'T1' overload causing the motor to single phase

Description : If the illustrated motor fails to start and gives a loud hum when the start button is pushed, the problem is ________. EL-0007 A. one of the phases to the motor is not energized because of ... electrical distribution system D. 'OL1' is open because of 'T1' overload causing the motor to single phase

Last Answer : Answer: A

Which of the following procedures should be used to determine the load of a threephase, delta wound, AC generator? A. Multiply the amperage in one phase by three. B. Divide the total amperage in all phases by three. C. Multiply the amperage in one phase by the square root of three. D. Divide the total amperage in all phases by the square root of three.

Description : Which of the following procedures should be used to determine the load of a threephase, delta wound, AC generator? A. Multiply the amperage in one phase by three. B. Divide the total amperage in all ... square root of three. D. Divide the total amperage in all phases by the square root of three.

Last Answer : Answer: C

The speed of a three-phase squirrel-cage induction-type motor operating in a fixed frequency system is varied by changing the _____________. A. number of phases to the motor B. number of stator poles C. locked rotor current D. resistance of the rotor winding

Description : The speed of a three-phase squirrel-cage induction-type motor operating in a fixed frequency system is varied by changing the _____________. A. number of phases to the motor B. number of stator poles C. locked rotor current D. resistance of the rotor winding

Last Answer : Answer: B

Which of the following statements is true concerning all three-phase alternators? A. Each has three separate but identical armature windings acted on by one system of rotating magnets. B. Each has one armature winding acted on by three identical but separate systems of rotating magnets. C. All three-phase alternators are designed to operate with a 0.8 leading power factor. D. The three phases always provide power to the load through three sets of slip rings and brushes.

Description : Which of the following statements is true concerning all three-phase alternators? A. Each has three separate but identical armature windings acted on by one system of rotating magnets. B. Each has one ... The three phases always provide power to the load through three sets of slip rings and brushes.

Last Answer : Answer: A

In case of absorption & stripping, the interface of the liquid & gas phases are present in equilibrium, when the diffusional resistance of __________ is zero. (A) Interface (B) Gas phase (C) Liquid phase (D) All 'a', 'b' & 'c'

Description : In case of absorption & stripping, the interface of the liquid & gas phases are present in equilibrium, when the diffusional resistance of __________ is zero. (A) Interface (B) Gas phase (C) Liquid phase (D) All 'a', 'b' & 'c'

Last Answer : (A) Interface

One of the reasons a project life cycle is split into phases ic. mirror the major deployments of resources throughout the project. d. chunk work into time periods of similar durations.s to: a. facilitate formal go/no-go decision making during the project. b. balance the costs of work in each phase of project development.

Description : One of the reasons a project life cycle is split into phases is to: a. facilitate formal go/no-go decision making during the project. b. balance the costs of work in each phase of ... the major deployments of resources throughout the project. d. chunk work into time periods of similar durations.

Last Answer : a. facilitate formal go/no-go decision making during the project.

The life cycle can be said to consist of a series of phases. The classical model is referred to as the waterfall model. Which phase may be defined as “The concept is explored and refined, and the client’s requirements are elicited?” (a) Requirements (b) Specification (c) Design d) Implementation

Description : The life cycle can be said to consist of a series of phases. The  classical model is referred to as the waterfall model. Which phase  may be defined as The concept is explored and refined, ... client's requirements are elicited? (a) Requirements (b) Specification (c) Design d) Implementation

Last Answer : (a) Requirements

One of the reasons a project life cycle is split into phases is to: a. facilitate formal go/no-go decision making during the project. b. balance the costs of work in each phase of project development. c. mirror the major deployments of resources throughout the project. d. chunk work into time periods of similar durations.

Description : One of the reasons a project life cycle is split into phases is to:  a. facilitate formal go/no-go decision making during the project.  b. balance the costs of work in each phase ... the major deployments of resources throughout the project.  d. chunk work into time periods of similar durations.

Last Answer : a. facilitate formal go/no-go decision making during the project.

Given below is a schematic break-up of the phases/stages of cell cycle. Which one of the following is the correct indication of the stage/phase in the cell cycle? (a) C - karyokinesis (b) D - synthetic phase (c) A - cytokinesis (d) B - metaphase

Description : Given below is a schematic break-up of the phases/stages of cell cycle. Which one of the following is the correct indication of the stage/phase in the cell cycle? (a) C - karyokinesis (b) D - synthetic phase (c) A - cytokinesis (d) B - metaphase

Last Answer : (b) D - synthetic phase

Compared with other phases of the new product development process, the largest number of new product ideas are rejected during the ______ phase 1. idea generation 2. concept testing 3. business analysis 4. screening5. test marketing

Description : Compared with other phases of the new product development process, the largest number of new product ideas are rejected during the ______ phase 1. idea generation 2. concept testing 3. business analysis 4. screening 5. test marketing

Last Answer : screening

When liquid and vapour phase of multi-component system are in equilibrium (at a given temperature and pressure), then chemical potential of each component is (A) Same in both the phases (B) Zero in both the phases (C) More in vapour phase (D) More in liquid phase

Description : When liquid and vapour phase of multi-component system are in equilibrium (at a given temperature and pressure), then chemical potential of each component is (A) Same in both the phases (B) Zero in both the phases (C) More in vapour phase (D) More in liquid phase

Last Answer : (A) Same in both the phases

When liquid and vapour phases of one component system are in equilibrium (at a given temperature and pressure), the molar free energy is (A) More in vapour phase (B) More in liquid phase (C) Same in both the phases (D) Replaced by chemical potential which is more in vapour phase

Description : When liquid and vapour phases of one component system are in equilibrium (at a given temperature and pressure), the molar free energy is (A) More in vapour phase (B) More in liquid phase (C) Same in both the phases (D) Replaced by chemical potential which is more in vapour phase

Last Answer : (C) Same in both the phases

The necessary condition for phase equilibrium in a multiphase system of N components is that the (A) Chemical potentials of a given component should be equal in all phases (B) Chemical potentials of all components should be same in a particular phase (C) Sum of the chemical potentials of any given component in all the phases should be the same (D) None of these

Description : The necessary condition for phase equilibrium in a multiphase system of N components is that the (A) Chemical potentials of a given component should be equal in all phases (B) Chemical potentials of all ... potentials of any given component in all the phases should be the same (D) None of these

Last Answer : (A) Chemical potentials of a given component should be equal in all phases

Which of the following phases of psychological reaction to rape is characterized by fear and flashbacks? a) Heightening anxiety phase During the heightened anxiety phase, the patient demonstrates anxiety, hyperalertness, and psychosomatic reactions, in addition to fear and flashbacks.

Description : Which of the following phases of psychological reaction to rape is characterized by fear and flashbacks? a) Heightening anxiety phase During the heightened anxiety phase, the patient demonstrates anxiety, ... the incident is put into perspective. Some patients never fully recover from rape trauma.

Last Answer : a) Heightening anxiety phase During the heightened anxiety phase, the patient demonstrates anxiety, hyperalertness, and psychosomatic reactions, in addition to fear and flashbacks.

Which of the phases of a migraine headache usually lasts less than an hour? a) Aura The aura phase occurs in about 20% of patients who have migraines and may be characterized by focal neurological symptoms.

Description : Which of the phases of a migraine headache usually lasts less than an hour? a) Aura The aura phase occurs in about 20% of patients who have migraines and may be characterized by focal neurological ... to 72 hours. d) Recovery During the post-headache phase, patients may sleep for extended periods.

Last Answer : a) Aura The aura phase occurs in about 20% of patients who have migraines and may be characterized by focal neurological symptoms.

Regarding the surgical patient, which of the following terms refers to the period of time that constitutes the surgical experience? a) Perioperative phase Perioperative period includes the preoperative, intraoperative, and postoperative phases. b) Preoperative phase Preoperative phase is the period of time from when the decision for surgical intervention is made to when the patient is transferred to the operating room table.

Description : Regarding the surgical patient, which of the following terms refers to the period of time that constitutes the surgical experience? a) Perioperative phase Perioperative period includes the preoperative, ... care unit and ends after a follow-up evaluation in the clinical setting or home.

Last Answer : a) Perioperative phase Perioperative period includes the preoperative, intraoperative, and postoperative phases.

A plot of pressure vs. temperature for a given substance showing the various phases possible for that particular substance.  a. Phase diagram  b. P-T diagram  c. Wein Diagram  d. Histogram

Description : A plot of pressure vs. temperature for a given substance showing the various phases possible for that particular substance.  a. Phase diagram  b. P-T diagram  c. Wein Diagram  d. Histogram

Last Answer : Phase diagram

What is the state at which all three phases of water coexist in equilibrium?  A. Tripoint of water  B. Triple point of water  C. Triple phase point of water  D. Phase point of water

Description : What is the state at which all three phases of water coexist in equilibrium?  A. Tripoint of water  B. Triple point of water  C. Triple phase point of water  D. Phase point of water

Last Answer : Triple point of water

“This life cycle model is basically driven by schedule and budget risks” This statement is best suited for A. Water fall model B. Spiral model C. Incremental model D. V-Model Q33. The bug tracking system will need to capture these phases for each bug. I. Phase injected II. Phase detected III. Phase fixed IV. Phase removed

Description : This life cycle model is basically driven by schedule and budget risks This statement is best suited for A. Water fall model B. Spiral model C. Incremental model D. V-Model Q33. The bug tracking ... these phases for each bug. I. Phase injected II. Phase detected III. Phase fixed IV. Phase removed

Last Answer : B. I, II and IV

Select the correct order for the different phases of virus execution. i) Propagation phase ii) Dormant phase iii) Execution phase iv) Triggering phase A) i, ii, iii, and iv B) i, iii, ii and iv C) ii, i, iv an iii D) ii, iii, iv and i

Description : Select the correct order for the different phases of virus execution. i) Propagation phase ii) Dormant phase iii) Execution phase iv) Triggering phase A) i, ii, iii, and iv B) i, iii, ii and iv s D) ii, iii, iv and i

Last Answer : C) ii, i, iv an iii

Compared with other phases of the new product development process, the largest number of new -product ideas are rejected during the __________ phase. A)idea generation B)concept testing C)business analysis D)screening E)test marketing

Description : Compared with other phases of the new product development process, the largest number of new -product ideas are rejected during the __________ phase. A)idea generation B)concept testing C)business analysis D)screening E)test marketing

Last Answer : D)screening