« previous next »

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

A serious new warning has been established for pregnant women against taking ACE inhibitors during pregnancy. In the study, the risk of major birth defects in children whose mothers took ACE inhibitors during the first trimester was nearly three times higher than in children whose mothers didn't take ACE inhibitors. Physicians can prescribe alternative medications for pregnant women who have symptoms of high blood pressure.

Did you know?

About 100 new prescription or over-the-counter drugs come into the U.S. market every year.

Did you know?

When taking monoamine oxidase inhibitors, people should avoid a variety of foods, which include alcoholic beverages, bean curd, broad (fava) bean pods, cheese, fish, ginseng, protein extracts, meat, sauerkraut, shrimp paste, soups, and yeast.

Did you know?

Limit intake of red meat and dairy products made with whole milk. Choose skim milk, low-fat or fat-free dairy products. Limit fried food. Use healthy oils when cooking.

Did you know?

The most dangerous mercury compound, dimethyl mercury, is so toxic that even a few microliters spilled on the skin can cause death. Mercury has been shown to accumulate in higher amounts in the following types of fish than other types: swordfish, shark, mackerel, tilefish, crab, and tuna.

As sessile organisms, plants have evolved many mechanisms to mitigate the potential damage of abioti As sessile organisms, plants have evolved many mechanisms to mitigate the potential damage of abioti
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
Capillaries act as bridges between the arteries and veins. Valves in the veins prevent backflow as ... Capillaries act as bridges between the arteries and veins. Valves in the veins prevent backflow as ...
Establishing a steady-state resting membrane potential. Establishing a steady-state resting membrane potential.
E9-23 Prepare income statements Explain the difference in operating income E9-23 Prepare income statements Explain the difference in operating income
Resting Membrane Potential Resting Membrane Potential
Video: Asthma Treatment

For a complete list of videos, visit our video library