« previous next »

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

Nearly 31 million adults in America have a total cholesterol level that is more than 240 mg per dL.

Did you know?

People often find it difficult to accept the idea that bacteria can be beneficial and improve health. Lactic acid bacteria are good, and when eaten, these bacteria improve health and increase longevity. These bacteria included in foods such as yogurt.

Did you know?

Famous people who died from poisoning or drug overdose include, Adolf Hitler, Socrates, Juan Ponce de Leon, Marilyn Monroe, Judy Garland, and John Belushi.

Did you know?

The senior population grows every year. Seniors older than 65 years of age now comprise more than 13% of the total population. However, women outlive men. In the 85-and-over age group, there are only 45 men to every 100 women.

Did you know?

Drug-induced pharmacodynamic effects manifested in older adults include drug-induced renal toxicity, which can be a major factor when these adults are experiencing other kidney problems.

This wheel presentation is helpful for the detection of potential amphipathic helices This wheel presentation is helpful for the detection of potential amphipathic helices
Coronary stent. Illustration of an angiogram revealing a coronary stent, which helps prevent closure Coronary stent. Illustration of an angiogram revealing a coronary stent, which helps prevent closure
How many potential risks to the health of the embryo and fetus might a mother encounter in an urban ... How many potential risks to the health of the embryo and fetus might a mother encounter in an urban ...
Kinetic versus Potential Energy Kinetic versus Potential Energy
An electron is accelerated from rest through a potential difference. After acceleration the ... An electron is accelerated from rest through a potential difference. After acceleration the ...
The potential involvement of colchicine in doubling the chromosome number The potential involvement of colchicine in doubling the chromosome number
Video: Anatomy and Chemical Makeup of a Single Hair (Animation)

For a complete list of videos, visit our video library