All categories

2 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

Which type of computer serves as the heart of the computing systems for many, perhaps most, major corporations and government ag

Nezavi [6.7K]

Answer:

Mainframes

Explanation:

Mainframes are utilized by many major corporations and government agencies. They are also used in banking, accounting, and healthcare to name a few.

4 0

2 years ago

1. A truck leaves a stop sign and accelerates uniformly over a time of 5.21 seconds for a

Rufina [12.5K]

Answer:

1, is 21.11 meters per second.

110/5.21

Explanation:

3 0

3 years ago

When using bits to represent fractions of a number, can you create all possible fractions? Why or why not?

kumpel [21]

Answer:

The essence including its issue is listed in the interpretation subsection below.

Explanation:

Representing means the practice of someone using abstract, tangible as well as pictorial symbols as well as phrases and related circumstances to discuss ideas and express comprehension.
Representing fractions could indeed be overcome in almost the same manner as the positive factors of twice represented integers are using the negative factors of two to summarize to essentially fractional amounts.

4 0

3 years ago

The TechWorld goes on a fast pace, what do you think would be the solution to the growing amount of data being collected by the

Nuetrik [128]

The solution to the growing amount of data in software applications to have fully sustainable usage for customers is;

Development of a sustainable model for the future now requires data storage that is engineered to be lower power requirements, lower cooling requirements, and lower waste production.

<h3>Sustainable data storage and usage</h3>

The objective of Sustainable Data Storage Initiative is to spread awareness of the solutions that can reduce the environmental impact of high waste producing data centers.

The environmental impact of data infrastructure is growing as data workloads increase. Hence, building a sustainable model for the future now requires data storage that is engineered to be lower power requirements, lower cooling requirements, and lower waste production.

Read more on Sustainable data storage and usage;

brainly.com/question/24882256

7 0

2 years ago

Mary has cleaned her data and is ready to determine the most efficient bus route. She starts by splitting the city into four reg

igomit [66]

ANSWER:

Transforming the data might help Mary notice a different pattern that makes a bigger impact on bus routes than regions of the City.

EXPLANATION:

Mary can check if there are other things or factors that might influence where the bus routes need to be prioritized. For example if the students' age is considered for the bus routes instead of regions. She can achieve this by

By Re-sorting or Transforming the data.

That is to say she will be able to find out if it is only region or if there are different patterns that makes bigger impacts on bus routes, by transforming the data.

8 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