« previous next »

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

Eating carrots will improve your eyesight. Carrots are high in vitamin A (retinol), which is essential for good vision. It can also be found in milk, cheese, egg yolks, and liver.

Did you know?

Ether was used widely for surgeries but became less popular because of its flammability and its tendency to cause vomiting. In England, it was quickly replaced by chloroform, but this agent caused many deaths and lost popularity.

Did you know?

Pope Sylvester II tried to introduce Arabic numbers into Europe between the years 999 and 1003, but their use did not catch on for a few more centuries, and Roman numerals continued to be the primary number system.

Did you know?

All patients with hyperparathyroidism will develop osteoporosis. The parathyroid glands maintain blood calcium within the normal range. All patients with this disease will continue to lose calcium from their bones every day, and there is no way to prevent the development of osteoporosis as a result.

Did you know?

It is important to read food labels and choose foods with low cholesterol and saturated trans fat. You should limit saturated fat to no higher than 6% of daily calories.

A pygmy hippopotamus rests in some water to help prevent its skin from cracking at Ueno Zoo in Japan A pygmy hippopotamus rests in some water to help prevent its skin from cracking at Ueno Zoo in Japan
Potential Constitutional Challenges to Loitering, Panhandling, and Sit-Lie Laws Potential Constitutional Challenges to Loitering, Panhandling, and Sit-Lie Laws
Patient teaching: health promotion to prevent osteroporosis in women Patient teaching: health promotion to prevent osteroporosis in women
PPE used to prevent exposure to bloodborne pathogens. PPE used to prevent exposure to bloodborne pathogens.
Researchers must inform potential participants of a study's procedures so that consent may be o Researchers must inform potential participants of a study's procedures so that consent may be o
All brakes should be moistened with water or solvent to help prevent brake dust from becoming ... All brakes should be moistened with water or solvent to help prevent brake dust from becoming ...
Video: A timeline of the teeth (Explained - No Audio)

For a complete list of videos, visit our video library