Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Mastek Team. If you also belong to the team, you can get access from here

Mastek Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Mastek Direct Consultant Interview Questions and Answers

Updated 4 Mar 2024

Mastek Direct Consultant Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Mar 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. General Oracle questions.
Round 2 - Behavioral 

(2 Questions)

  • Q1. What is mutated table?
  • Ans. 

    A mutated table is a table that is being modified by the same statement that is currently executing.

    • Occurs in Oracle when a trigger attempts to modify the table that the trigger is associated with

    • Can lead to ORA-04091 error in Oracle

    • Can be avoided by using a compound trigger in Oracle

  • Answered by AI
  • Q2. General questions about the previous experiences.

Interview questions from similar companies

Analyst Interview Questions & Answers

Wipro user image Anonymous

posted on 23 Feb 2021

Interview Questionnaire 

1 Question

  • Q1. Previous Project Experience

Interview Questionnaire 

1 Question

  • Q1. Related to my subject

I was interviewed in May 2021.

Interview Questionnaire 

3 Questions

  • Q1. Name
  • Q2. Place
  • Q3. Skills

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing

Analyst Interview Questions & Answers

TCS user image Anonymous

posted on 30 Aug 2022

I applied via Naukri.com and was interviewed before Aug 2021. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Why do you want to join tcs

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident enough and convey your answers crisp and clear. Try to match your current role with the position you applied for.

Analyst Interview Questions & Answers

TCS user image Anonymous

posted on 22 Jun 2021

I applied via Naukri.com and was interviewed before Jun 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. What are your contributions to the table
  • Q2. How do you shoulder challenges
  • Ans. 

    I tackle challenges by breaking them down into smaller tasks and staying focused on the end goal.

    • I analyze the challenge and identify the root cause

    • I break down the challenge into smaller, manageable tasks

    • I prioritize the tasks and create a plan of action

    • I stay focused on the end goal and remain persistent

    • I seek help or advice when needed

    • Example: When faced with a tight deadline, I prioritize tasks and delegate respons...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident a

I applied via Recruitment Consultant and was interviewed in Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Normal introduction and basic topics

Interview Preparation Tips

Interview preparation tips for other job seekers - It was nice and good, very friendly

Analyst Interview Questions & Answers

TCS user image Anonymous

posted on 30 Sep 2022

I applied via LinkedIn and was interviewed before Sep 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 

Good problemtic Skills and knowledge check and sharpness

Round 2 - Coding Test 

C Language use for programs and Oracle and Java in learning process

Round 3 - HR 

(3 Questions)

  • Q1. Any coding Question and stay for job purpose
  • Q2. Any operators working or any logical program tell
  • Ans. 

    Yes, there are many operators and logical programs used in various fields.

    • Operators like +, -, *, / are used in mathematical calculations.

    • Logical programs like if-else, switch-case are used in programming.

    • Operators like AND, OR, NOT are used in boolean logic.

    • Operators like >, <, == are used in comparisons.

    • Examples of logical programs include sorting algorithms, search algorithms, etc.

  • Answered by AI
  • Q3. Check my comutication with others

Interview Preparation Tips

Topics to prepare for TCS Analyst interview:
  • c and
Interview preparation tips for other job seekers - good guide for my job purpose so best choose to our qualification

I applied via Referral and was interviewed before May 2021. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Basic background detail and resume check
Round 2 - One-on-one 

(1 Question)

  • Q1. All about work experience earlier and knowledge about process I already worked in
Round 3 - Technical 

(1 Question)

  • Q1. Senior Manager taking deep analysis in my work related knowledge and how I'm fit for this job profile . you should have basic knowledge about capital and financial market.

Interview Preparation Tips

Interview preparation tips for other job seekers - Overall good organization if you work hard and stand out in your work you will be recognised. But there is lot of effort needed to get promoted and still your position is up not salary into that comparison

Interview Questionnaire 

2 Questions

  • Q1. What is capital market?
  • Ans. 

    Capital market is a financial market where long-term securities are traded.

    • It is a market for buying and selling long-term securities such as stocks, bonds, and mutual funds.

    • It provides a platform for companies and governments to raise funds for their long-term investments.

    • Investors can buy and sell securities in the capital market to earn returns on their investments.

    • Examples of capital markets include the New York St...

  • Answered by AI
  • Q2. What is bonds?
  • Ans. 

    Bonds are debt securities issued by companies or governments to raise capital. They pay interest to the bondholder and have a maturity date.

    • Bonds are a type of investment that involves loaning money to an entity in exchange for interest payments.

    • They are typically issued by companies or governments to raise capital for various projects or initiatives.

    • Bonds have a fixed maturity date, at which point the principal amount...

  • Answered by AI

Mastek Interview FAQs

How many rounds are there in Mastek Direct Consultant interview?
Mastek interview process usually has 2 rounds. The most common rounds in the Mastek interview process are Technical and Behavioral.
What are the top questions asked in Mastek Direct Consultant interview?

Some of the top questions asked at the Mastek Direct Consultant interview -

  1. What is mutated tab...read more
  2. General Oracle questio...read more

Tell us how to improve this page.

Mastek Direct Consultant Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
ITC Infotech Interview Questions
3.6
 • 335 Interviews
Cyient Interview Questions
3.7
 • 284 Interviews
View all
Senior Software Engineer
548 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
396 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Consultant
269 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Specialist
266 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Consultant 1
191 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Mastek with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview