Mastek Assistant Manager Interview Questions and Answers

Q1. Project specific ,last project technology
Add your answer

Q1. Share details of your previous job.
Ans. 
I worked as a Sales Associate at XYZ Retail Store.
• Assisted customers in finding and purchasing products.

• Managed inventory and restocked shelves.

• Handled cash transactions and operated the cash register.

• Provided excellent customer service and resolved any issues or complaints.

• Collaborated with team members to achieve sales targets.

• Trained new employees on store policies and procedures.
Answered by AI
Add your answer
Q2. Why are you looking for a change?
Ans. 
I am looking for a change to further develop my skills and take on new challenges.
• Seeking new opportunities for growth and advancement

• Interested in expanding my knowledge and experience

• Want to take on more responsibility and leadership roles

• Looking for a company with a strong culture and values

• Desire to work in a different industry or with a different product/service
Answered by AI
Add your answer
Q3. Tell me about yourself.
Ans. 
I am a highly motivated and experienced professional with a strong background in management and leadership.
• I have over 5 years of experience in supervisory roles, where I successfully led teams and achieved targets.

• I am skilled in strategic planning, problem-solving, and decision-making.

• I have a proven track record of improving operational efficiency and customer satisfaction.

• I am adept at building and maintaining stro...read more
Answered by AI
Add your answer

Q1. Javascript features
Add your answer
Q2. Virtual dom
Add your answer

Q1. WRITE A java program to find the shortest distance between 2 nodes in an array
Ans. 
Java program to find shortest distance between 2 nodes in an array of strings
• Create a method that takes in the array of strings and the two nodes as parameters

• Use a map to store the index of each node in the array

• Calculate the distance between the two nodes using their indices in the array
Answered by AI
Add your answer
Q2. Explain oops concept
Ans. 
OOPs concept is a programming paradigm based on the concept of objects, which can contain data in the form of fields and code in the form of procedures.
• OOPs stands for Object-Oriented Programming

• Key concepts include classes, objects, inheritance, polymorphism, and encapsulation

• Classes are blueprints for creating objects, which are instances of classes

• Inheritance allows a class to inherit properties and behavior from an...read more
Answered by AI
Add your answer

Q1. Salary discussion
Add your answer
Q2. Location process
Add your answer

Basic Technical questions

Q1. About queries in database
Add your answer

Q1. Questions on ref cursors and bulk collect
Add your answer
Q2. Nested table record type variable creation and their syntax.
Add your answer
Q3. Triggers and procedures and packages differences.
Add your answer
Q4. ACID properties
Ans. 
ACID properties ensure reliable transactions in databases: Atomicity, Consistency, Isolation, Durability.
• Atomicity: Transactions are all-or-nothing. Example: If a bank transfer fails, both accounts remain unchanged.

• Consistency: Transactions bring the database from one valid state to another. Example: A transaction must not violate any database rules.

• Isolation: Concurrent transactions do not affect each other. Example: ...read more
Answered by AI
Add your answer
Q5. Materialized views and db links
Add your answer
Q6. Different types of cursors
Ans. 
Cursors are database objects used to retrieve and manipulate data row by row.
• 1. Implicit Cursors: Automatically created by SQL for single SQL statements. Example: SELECT * FROM employees;

• 2. Explicit Cursors: Defined by the programmer for complex queries. Example: DECLARE cursor_name CURSOR FOR SELECT * FROM orders;

• 3. Forward-only Cursors: Can only move forward through the result set. Example: Used for simple read opera...read more
Answered by AI
Add your answer
Q7. Autonomous transaction and merge statement
Add your answer

Q1. Explain datawindow in powerbuilder
Ans. 
DataWindow is a GUI control in PowerBuilder used to display and manipulate data from a database.
• DataWindow can be used to retrieve data from a database, display it in a tabular format, and allow users to edit the data.

• It supports various data sources such as SQL, ODBC, and XML.

• DataWindow can also be used to create reports and graphs.

• It provides various features such as sorting, filtering, grouping, and computed columns...read more
Answered by AI
Add your answer