3 years ago

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.

<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

Where can the container code be found in Google Tag Manager? (select all answers that apply) a. In a pop-up window after you cre

saveliy_v [14]

Answer:

Option A and C.

Explanation:

The container code can be located in Google Tag Manager inside a pop-up window when they set up an account as well as container and Under "Admin" through choosing that container and clicking Installing Google Tag Manager.

The main advantage for Google Tag Manager, ever though, would be that it create it in much easier manner for marketing companies to execute identifiers without depends on developers to use it. Developers tend to also be preoccupied with some other high-priority initiatives so tagging mostly finishes up on the other side burner

7 0

3 years ago

Where would you go to change the macro settings in a Word document? Click the File tab and open Protection. Click the File tab a

yawa3891 [41]

Answer:

Click the File tab, select Options, and open the Trust Center.

Explanation:

7 0

3 years ago

In object-oriented terms, a(n) ____________________ defines an object’s behavior

Phoenix [80]

Do you have any answer choices?