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

The top five reasons that children stay home from school are as follows: colds, stomach flu (gastroenteritis), ear infection (otitis media), pink eye (conjunctivitis), and sore throat.

Did you know?

Though “Krazy Glue” or “Super Glue” has the ability to seal small wounds, it is not recommended for this purpose since it contains many substances that should not enter the body through the skin, and may be harmful.

Did you know?

According to the Migraine Research Foundation, migraines are the third most prevalent illness in the world. Women are most affected (18%), followed by children of both sexes (10%), and men (6%).

Did you know?

ACTH levels are normally highest in the early morning (between 6 and 8 A.M.) and lowest in the evening (between 6 and 11 P.M.). Therefore, a doctor who suspects abnormal levels looks for low ACTH in the morning and high ACTH in the evening.

Did you know?

The average person is easily confused by the terms pharmaceutics and pharmacology, thinking they are one and the same. Whereas pharmaceutics is the science of preparing and dispensing drugs (otherwise known as the science of pharmacy), pharmacology is the study of medications.

For a complete list of videos, visit our video library