The question was to write a generic API to accept the SQL queries data like table name, select columns, ordering using a column name, applying aggregation to it and filtering the data with multiple "and" and "or" conditions. Accept the request from API and convert it into the SQL query in the backened and give the response back.
other personal stuff
Classify the given text "just like that". The was no further definition given for the "just like that" process.
¿Como optimizarías las queries a base de datos?
what I do in my current organization? the next set of questions were related to python and computer science concepts. 1. what is GIL(global interpreter lock) in python. 2. what is deep copy and shallow copy with example on an online editor 3. which code works faster? 1. with open("input.txt") as f: data = f.readlines() for line in data: process(line) -------------------------------- 2. with open("input.txt") as f: for line in f: process(line) 4. iterator,generator,event loop 5. set ,dict tuple 6. mutable and immutable what are these data types 7. what is lazy eval 8. concurrency vs parallelism 9. memory allocation in python
Questions are mostly about python concepts, data types, oop task, about API(how they work).
Questions from python,AWS, API and SQL
They asked about the Django framework, AWS services, system design, and various optimization techniques.
Can we use abstract classes in Python, and how?
Difference between a SQL and a columnar db
Viewing 871 - 880 interview questions