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

1 answer:

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.

Explanation:

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

Tomahawk Industries develops weapons control systems for the military. The company designed a system that requires two different

mojhsa [17]

Answer:

D. Separation of duties

Explanation:

Separation of duties (SoD) is a fundamental concept in internal controls and is the hardest and often the most expensive to achieve.

This aim is accomplished by distributing the tasks and associated permissions among multiple people for a specific security system.

7 0

3 years ago

Where can I learn how you hack?

morpeh [17]

Answer:

www.udemy.com

5 0

2 years ago

Read 2 more answers

Gleick believes that the book is

ss7ja [257]

That it is a tool that does its job well, it's a technology that works.

6 0

3 years ago

Why does angular page look different after refresh.

alukav5142 [94]

Most of the web applications are written with SPA frameworks such as Angular, React, Vue.js, etc. The problem with these SPAs is that the single page is loaded in the browser once and then the framework will take care of all the routing among pages and gives the impression to the user that it is a multi-page application. When you refresh your page in the browser that single page called index.html is reloaded and you will lose the entire state of the application.

3 0

3 years ago

What is 1 TB equal to ? . 1024 kb .1024 gb . 1024 pb . 1024 mb

OLEGan [10]

$\large \mathfrak{Answer : }$

1 TB = 1024 GB

3 0

3 years ago

Read 2 more answers

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

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