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

There are approximately 3 million unintended pregnancies in the United States each year.

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?

Chronic marijuana use can damage the white blood cells and reduce the immune system's ability to respond to disease by as much as 40%. Without a strong immune system, the body is vulnerable to all kinds of degenerative and infectious diseases.

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?

HIV testing reach is still limited. An estimated 40% of people with HIV (more than 14 million) remain undiagnosed and do not know their infection status.

For a complete list of videos, visit our video library