TechMantra Gulf DMCC Interview Questions and Answers

A question that is both tricky and simple.

Q1. Questions about biochemistry
Add your answer

Questions based on both numerical data and case studies.

Q1. Can you tell me about yourself?
Add your answer
Q2. What interests you in working for this company?
Ans. 
I am interested in working for this company because of its innovative projects and strong reputation in the industry.
• Innovative projects that challenge me to grow as a programmer

• Strong reputation in the industry for quality work

• Opportunities for career advancement and professional development
Answered by AI
Add your answer

Q1. All employees having same salary in the smae department sql and pysprk
Add your answer
Q2. How to create pipeline in databricks
Ans. 
To create a pipeline in Databricks, you can use Databricks Jobs or Apache Airflow for orchestration.
• Use Databricks Jobs to create a pipeline by scheduling notebooks or Spark jobs.

• Utilize Apache Airflow for more complex pipeline orchestration with dependencies and monitoring.

• Leverage Databricks Delta for managing data pipelines with ACID transactions and versioning.
Answered by AI
Add your answer
Q3. Palindrome, 2nd char in every word make is to upper case, sql rank and dense rank releated questions , given 2 tables country and city we need to calculate total population in each continent by joining the...read more
Add your answer
Q4. String manuplation questions inpython
Add your answer

DSA- 1easy, 1 medium

Q1. Project discussion
Add your answer
Q2. DBMS views
Add your answer
Q3. Hibernate
Add your answer
Q4. What happens when u enter www.google.com
Add your answer
Q5. Authentication
Add your answer
Q6. What is socket
Add your answer
Q7. Bubble sort and time complexity
Add your answer

Q1. What is an abstract class?
Ans. 
An abstract class is a class that cannot be instantiated and may contain abstract methods that must be implemented by its subclasses.
• Cannot be instantiated directly

• May contain abstract methods

• Used as a blueprint for other classes
Answered by AI
Add your answer
Q2. What is abstraction?
Ans. 
Abstraction is the process of hiding complex details and showing only the essential features of an object or system.
• Abstraction allows us to focus on what an object does, rather than how it does it

• It helps in simplifying complex systems by breaking them down into smaller, more manageable parts

• Examples of abstraction include using a car without needing to understand its internal combustion engine, or using a smartphone
Answered by AI
Add your answer
Q3. Best sorting algo?time complexity of it?
Ans. 
QuickSort is one of the best sorting algorithms with an average time complexity of O(n log n).
• QuickSort is a divide and conquer algorithm that works by selecting a 'pivot' element and partitioning the array around the pivot.

• It has an average time complexity of O(n log n) and a worst-case time complexity of O(n^2).

• Example: ['apple', 'banana', 'cherry', 'date', 'fig'] can be sorted using QuickSort.

