« previous next »

Author Question: Explain the potential dangers of updates and deletes and how to prevent them. What will be an ... (Read 51 times)

kaid0807

  • Hero Member
  • *****
  • Posts: 515
on: Jul 7, 2018
Explain the potential dangers of updates and deletes and how to prevent them.
 
  What will be an ideal response?

Question 2

The ID determines the privileges accorded to the user.
 
  Indicate whether the statement is true or false.


mariahkathleeen

  • Sr. Member
  • ****
  • Posts: 337
Reply #1 on: Jul 7, 2018
Answer to Question 1

An UPDATE or DELETE without a WHERE clause can effect every record in a table. An UPDATE can change all the values to be the same as the SET value. The DELETE could remove all records from a table. The way to prevent it is to make sure that UPDATE and DELETE queries have clear and precise conditions in the WHERE Clause.

Answer to Question 2

T


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

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?

Anesthesia awareness is a potentially disturbing adverse effect wherein patients who have been paralyzed with muscle relaxants may awaken. They may be aware of their surroundings but unable to communicate or move. Neurologic monitoring equipment that helps to more closely check the patient's anesthesia stages is now available to avoid the occurrence of anesthesia awareness.

Did you know?

Human kidneys will clean about 1 million gallons of blood in an average lifetime.

Did you know?

Computer programs are available that crosscheck a new drug's possible trade name with all other trade names currently available. These programs detect dangerous similarities between names and alert the manufacturer of the drug.

Did you know?

Pubic lice (crabs) are usually spread through sexual contact. You cannot catch them by using a public toilet.

Recording the membrane potential of neurons. Recording the membrane potential of neurons.
Inspect the site for potential veins to use and palpate to further locate a vein and test the firmne Inspect the site for potential veins to use and palpate to further locate a vein and test the firmne
To prevent ignition and fuel-injection operation while the engine is being cranked, remove both the ... To prevent ignition and fuel-injection operation while the engine is being cranked, remove both the ...
Dry hands and forearms thoroughly with clean paper towels to prevent chapping. Dry hands and forearms thoroughly with clean paper towels to prevent chapping.
Methods to prevent pregnancy Methods to prevent pregnancy
Potential Interactions of Medications, Herbs, Nutrients, and Foods (1 of 2) Potential Interactions of Medications, Herbs, Nutrients, and Foods (1 of 2)
Video: Cardiac Cycle (Part 2 of 4)

For a complete list of videos, visit our video library