Ambience Public School Interview Questions and Answers

Find subarray with maximum sum value

• Use Kadane's algorithm to find the maximum subarray sum

• Initialize max_so_far and max_ending_here to 0

• Loop through the array and update max_ending_here and max_so_far

• Return the subarray with maximum sum value

Truncate removes all data from a table while delete removes specific rows.

• Truncate is faster than delete as it doesn't log individual row deletions

• Truncate resets the identity of the table while delete doesn't

• Truncate cannot be rolled back while delete can be

• Truncate is a DDL command while delete is a DML command

MVC and MVT are software architecture patterns used for developing web applications.

• MVC stands for Model-View-Controller and separates the application into three interconnected components.

• MVT stands for Model-View-Template and is similar to MVC but with a different approach to handling user input.

• In MVC, the Model represents the data and business logic, the View displays the data to the user, and the Controller handles user input and updates the Model and View accordingly.

• In ...read more

List is mutable and tuple is immutable in Python.

• List can be modified after creation, tuple cannot

• List uses square brackets [], tuple uses parentheses ()

• List is slower than tuple in terms of performance

• List is used for collections of data that may change, tuple for fixed collections

Many to many relationship is a type of relationship between two entities where one entity can have multiple instances of another entity and vice versa.

• It involves a junction table that connects the two entities.

• It allows for complex data modeling and querying.

• Example: A student can enroll in multiple courses and a course can have multiple students.

• Example: A book can have multiple authors and an author can have written multiple books.