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

if a hacker wants to exploit the TCP three-way handshake, what is the most effective way to go about it?

goldfiish [28.3K]

The most effective way to exploit TCP three-way handshake is TCP SYN flood.

SYN flood attack is simply a kind of computer attack that begins with 3-way TCP handshake.

TCP SYN flood is also called SYN flood and it is a type of distributed Denial of Service (DDoS) attack that uses every part of the normal TCP three-way handshake to eat up resources on the known server and render it non-functional

With TCP SYN flood, a hacker can eat up resources of target's computer and makes it unresponsive.

From the above, we can therefore say that the most effective way to exploit TCP three-way handshake is TCP SYN flood.

Learn more from:

brainly.com/question/14739766

7 0

2 years ago

What is the name of the first practical asymmetric cryptosystem that was created?

victus00 [196]

Answer:

I think the name is RSA

4 0

2 years ago

Please help im not good at computer class

Veronika [31]

Answer:

Explanation:

4 0

3 years ago

Read 2 more answers

What two statements about IPv6 addresses are true? This task contains the radio buttons and checkboxes for options. The shortcut

Oliga [24]

Answer:

A and C

Explanation:

Option A:

In IPv6 there is a rule to reduce an IPv6 address when there are two or more consecutive segments of zeros just one time. This rule says that you can change the consecutive zeros for “::”

Here is an example

How to reduce the following IPv6 address?

ff02:0000:0000:0000:0000:0000:0000:d500

Ans: ff02::d500

Example 2:

2001:ed02:0000:0000:cf14:0000:0000:de95

Incorrect Answer -> 2001:ed02::cf14::de95

Since the rule says that you can apply “::” just one time, you need to do it for a per of zero segments, so the correct answer is:

Correct Answer -> 2001:ed02::cf14:0:0:de95

2001:ed02:0:0:cf14::de95

Option C:

Since in IPv6 there are $2^{128}$ available addresses which means 340.282.366.920.938.463.463.374.607.431.768.211.456 (too many addresses), there is no need of NAT solution, so each device can have its own IP address by the same interface to have access through the internet if needed. If not, you can block the access through internet by the firewall.

4 0

3 years ago

(Count positive and negative numbers and compute the average of numbers) Write a program that reads an unspecified number of int

Papessa [141]

Answer:

Explanation:

Sorry it is in Java, though you can covert it using converter

public class Exercise {

public static void main(String[] args) {

Scanner input = new Scanner(System.in);

int positives = 0; // Count the number of positive numbers

int negatives = 0; // Count the number of negative numbers

int count = 0; // Count all numbers

double total = 0; // Accumulate a totol

// Promopt the user to enter an integer or 0 to exit

System.out.print("Enter an integer, the input ends if it is 0: ");

int number = input.nextInt();

if (number == 0) { // Test for sentinel value

System.out.println("No numbers are entered except 0");

System.exit(1);

}

while (number != 0) {// Test for sentinel value

if (number > 0)

positives++; // Increase positives

else

negatives++; // Increase negatives

total += number; // Accumulate total

count++; // Increase the count

number = input.nextInt();

}

// Calculate the average

double average = total / count;

// Display results

System.out.println(

"The number of positive is " + positives +

"\nThe number of negatives is " + negatives +

"\nThe total is total " + total +

"\nThe average is " + average);

}

7 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