mPHATEK Systems Interview Questions, Process, and Tips

Q1. Explain OOPS concepts with real time example
Ans. 
OOPS concepts are fundamental principles in object-oriented programming that help in organizing and designing code efficiently.
• Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: a car object with properties like color and methods like start() and stop().

• Inheritance: Allowing a class to inherit properties and behavior from another class. Example: a class Animal can inherit fro...read more
Answered by AI
Add your answer

Q1. Explain project in details
Ans. 
Developed a web-based project management tool for tracking tasks and deadlines.
• Used HTML, CSS, and JavaScript for front-end development

• Utilized Node.js and Express for back-end development

• Implemented MongoDB for database management

• Incorporated user authentication and authorization features

• Integrated real-time updates using WebSockets
Answered by AI
Add your answer

Q1. Family background , salary discussion
Add your answer

Q1. - Profile - KRA - Campaign for CTO
Add your answer

Q1. - Profile - Work ethics
Add your answer

Q1. What API contract
Ans. 
API contract defines the rules and requirements for interacting with an API.
• API contract specifies the endpoints, methods, parameters, and data formats that can be used to access the API.

• It also includes information on authentication, rate limits, error handling, and versioning.

• Developers must adhere to the API contract to ensure proper communication and functionality.

• Examples: RESTful APIs typically have a clear API c...read more
Answered by AI
Add your answer
Q2. What is OpenAPI specification
Ans. 
OpenAPI specification is a standard for defining RESTful APIs.
• OpenAPI specification allows developers to describe APIs in a standardized format using YAML or JSON.

• It includes information such as endpoints, parameters, request/response formats, authentication methods, etc.

• Tools like Swagger UI can generate interactive API documentation based on OpenAPI specifications.
Answered by AI
Add your answer
Q3. How to do load balancing in Kubernetes
Ans. 
Load balancing in Kubernetes is achieved using a service called Kubernetes Service.
• Create a Kubernetes Service object with a type of 'LoadBalancer'

• The Service will automatically create an external load balancer that will distribute traffic to the pods in the service

• The load balancer will route traffic based on the service's selector
Answered by AI
Add your answer
Q4. How to make rate limiting
Ans. 
Rate limiting can be implemented using techniques like token bucket algorithm or sliding window algorithm.
• Implement token bucket algorithm to limit the number of requests a user can make within a certain time frame.

• Use sliding window algorithm to track the number of requests made in a specific time window and reject requests that exceed the limit.

• Consider using libraries like Guava RateLimiter in Java for easy implemen
Answered by AI
Add your answer
Q5. Give example for API versioning
Ans. 
API versioning is a practice of managing different versions of an API to ensure compatibility and smooth transitions for users.
• Use URL paths to differentiate between different versions of the API (e.g. /v1/resource vs /v2/resource)

• Include version information in the request headers (e.g. Accept header)

• Implement versioning through query parameters (e.g. /resource?version=1)

• Use custom media types to specify API versions (
Answered by AI
Add your answer

Aptitude test was quite easy it has same question as in amcat exam

Its difficult round only few students get selected

Q1. Tell me about yourself, describe your memorial day?, are you a team player?
Add your answer

Q1. SQL aggregate function
Add your answer
Q2. Difference between delete, truncate and drop
Ans. 
Delete removes rows from a table, truncate removes all rows from a table, drop removes a table from the database.
• Delete is a DML command which removes specific rows from a table.

• Truncate is a DDL command which removes all rows from a table but keeps the table structure.

• Drop is a DDL command which removes an entire table from the database.

• Delete can be rolled back, truncate cannot be rolled back, drop cannot be rolled b...read more
Answered by AI
Add your answer
Q3. What are types of joins and use of join with example
Ans. 
Types of joins in SQL include inner join, outer join, left join, and right join.
• Inner join: returns rows when there is a match in both tables

• Outer join: returns all rows when there is a match in one of the tables

• Left join: returns all rows from the left table and the matched rows from the right table

• Right join: returns all rows from the right table and the matched rows from the left table
Answered by AI
Add your answer
Q4. What is normalization
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down data into smaller, more manageable tables

• It helps in reducing data redundancy by storing data in a structured way

• Normalization ensures data integrity by avoiding update anomalies

• There are different normal forms like 1NF, 2NF, 3NF, etc.

• Example: In a database, instead of stori...read more
Answered by AI
Add your answer

Q1. Details about the company
Add your answer
Q2. Salary expectations and other things
Add your answer