Answer:
The arithmetic operator is used by the program to perform simple algebraic operations like addition, subtraction, multiplication, division, etc. Relational operators are the ones that are used to validate a relationship between the two operands as if they are equal, greater than, less than, etc.
Answer:
Check the explanation
Explanation:
use `my_guitar_shop`;
#delete the procedure test if it exists.
DROP PROCEDURE IF EXISTS test;
DELIMITER //
CREATE PROCEDURE test ()
BEGIN
#declare variable sqlerr to store if there is an sql exception
declare sqlerr tinyint default false;
#declare variable handler to flag when duplicate value is inserted
declare continue handler for 1062 set sqlerr = TRUE;
#start transaction
start transaction;
delete from order_items where order_id in
(select order_id from orders where customer_id=6);
delete from orders where customer_id=6;
delete from addresses where customer_id=6;
delete from customers where customer_id=6;
if sqlerr=FALSE then
commit;
select 'Transaction Committed' as msg;
else
rollback;
select 'Transaction rollbacked' as msg;
end if;
end //
delimiter ;
call test();
Answer:
See explaination
Explanation:
MinMax.java
import java.util.*;
public class MinMax
{
static void MinMax(int[] arr)
{
int Min=arr[0]; // initializinf min and max with 1st value of array
int Max=arr[0];
for(int i=0;i<arr.length;i++) // iterating loop only once
{
if(arr[i]>Max) // checking max value
{
Max=arr[i];
}
if(arr[i]<Min) // checking min value
{
Min=arr[i];
}
}
System.out.println("Min Number is "+Min); //printing min value
System.out.println("Max Number is "+Max); //printing max value
}
public static void main(String[] args) {
Scanner sc = new Scanner(System.in);
System.out.print("Enter N value: "); // taking n value
int n=sc.nextInt();
int[] arr=new int[n];
System.out.println("Enter N elements:"); // taking n elements into array
for(int i=0;i<n;i++)
{
arr[i]=sc.nextInt(); // each element into the array
}
MinMax(arr); // calling MinMax() method.
}
}
