Domanda di colloquio di Nineleaps Technology Solutions
-sql query based on Transaction table data with group by,sum,avg,order by.
-Python program(Find prime number),Given data set to analyze using pandas.
Risposte di colloquio
One more question they asked
3.find the list of userid where more no of transaction today as compare yesterday
select count(transaction_id) as no_of_trans, date, user_id
from Transaction
group by user_id, date
lower = int(input("enter the lowest number"))
uper = int(input("enter uper number"))
for a in range(lower,uper+1):
if a>1:
for i in range(2,a):
if a%i ==0:
break
else:
print(a)
For the first round
1. what is index different types of index?
2. primary key and unique key?
3. DDL and DML?
4.Advantage of index?
5.SQL and mySQL?
6.WHERE and having difference?
7. drop, truncate,delete?
8.normalization and advantages?
3 questions for second round, you will be lucky if they ask you same question.