Mphasis Interview Questions, Process, and Tips

Design pattern is a reusable solution to a commonly occurring problem in software design.

• Design patterns help in creating efficient, maintainable, and scalable software.

• They provide a common language for developers to communicate and understand each other's code.

• Examples of design patterns include Singleton, Factory, Observer, and Strategy patterns.

Hashmap is a data structure that stores key-value pairs and allows for fast retrieval of values based on keys.

• Hashmap uses a hash function to map keys to indices in an array.

• Collision handling is important in hashmap implementation.

• Java provides a built-in Hashmap class for easy implementation.

Procedures and functions are stored routines in a database that can be called to perform specific tasks.

• Procedures are a set of SQL statements that perform a specific task. They can have input and output parameters.

• Functions are similar to procedures but return a value. They can be used in SQL queries like any other function.

• Both procedures and functions can improve code reusability and maintainability in a database sy

A trigger is a special kind of stored procedure that is automatically executed when certain events occur in a database.

• Triggers are used to maintain data integrity by enforcing business rules or cascading changes.

• They can be set to execute before or after INSERT, UPDATE, or DELETE operations.

• Examples include auditing changes to a table, updating related records in other tables, or enforcing constraints.

A database is a structured collection of data that is stored and accessed electronically.

• Database organizes and stores data in tables

• It allows for efficient retrieval, insertion, and updating of data

• Examples include MySQL, Oracle, MongoDB

Primary key is a unique identifier for each record in a database table.

• Primary key ensures each record in a table is uniquely identified.

• It must have a unique value for each record.

• Primary key can be a single column or a combination of columns.

• Examples: ID column in a user table, combination of first name and last name in an employee table.