Computer Science
Predict the output of the following code:
def Changer(P, Q = 10):
P = P / Q
Q = P % Q
return P
A = 200
B = 20
A = Changer(A, B)
print(A, B, sep = '$')
B = Changer(B)
print(A, B, sep = '$', end = '###')
Answer
10.0$20
10.0$2.0###
Working
The code snippet provided defines a function Changer that takes two parameters P and Q, where Q is assigned a default value of 10. Inside the function, P is divided by Q and P is assigned the quotient, and then Q is assigned the remainder of P divided by Q. The modified P value is returned from the function. In the main code, variables A and B are initialized with values 200 and 20, respectively. The Changer function is called first with A and B as arguments, modifying the value of A. The updated values of A and B are then printed with a separator of '$'. Next, the Changer function is called again with only B as an argument, updating B. Finally, the updated values of A and B are printed again with a separator of '$' and an end marker of '###'.
Related Questions
Ms. Shalini has just created a table named “Employee” containing columns Ename, Department and Salary. After creating the table, she realized that she has forgotten to add a primary key column in the table. Help her in writing an SQL command to add a primary key column EmpId of integer type to the table Employee. Thereafter, write the command to insert the following record in the table:
EmpId - 999
Ename - Shweta
Department: Production
Salary: 26900Zack is working in a database named SPORT, in which he has created a table named “Sports” containing columns SportId, SportName, no_of_players, and category. After creating the table, he realized that the attribute, category has to be deleted from the table and a new attribute TypeSport of data type string has to be added. This attribute TypeSport cannot be left blank. Help Zack write the commands to complete both the tasks.
Predict the output of the Python code given below:
Text1 = "IND-23" Text2 = "" I = 0 while I < len(Text1): if Text1[I] >= "0" and Text1[I] <= "9": Val = int(Text1[I]) Val = Val + 1 Text2 = Text2 + str(Val) elif Text1[I] >= "A" and Text1[I] <= "Z": Text2 = Text2 + (Text1[I + 1]) else: Text2 = Text2 + "*" I += 1 print(Text2)Consider the table CLUB given below and write the output of the SQL queries that follow.
CID CNAME AGE GENDER SPORTS PAY DOAPP 5246 AMRITA 35 FEMALE CHESS 900 2006-03-27 4687 SHYAM 37 MALE CRICKET 1300 2004-04-15 1245 MEENA 23 FEMALE VOLLEYBALL 1000 2007-06-18 1622 AMRIT 28 MALE KARATE 1000 2007-09-05 1256 AMINA 36 FEMALE CHESS 1100 2003-08-15 1720 MANJU 33 FEMALE KARATE 1250 2004-04-10 2321 VIRAT 35 MALE CRICKET 1050 2005-04-30 (i) SELECT COUNT(DISTINCT SPORTS) FROM CLUB;
(ii) SELECT CNAME, SPORTS FROM CLUB WHERE DOAPP<"2006-04-30" AND CNAME LIKE "%NA";
(iii) SELECT CNAME, AGE, PAY FROM CLUB WHERE GENDER = "MALE" AND PAY BETWEEN 1000 AND 1200;