Answer:
This is a python program that counts the number of divisors of a given number and calculates the sum of the divisors.
Explanation:
The first line defines a function "sum_divisors" with an argument "n". The square root of the argument is converted to integer and assigned to the variable "x", then a for loop is used to iterate through the range 2 to the calculated nth number of divisors in the argument.The return keyword returns the sum value.
The function is called with several arguments and printed with the print function.
Answer:
A. 4 CPUs and 6 megabyte cache memory
B. 1.3157 x10^-9 nanoseconds
Explanation:
The Intel core i5 7500 is a seventh generation central processing unit with a 4 CPU core and a 6 megabyte cache memory. It executes task at a clock cycle of 5 clock cycle at a speed of 3.8 GHz.
The relationship between frequency and clock cycle is,
Clock cycle = 1 / ( frequent).
So, One clock cycle = 1 / 3.8 GHz
= 0.3 x10^-9
For five clock cycles = 5 x 0.3 x10^-9
= 1.3157 x10^-9 nanoseconds.
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();
