Tech Mahindra core python - senior level interview questions

Questions asked in Tech Mahindra core Python interview One, if you’re working on a Django application that is experiencing performance issue due to insufficient database queries, so how will you optimise these database query in Django? 2, how to optimise insufficient database queries in Django application causing performance issue Three how to implement a custom cash? For mechanism in python, to optimise the performance of a function Five. If cash is expensive, how should you able to cachet and Store result be saved upon the functional inputs? Six. How would you implement this using a decorator? Basically accustom python decorator for cashing? Give a coding, example for the 7SAPA that allows a user to upload a large file, so what consideration would you make to ensure the process efficient and reliable? Seven implement a custom data structure in python, that support, efficient insertion, efficient, deletion, and random axis Eight how to optimise data processing of a large data set using panda set to reduce memory usage and improve performance, implement the same later and explain what is the efficiency reduce memory usage improve performance Nine. Write a quote to optimise large data set processing using data type junking and vectoring operations in pandas.