« previous next »

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

Excessive alcohol use costs the country approximately $235 billion every year.

Did you know?

Allergies play a major part in the health of children. The most prevalent childhood allergies are milk, egg, soy, wheat, peanuts, tree nuts, and seafood.

Did you know?

Common abbreviations that cause medication errors include U (unit), mg (milligram), QD (every day), SC (subcutaneous), TIW (three times per week), D/C (discharge or discontinue), HS (at bedtime or "hours of sleep"), cc (cubic centimeters), and AU (each ear).

Did you know?

Asthma-like symptoms were first recorded about 3,500 years ago in Egypt. The first manuscript specifically written about asthma was in the year 1190, describing a condition characterized by sudden breathlessness. The treatments listed in this manuscript include chicken soup, herbs, and sexual abstinence.

Did you know?

Aspirin is the most widely used drug in the world. It has even been recognized as such by the Guinness Book of World Records.

Cade and colleagues discovered a way to improve athletic performance and prevent salt and water imba Cade and colleagues discovered a way to improve athletic performance and prevent salt and water imba
Cade and colleagues discovered a way to improve athletic performance and prevent salt and water imba Cade and colleagues discovered a way to improve athletic performance and prevent salt and water imba
The mask covers both the mouth and nose to prevent exposure to body fluids and airborne droplets. The mask covers both the mouth and nose to prevent exposure to body fluids and airborne droplets.
Valves in veins open to permit blood flow, close to prevent backflow. Valves in veins open to permit blood flow, close to prevent backflow.
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 ...
PV cells have potential for domestic and commercial use PV cells have potential for domestic and commercial use
Video: Status Epilepticus

For a complete list of videos, visit our video library