Author Question: Only the 64-bit version of the Java Runtime Environment should be installed when using a 64-bit ... (Read 71 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?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

Every 10 seconds, a person in the United States goes to the emergency room complaining of head pain. About 1.2 million visits are for acute migraine attacks.

Did you know?

The human body's pharmacokinetics are quite varied. Our hair holds onto drugs longer than our urine, blood, or saliva. For example, alcohol can be detected in the hair for up to 90 days after it was consumed. The same is true for marijuana, cocaine, ecstasy, heroin, methamphetamine, and nicotine.

Did you know?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

Did you know?

Most women experience menopause in their 50s. However, in 1994, an Italian woman gave birth to a baby boy when she was 61 years old.

For a complete list of videos, visit our video library