Questions | Python | DBMS | Coding | Duration | Correct | Incorrect |
20 | 13-15 | 5-7 | – | 30 min | +4 | -0 |
0 of 20 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 20 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 Mock Test.
Pos. | Name | Entered on | Points | Result |
---|---|---|---|---|
Table is loading | ||||
No data available | ||||
dig = 0
for i in range(0, 5, 0.1):
dig += i
i+=0
print(dig)
a = True
b = False
c = False
if not a or b:
print ("1")
elif not a or not b and c:
print ("2")
elif not a or b or not b and a:
print ("3")
else:
print ("4")
Predict the output :
Select substr(‘123456789’,INSTR(‘abcabcabc’,’b’),4) from DUAL;
lst = [1, 2, 3]
lst.append([5,6,7,8,9,10])
print(len(lst))
r = lambda g: g * 2
s = lambda g: g * 3
x = 2
x = r(x)
x = s(x)
x = r(x)
x = s(x)
print(x)
a = 1
b = 0
print(a//b)
a = 8.3
b = 2
print(a//b)
Observe the given SQL query and choose the correct option.
SELECT branch_name, COUNT (DISTINCT customer_name)
FROM depositor, account
WHERE depositor.account_number = account.account_number
GROUP BY branch_id
int = 1
def randommethod():
global int
for i in (1, 2, 3):
int += 1
randommethod()
print(int)
def int():
print("CODE")
int = int()
dicts = dict()
for l in enumerate(range(2)):
dicts[l[0]] = l[1]
dicts[l[1]+7] = l[0]
print(dicts)
int = 1
def randommethod():
global int
for i in (1, 2, 3):
int += 1
randommethod()
print(int)
Some of these insert statements will produce an error. Identify the statement.
CREATE TABLE employee (id INTEGER,name VARCHAR(20),salary NOT NULL);
1. INSERT INTO employee VALUES (1005,Rach,0);
2. INSERT INTO employee VALUES (1007,Ross, );
3. INSERT INTO employee VALUES (1002,Joey,335);
Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.
SQL Statement :
Select count(*) from Employee WHERE Salary > ANY (Select Salary from Employee);
prints
counter = {}
def addToCounter(country):
if country in counter:
counter[country] += 1
else:
counter[country] = 1
addToCounter('China')
addToCounter('Japan')
addToCounter('china')
print (len(counter))
Predict the output of given query :
Query : SELECT SALARY from Employee where EID > 1002
Predict the output of given query :
def outer():
global glo
glo = 20
def inner():
global glo
glo = 30
print(glo)
glo = 10
outer()
print( glo)
Table_name : Records
Table_name : Records
What is the output of the following SQL query ?
SELECT count(*)
FROM (
SELECT Borrower, Manager FROM Records) AS S
NATURAL JOIN
(SELECT Manager, Loan FROM Records) AS T
);
81, 20, 34, 42, 21, 45
Assume that the hash values are stored in ascending order. Identify whether
collision will occur while mapping the values using the hash function.
def fun(n):
stack = Stack(100)
while (n > 0):
stack.push(n%10)
n =int (n/10)
result=0
while (not stack.is_empty()):
result+=stack.pop()
return result