1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Tju [1.3M]
3 years ago
12

what type of clause must you always use with DEKETE or UPDATE to avoid inadvertently changing data elsewhere in the database​

Computers and Technology
1 answer:
Shkiper50 [21]3 years ago
5 0

While you’re using the DELETE or UPDATE to change the data in any database like MySQL or ORACLE, the WHERE clause can be used to avoid inadvertently changing data everywhere.

<u>Explanation:</u>

The WHERE clause checks the condition and the changes mentioned by the DELETE or UPDATE command will be done if the condition is true. There are also other clauses like HAVING, IN which will have range either inclusive or exclusive.

It is also noted that in MySQL, there is a method called WorkBench which enables safe mode and doesn’t execute statements without the WHERE clause.

You might be interested in
what typically include instructions, internal issues, decisions, and revised policies of an organization.
Umnica [9.8K]

i believe policy im not 100 percent sure

4 0
3 years ago
What is data base management system? ​
navik [9.2K]

Answer:

software that handles the storage, retrieval, and updating of data in a computer system.

7 0
3 years ago
Read 2 more answers
What is the easiest way to remeber all of the field , entry, and record on a Database table ?
svet-max [94.6K]
Well, you can always write it down on a sheet of paper, then(if you have one), you can save it in your folder. That way you can finfd it easilt
8 0
3 years ago
// Exercise 4.16: Mystery.java
nignag [31]

Answer:

385

Explanation:

There was no question so I simply run the program for you and included the output.

The program seems to calculate: \sum\limits_{x=1}^{10} x^2

8 0
3 years ago
Select the correct navigational path to mark all teachers who have achieved “excellent” on their evaluations a red background.
Wewaii [24]

Answer:

1 home

2 conditional formatting

3 new rule

3 use a formula  

Explanation:

took the test lol pls mark me brainliest

7 0
3 years ago
Read 2 more answers
Other questions:
  • An _______ takes place when an unauthorized person gains access to a digital device by using an Internet connection and exploiti
    14·1 answer
  • Although some media critics disagree about the terminology, smartphones and other mobile devices used to watch content originall
    14·1 answer
  • During the forensic phase of a security investigation, it was discovered that an attacker was able to find private keys on a poo
    9·1 answer
  • True or false it is possible to insert an external drive that connects to your computer using a usb cable while the computer is
    15·1 answer
  • An office established etiquette for using a shared printer. The workers pass a card around that says, “I’m printing,” so that on
    14·1 answer
  • I need help with getting a profile pic
    5·1 answer
  • To create an SSL connection, a Web server requires a ________, which is an electronic document that confirms the identity of a w
    12·1 answer
  • Explain the working principal of computer system with suitable diagarm​
    9·1 answer
  • Question 1 of 10
    13·1 answer
  • Match the definitions to their respective cli hot keys and shortcuts. (not all options are used.)
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!