« previous next »

Author Question: Explain the potential dangers of updates and deletes and how to prevent them. What will be an ... (Read 61 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?

Asthma is the most common chronic childhood disease in the world. Most children who develop asthma have symptoms before they are 5 years old.

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?

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?

Blood in the urine can be a sign of a kidney stone, glomerulonephritis, or other kidney problems.

Did you know?

Disorders that may affect pharmacodynamics include genetic mutations, malnutrition, thyrotoxicosis, myasthenia gravis, Parkinson's disease, and certain forms of insulin-resistant diabetes mellitus.

Major Findings of the High Scope Preschool Study High Scope participants showed better academic per Major Findings of the High Scope Preschool Study High Scope participants showed better academic per
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 ...
Action potential Action potential
Warfarin An anticoagulant drug given to prevent blood from clotting Warfarin An anticoagulant drug given to prevent blood from clotting
Potential Interactions of Medications, Herbs, Nutrients, and Foods (2 of 2) Potential Interactions of Medications, Herbs, Nutrients, and Foods (2 of 2)
Therapy to Prevent PTSD after Disaster Therapy to Prevent PTSD after Disaster
Video: Non-specific disease resistance mechanisms & Skin's defense barriers

For a complete list of videos, visit our video library