Domande di colloquio per Associate Software Engineer - Python & ReactJS presso Devsinc

DSA: 1.heap 2.stack 3.queue 4.can we convert stack or queue into array 5.convert stack or queue into array 5.what alogos(dijastra) 6.Traversal algorithms (DFS, BFS). 7.array, stack, queue which fast and which we use when sorting (bubble)

DB: 1.what is orm 2.writing qury in orm fast or direct raw qury on db 3.how to break mvc/mvt artictecture (write qury on frontend) 4.what are store procedures 5.what are transaction 6.what rollback does 7.what is join 8.what are views 9.what are normalization, how many normal forms 10.write qury to find second hihest salaray 11.write to store picture of students, we have two tables students and picture only store pictures of students from picture table. 12.Aggregate functions 13.Indexing and its impact on performance 14.what is delete and truncate do 15.different keys 16.what is a deadlock, its types and how to handle deadlocks