Questions | Python | DBMS | Quant | Duration | Correct | Incorrect |
40 | 20 | 10 | 10 | 60 min | +4 | -0 |
CUT-OFF : 70%
Why no ‘-‘ markings for Incorrect Questions ? – Main motive of this Mock Test Series is to make you learn from your experience. In order to make you attempt all questions, we are excluding the concept of negative marking in our Mock Tests. Although, InfyTQ Qualifier Round will have minus marking.
For any queries or bug reporting, feel free to mail us at :
0 of 38 Questions completed
Questions:
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 38 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Average score |
|
Your score |
|
Thanks for taking this test.
Congratulations, You cleared this InfyTQ Mock Screening Test !!
In an organization, there are 100 male members but no female members. If 25 male members are replaced by 25 female members, what will be the ratio of the male members to the female members in the organization.
Choose the correct option :
Select the correct statement for ‘case’ :
A tub contains a solution with 83% water and 17% spirit. 10 litres of the solution is removed and replaced with water. The proportion of spirit is now 136/9 %.
How much does the tub hold?
Choose the correct option :
All aggregate functions except _____ ignore null values in their input collection.
Choose the correct option :
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
In a group of 50 people, 40 speak Hindi and 22 speak English, and all of them speak at least one of the 2 languages. Find the number of people who speak English but not Hindi
Jake can dig a well in 16 days. Paul can dig the same well in 24 days. Jake, Paul and Hari together dig the well in 8 days. In how many days Hari alone can dig the well ?
Choose the correct option :
Consider the following query :
SELECT name ____ instructor name, course id FROM instructor, teaches WHERE instructor.ID= teaches.ID;
Which keyword must be used here to rename the field name?
In a combo pack of a pencil and eraser, the pencil costs Rs.1 more than the eraser. If the price of the combo is Rs 1.10, what is the price of the eraser?
A man sold 12 candies in 10$ had loss of b% then again sold 12 candies at 12$ had profit of b% find the value of b.
A trader has 1600 kg of sugar. He sells a part at 8% profit and the rest at 12% profit. If he gains 11% on the whole , find the quantity sold at 12%.
The value of a machine depreciates at the rate of 10% every year. It was purchased 3 years ago. If its present value is Rs. 8748, its purchase price was :
Choose the correct option :
Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary)
Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.
Choose the correct option :
Correct way to drop a view :
Choose the correct option :
Which one of the following refers to the total view of the database content?
Choose the correct option :
Which of the following is not a wildcard operator ?
Choose the correct option :
Which one of the following deletes all the entries but keeps the structure of the relation.
key = 100
try:
key = key/0
except ZeroDivisionError:
print('Hacked ', end = '')
else:
print('Division successful ', end = '')
try:
key = key/5
except:
print('Hacked 1 ', end = '')
else:
print('Coder', end = '')
Suppose we have two sets A & B, then A<B is:
Mr. Alex is a well known staff member in a popular college. He has been serving as Head Of the Department(HOD) for 18 years. The HOD has a team of teachers working based on the instructions given by him. The HOD and teachers need to swipe their ID card to enter the college. Like teachers, the HOD is required to deliver sessions. The HOD, in comparison with his team members, has additional responsibilities to ensure smooth functioning and closure of operations Considering the above scenario, what would be the most suitable relationship that can be modelled between the HOD and his team?
list1=[]
list1[0]=100
print(list1)
input_linked_list: 1->4->9->16
What will be the value of the elements in the input_linked_list after the
function fun() is invoked by passing the head of the input_linked_list as an
argument?
def fun(head):
next_node = head.get_next()
while(head!=None and next_node != None):
head.set_data(head.get_data()+next_node.get_data())
head = head.get_next()
next_node = head.get_next()
if(next_node != None):
head.set_data(head.get_data()+next_node.get_data())
Note: Order of displaying the elements is from head to tail.
def function(input_list):
mid_pos=len(input_list)//2
low=0
high=len(input_list)-1
while(input_list[mid_pos]<input_list[low]):
low=low+1
if(low<high):
temp=input_list[low]
input_list[low]=input_list[high]
input_list[high]=temp
return input_list
list1 = [39, 91, 77, 51, 33, 84]
sub_list1 = function(list1[:4])
print(sub_list1)
def outer():
global glo
glo = 20
def inner():
global glo
glo = 30
print(glo)
glo = 10
outer()
print( glo)
Which of the following method does not work with list ?
class c1:
@classmethod
def m1(cls):
print("hello")
ob=c1()
ob.m1()
Find the value returned in both case :
sum(2,4,23)
sum({1,2,7})
Which of the following expressions can be used to multiply a given number ‘a’ by 4?
print(~~5)
How many reference variable(s) refer to the object created in line1 at the end of line2 ?
class Team:
counter=0
def __init__(self):
self.no_of_pllyers=11
self.coach=None
cricket_team=Team() #line1
football_team=Team()
hockey_team=football_team
football_team=cricket_team
football_team=Team() #line2
def add(data):
return data+2
def prod(data):
return data*2
def main_fun(function1,function2, number_list):
result_sum=0
for num in number_list:
if(num%3==0):
result_sum=result_sum+function1(num)
else:
result_sum=result_sum+function2(num)
return result_sum
number_list=[1,3,5,6]
print(main_fun(add, prod, number_list))
counter = {}
def addToCounter(country):
if country in counter:
counter[country] += 1
else:
counter[country] = 1
addToCounter('China')
addToCounter('Japan')
addToCounter('china')
print (len(counter))
class myclass:
@staticmethod
def m1():
print("hello")
ob=myclass()
ob.m1()
L1 = [1, 1.33, 'GFG', 0, 'NO', None, 'G', True]
val1, val2 = 0, ''
for x in L1:
if(type(x) == int or type(x) == float):
val1 += x
elif(type(x) == str):
val2 += x
else:
break
print(val1, val2)
a={1:”A”,2:”B”,3:”C”}
b=a.copy()
b[2]=”D”
print(a)
fo = open(“myfile.txt”, “w”)
fo.writelines(12460)
fo.close()
Choose the correct option :
Which code will establish a foreign key among CUSTOMERS & ORDERS table :