42 solutions available
Question 1State True or False:"In a Python program, if a break statement is given in a nested loop, it terminates the execution of all loops in one...
Question 2In a table in MYSQL database, an attribute A of datatype varchar(20) has the value "Keshav". The attribute B of datatype char(20) has value...
Question 3What will be the output of the following statement:print(3 - 2 ** 2 ** 3 + 99/11)244244.0-244.0Error
Question 4Select the correct output of the code:s = "Python is fun" l = s.split() s_new = "-".join([l[0].upper(), l[1], l[2].capitalize()])...
Question 5In MYSQL database, if a table, Alpha has degree 5 and cardinality 3, and another table, Beta has degree 3 and cardinality 5, what will be...
Question 6Riya wants to transfer pictures from her mobile phone to her laptop. She uses Bluetooth Technology to connect two devices. Which type of...
Question 7Which of the following will delete key-value pair for key = “Red” from a dictionary D1 ?delete D1("Red")del...
Question 8Consider the statements given below and then choose the correct output from the given options:pride = "#G20 Presidency"...
Question 9Which of the following statement(s) would give an error during execution of the following code ?tup = (20, 30, 40, 50, 80, 79) print(tup)...
Question 10What possible outputs(s) will be obtained when the following code is executed?import random myNumber = random.randint(0, 3) COLOR =...
Question 11Fill in the blank:The modem at the sender’s computer end acts as a ............... .ModelModulatorDemodulatorConvertor
Question 12Consider the code given below:b = 100 def test(a): ............... #missing statement b = b + a print(a, b) test(10) print(b)Which...
Question 13State whether the following statement is True or False:An exception may be raised even if the program is syntactically correct.
Question 14Which of the following statements is FALSE about keys in a relational database?Any candidate key is eligible to become a primary key.A...
Question 15Fill in the blank:In case of ............... switching, before a communication starts, a dedicated path is identified between the sender...
Question 16Which of the following functions changes the position of file pointer and returns its new position?flush()tell()seek()offset()
Question 17Assertion(A): List is an immutable data type.Reasoning(R): When an attempt is made to update the value of an immutable variable, the old...
Question 18Assertion(A): Python Standard Library consists of various modules.Reasoning(R): A function in a module is used to simplify the code and...
Question 19(a)(i) Expand the following terms: POP3, URL(ii) Give one difference between XML and HTML.
Question 19(b)(i) Define the term bandwidth with respect to networks.(ii) How is http different from https ?
Question 20The code given below accepts a number as an argument and returns the reverse number. Observe the following code carefully and rewrite it...
Question 21(a)Write a function countNow(PLACES) in Python, that takes the dictionary, PLACES as an argument and displays the names (in uppercase) of...
Question 21(b)Write a function, lenWords(STRING), that takes a string as an argument and returns a tuple containing length of each word of a string....
Question 22Predict the output of the following code:S = "LOST" L = [10, 21, 33, 4] D = {} for I in range(len(S)): if I % 2 == 0:...
Question 23(a)Write the Python statement for each of the following tasks using BUILT-IN functions/methods only:(i) To insert an element 200 at the...
Question 23(b)A list named studentAge stores age of students of a class. Write the Python command to import the required module and (using built-in...
Question 24(a)Ms. Shalini has just created a table named “Employee” containing columns Ename, Department and Salary. After creating the table, she...
Question 24(b)Zack is working in a database named SPORT, in which he has created a table named “Sports” containing columns SportId, SportName,...
Question 25Predict 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,...
Question 26Predict the output of the Python code given below:Text1 = "IND-23" Text2 = "" I = 0 while I < len(Text1): if Text1[I] >= "0" and...
Question 27Consider the table CLUB given below and write the output of the SQL queries that...
Question 28(a)Write a function in Python to read a text file, Alpha.txt and displays those lines which begin with the word ‘You’.
Question 28(b)Write a function, vowelCount() in Python that counts and displays the number of vowels in the text file named Poem.txt.
Question 29Consider the table Personal given below:Table:...
Question 30A list, NList contains following record as list elements:[City, Country, distance from Delhi]Each of these records are nested together to...
Question 31Consider the tables PRODUCT and BRAND given below:Table:...
Question 32Vedansh is a Python programmer working in a school. For the Annual Sports Event, he has created a csv file named Result.csv, to store the...
Question 33Meticulous EduServe is an educational organization. It is planning to setup its India campus at Chennai with its head office at Delhi. The...
Question 34(a)(i) Differentiate between r+ and w+ file modes in Python.(ii) Consider a file, SPORT.DAT, containing records of the following...
Question 34(b)(i) How are text files different from binary files?(ii) A Binary file, CINEMA.DAT has the following structure:{MNO:[MNAME,...
Question 35(a)(i) Define the term Domain with respect to RDBMS. Give one example to support your answer.(ii) Kabir wants to write a program in Python...
Question 35(b)(i) Give one difference between alternate key and candidate key.(ii) Sartaj has created a table named Student in MYSQL database,...