Author Question: Only the 64-bit version of the Java Runtime Environment should be installed when using a 64-bit ... (Read 42 times)

jazziefee

  • Hero Member
  • *****
  • Posts: 505
Only the 64-bit version of the Java Runtime Environment should be installed when using a 64-bit operating system.
 
  Indicate whether the statement is true or false

Question 2

What are SQL triggers and how are they used?
 
  What will be an ideal response?



vickybb89

  • Sr. Member
  • ****
  • Posts: 347
Answer to Question 1

FALSE

Answer to Question 2

An SQL trigger is a stored program that is attached to a table or view. The trigger is invoked by the DBMS whenever an insert, update or delete request is made on the table or view with the trigger. There are three commonly used triggers: BEFORE, INSTEAD OF, and AFTER (MS SQL server does not support BEFORE). This creates a set of nine possible trigger types: BEFORE + INSERT or UPDATE or DELETE, INSTEAD OF + INSERT or UPDATE or DELETE, and AFTER + INSERT or UPDATE or DELETE. Triggers are used (among other things) for (1 ) providing default values, (2 ) validity checking, (3 ) updating views, and (4 ) enforcing referential integrity actions.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

Multiple sclerosis is a condition wherein the body's nervous system is weakened by an autoimmune reaction that attacks the myelin sheaths of neurons.

Did you know?

The most common childhood diseases include croup, chickenpox, ear infections, flu, pneumonia, ringworm, respiratory syncytial virus, scabies, head lice, and asthma.

Did you know?

Lower drug doses for elderly patients should be used first, with titrations of the dose as tolerated to prevent unwanted drug-related pharmacodynamic effects.

Did you know?

For about 100 years, scientists thought that peptic ulcers were caused by stress, spicy food, and alcohol. Later, researchers added stomach acid to the list of causes and began treating ulcers with antacids. Now it is known that peptic ulcers are predominantly caused by Helicobacter pylori, a spiral-shaped bacterium that normally exist in the stomach.

Did you know?

Less than one of every three adults with high LDL cholesterol has the condition under control. Only 48.1% with the condition are being treated for it.

For a complete list of videos, visit our video library