i got a call from Naukri, first round is written test having one coding and 20 django mcqs 2nd round is tech discussion on python ques are : 1) diff btw list and tuple 2) implement a decorator which will take a arguments 3) multi threading in python 4) a=[[]]*5 a[1].append(20) what is the output? 5)write SQL query to fetch 3rd highest salary 6) what is the django architecture and explain each component? 7) what are views and types of views 8) ques related to django middleware and custom middleware 2nd tech discussion round the interviewer was a senior architect ques are 1) student_result name, subject, department, mark get the second topper of each subject from each department 2) ques related to Django restframe work 3) what are the best practices to implement rest apis in django 4) how to authenticate and make a connection with SQL data base what are the best practices 5) write yml code to build a simple pipeline for a simple python based application deployment 6) how to write test cases in python 7) what is docker and ques related to docker file docker compose 8) experience in cloud 9) how to implement queues in redis

Question from programming,DBMS and pandas were asked. Pandas question difficulty was intermediate. It was delayed nearly one month due to panel availability. Overall experience was okay, panel was not intriguing.

Python and SQL questions. 2nd highest salary, Palindrome code. words count in dictionary, factorial, Difference between truncate and delete. Joins and there types. query on joins. Rank and dense rank(windows function)