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

If you could remove all of your skin, it would weigh up to 5 pounds.

Did you know?

According to animal studies, the typical American diet is damaging to the liver and may result in allergies, low energy, digestive problems, and a lack of ability to detoxify harmful substances.

Did you know?

The B-complex vitamins and vitamin C are not stored in the body and must be replaced each day.

Did you know?

There are more sensory neurons in the tongue than in any other part of the body.

Did you know?

The ratio of hydrogen atoms to oxygen in water (H2O) is 2:1.

For a complete list of videos, visit our video library