« previous next »

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

The first documented use of surgical anesthesia in the United States was in Connecticut in 1844.

Did you know?

Chronic necrotizing aspergillosis has a slowly progressive process that, unlike invasive aspergillosis, does not spread to other organ systems or the blood vessels. It most often affects middle-aged and elderly individuals, spreading to surrounding tissue in the lungs. The disease often does not respond to conventionally successful treatments, and requires individualized therapies in order to keep it from becoming life-threatening.

Did you know?

The liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

Did you know?

Cucumber slices relieve headaches by tightening blood vessels, reducing blood flow to the area, and relieving pressure.

Did you know?

Astigmatism is the most common vision problem. It may accompany nearsightedness or farsightedness. It is usually caused by an irregularly shaped cornea, but sometimes it is the result of an irregularly shaped lens. Either type can be corrected by eyeglasses, contact lenses, or refractive surgery.

Ion Movements During the Action Potential Ion Movements During the Action Potential
Different exposure codes for potential HIV infection. Different exposure codes for potential HIV infection.
Transmission of the action potential Transmission of the action potential
Factors Contributing to Resting Membrane Potential Factors Contributing to Resting Membrane Potential
An Event-Related Potential An Event-Related Potential
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 ...
Video: DNA Sequences - Dideoxy Sequencing

For a complete list of videos, visit our video library