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

What is the principal goal of data science?<br>

Rama09 [41]

Answer:

The goal of data science is to construct the means for extracting business-focused insights from data

7 0

3 years ago

A manager wants to set up an area that is not on the LAN but not quite on the Internet. This area will house servers that will s

andreev551 [17]

Answer:

1. DMZ (Demilitarized zone)

Explanation:

In computer networking, a Demilitarized Zone is a physical or logical network designed to give an extra layer of security on the organization’s private network. The DMZ acts as an interface between an untrusted network such as the internet and the organization’s internal network. When a server is set up in a demilitarized zone, users can reach it via its public IP address. In case there is an attack on the server, the private network is still protected.

3 0

3 years ago

list the six external parts or "peripherals" of a computer system and identify which are output and which are input devices.

Tpy6a [65]

There are lots of different peripherals of computer systems. Some examples are listed below:

Input:
Keyboard
Mouse
Video Camera
Microphone
Joystick
Scanner

Output:
Monitor
Projector
Printer
Speakers

Any external device that gives input to or gets output from the computer is a peripheral.

7 0

3 years ago

Jeffrey works with a huge database of spreadsheet records each day. To organize and identify these spreadsheets, he wants to ass

mariarad [96]

Answer:

A. Document Properties

B. Permission

C. Document Options

D. File Details

The answer to this question is "File Details " . This will help Jeffrey works efficiently with a huge database of spreadsheet records each day. He can assign names to these File Details which represents each spreadsheet records. This will help his report more organized and easy to identity.

8 0

3 years ago

Which of the following terms describes surgery through a small incision in the abdomen?

ra1l [238]

Which of the following terms describes surgery through a small incision in the abdomen? Laparoscopy. Laparoscopy is super done by using a fiber-optic instrument that is inserted through the abdomen. When this type of instrument is used, the incision is small and there are smaller cuts made to the person being operated on.

4 0

3 years ago

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