• Example: ['3', '1', '4'...read more
Answered by AI
Add your answer
Q4. You have been provided a sorted list time complexity achieved after we apply bubble sorting
Ans. 
Bubble sorting has a time complexity of O(n^2) for a sorted list.
• Bubble sorting has a worst-case time complexity of O(n^2) for a sorted list.

• The time complexity does not change even if the list is already sorted.

• Example: If we have a sorted list of size n, bubble sorting will still take O(n^2) time.
Answered by AI
Add your answer

Q1. Have you ever been to a state other than jharkhand?
Ans. 
Yes, I have been to multiple states other than Jharkhand.
• I have traveled to states like Maharashtra, Karnataka, and Tamil Nadu for work and leisure.

• I have visited tourist destinations in states like Rajasthan, Kerala, and Himachal Pradesh.

• I have family in states like Uttar Pradesh, Bihar, and West Bengal, which I have visited multiple times.
Answered by AI
Add your answer

Q1. What are Agile Values? Scrum Values? Scrum Ceremonies? Story Points?
Ans. 
Agile values include individuals and interactions over processes and tools, while Scrum values include commitment, courage, focus, openness, and respect.
• Agile values prioritize individuals and interactions over processes and tools

• Scrum values include commitment, courage, focus, openness, and respect

• Scrum ceremonies include Sprint Planning, Daily Standup, Sprint Review, and Sprint Retrospective

• Story points are a unit of...read more
Answered by AI
Add your answer
Q2. As project manager what docs do you prepare? How do you contribute as a PM?
Ans. 
As a project manager, I prepare various documents such as project plans, schedules, budgets, risk assessments, and progress reports. I contribute by leading the team, managing resources, and ensuring project success.
• Prepare project plans outlining scope, objectives, deliverables, and timelines

• Create schedules to allocate tasks and track progress

• Develop budgets to manage project costs effectively

• Conduct risk assessments...read more
Answered by AI
Add your answer
Q3. Capacity? Velocity? etc Agile/Scrum-based questions (bookish) this round was taken by Rajni
Add your answer

Q1. Megha took my final round and asked me questions about Agile/Scrum, Stroy Points (estimation).
Add your answer
Q2. Ques on explaining Sprint Planning, Retro, Review, using Doc/Excel (screen sharing)
Add your answer
Q3. Ques on Conflict and Resource Management, some scenario-based question.
Add your answer
Q4. How will you make a low-performing resource a high-performing one?
Ans. 
Provide clear expectations, offer support and training, provide feedback and recognition, set goals and milestones.
• Clearly communicate expectations and goals to the resource.

• Offer support and training to help the resource improve their skills and knowledge.

• Provide regular feedback and recognition for progress made.

• Set specific goals and milestones to track improvement.

• Create a development plan with the resource to addr...read more
Answered by AI
Add your answer
Q5. Megha did not hire me because she felt I had adequate knowledge and practical experience. (insecurities) Anyway, good luck with your interview.
Add your answer
Q6. What is Scrum of Scrums? What is PI planning?
Ans. 
Scrum of Scrums is a scaled agile framework where multiple Scrum teams coordinate their work. PI planning is a key event in SAFe where teams plan their work for the upcoming Program Increment.
• Scrum of Scrums involves representatives from each Scrum team meeting regularly to discuss dependencies and progress.

• PI planning is a two-day event where teams align on their objectives, dependencies, and priorities for the upcomi...read more
Answered by AI
Add your answer

Assesses the ability to understand and process written information through reading comprehension, logical connections between words, and argument analysis.

Describe the structure of the test, such as the number of question of the type of question its the programming concept data structure.

Now a day most the selectors stick to structured from of group discussion structured group discussion is a style where topic is thrown to the candidates by the selectors.

The images displays the word assignment on a button like shape, likely from a digital interface. It appears to be a label or a clickable element related to tasks or schoolwork.

A case study is a research method involving an up cloes in depth, and detailed examination of a particular case. Within a real world contex.

Q1. As a resource is the department within a company that is responsible for managing employee.
Add your answer
Q2. This includes tasks such as recruiting, hiring, training, and handling employee relations.
Add your answer

Q1. A technical could refer to the technical aspects of a topic, field, or system.
Add your answer
Q2. In the context of the webpage it was found an, it refers to the technical element of VR chat development
Add your answer

Q1. This likely refer to a stage in a competition,
Add your answer
Q2. This likely interview proces, or other selection event where individuals are evaluated separately.
Add your answer

Q1. What is Docker,image vs containers,mutistage,terraformstatebackend
Ans. 
Docker is a platform for developing, shipping, and running applications using containers. Images are templates for containers, multistage builds optimize Dockerfiles, and Terraform state backend stores infrastructure state.
• Docker is a platform that allows developers to package applications and their dependencies into containers for easy deployment and scalability.

• Images are read-only templates used to create containers...read more
Answered by AI
Add your answer
Q2. What is diff cloud formation vs terraform, release management like blue green etc.
Ans. 
CloudFormation and Terraform are both infrastructure as code tools, while blue-green release management is a deployment strategy.
• CloudFormation is a service provided by AWS for creating and managing AWS resources using templates written in JSON or YAML.

• Terraform is an open-source tool by HashiCorp that allows you to define and provision infrastructure using a declarative configuration language.

• Blue-green deployment is ...read more
Answered by AI
Add your answer

1. String input="aaabccccbbbdd";
Find how many a, b, c, d are there in the string. Did using java streams.
2.HashMaphm=new HashMap();
hm.put(55,"B");
hm.put(33,"Z");
hm.put(44,"M");
hm.put(99,"I");
hm.put(88,"X");
Sort this hashmap based on values(B, I, M, X, Z). Should be done using java streams.
3.List lists = Arrays.asList(Arrays.asList(1,2,3), Arrays.asList(2,3,4,5), Arrays.asList(5,7,8));
Question was wrong actually. But expectation is to do flatmap and print without duplicates.
Query:
get 3rd highest salary from employee table