Answer:
The Update statement in the DML is used for changing existing data in a table.
Explanation:
Their are following Sql statement in the DML.
Insert
This SQL statement is used for inserting data into the table.
select
This SQL statement is used for retrieving data from database
update
This SQL statement is used for updating data in a table.
delete
This SQL statement is used for delete data from database .
The "UPDATE" SQL statement in DML is used for Modify the data in the existing table .
Following are the syntax of Update SQL query
Update tablename
set column1=value1,column2=value2............column N=valueN
Where condition;
Example :Suppose we have student table and (rollno,name,age and add) are the field for that table we have to change the address of rollno 105
Then we use update query like that
UPDATE STUDENT
SET add='kalam nagar'
where rollno=105;
Solution:
initial = float(eval(input('Enter the monthly saving amount: ')))
x = (1 + 0.00417)
month_one = initial * x
month_two = (initial + month_one) * x
month_three = (initial + month_two) * x
month_four = (initial + month_three) * x
month_five = (initial + month_four) * x
month_six = (initial + month_five) * x
print('The sixth month value is: '+str(month_six))
Don't forget the saving amount, and initialize the balance with that amount. Inside the loop, work out and add the interest and then add the saving amount for the next month.
balance = 801
for month in range(6):
balance = balance * (1.00417)
print(balance)
Answer:
0
Explanation:
In the lists, indexation starts from 0, because of that in if statement we compare item[0] which is 'male' and 'male', and then males is itterated within for loop.
Or by searching up the desired content and or information on a search engine. I believe.
Answer:
import java.util.Arrays;
import java.util.Scanner;
public class num1 {
public static void main(String[] args) {
Scanner in = new Scanner(System.in);
System.out.println("Enter length of the array:");
int len = in.nextInt();
double [] temps = new double[len];
double avgTem;
int k =0;
double total = 0;
for( k=0; k<temps.length; k++){
System.out.println("Enter values for the array");
temps[k]=in.nextDouble();
}
System.out.println("The Arrays contains the following values");
System.out.println(Arrays.toString(temps));
// Computing the average of the values
for(k=0; k<temps.length; k++){
total = total+temps[k];
}
avgTem = total/(temps.length);
System.out.println("The average Temperature is: "+avgTem);
}
}
Explanation:
- Using Java programming language
- Import the Scanner class to receive user input
- Prompt User for the length of the Array, receive and store in a variable len;
- Declare a new double array of size len double [] temps = new double[len];
- Using a for loop, continually prompt user to enter values into the array
- Display the values of the array using Java's Arrays.toString method
- Use another for loop to add up all the elements in the arraay and store in the variable called total
- Outside the second for loop calculate the average avgTem = total/(temps.length);
- Display the average temp.
