Upload Button Icon Add office photos

Applied Materials

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Applied Materials Senior Database Administrator Interview Questions and Answers

Updated 20 Dec 2021

Applied Materials Senior Database Administrator Interview Experiences

1 interview found

Interview Questionnaire 

2 Questions

  • Q1. After restoring db full backup, if tlog having LSN mismatch error wat you do?
  • Ans. 

    To resolve LSN mismatch error after restoring a full backup, you can perform a tail-log backup and restore it.

    • Perform a tail-log backup of the database.

    • Restore the tail-log backup to bring the database to a consistent state.

    • Ensure that the LSNs match between the restored full backup and the tail-log backup.

    • If the LSNs still do not match, you may need to restore a more recent full backup and apply subsequent transaction...

  • Answered by AI
  • Q2. If we got performance issue after migration wat action you will take.
  • Ans. 

    I would analyze the performance issue and take appropriate actions to resolve it.

    • Identify the specific performance issue and gather relevant data

    • Analyze the database configuration and settings

    • Review the migration process and identify any potential issues

    • Optimize queries and indexes

    • Consider hardware and infrastructure upgrades if necessary

    • Implement performance monitoring and tuning

    • Collaborate with developers and stakeho...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Good to cover all environments.

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Referral and was interviewed in Nov 2023. There were 6 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Coding Test 

Duration: 1Hour 30 Minutes, 2 Coding Questions of Total 175 Marks. 1st Question has 75 marks and 2nd Question has 100 marks.

Round 3 - Technical 

(2 Questions)

  • Q1. 1. Find the smallestMissingNumber in given array using Bitwise OR operation alone 2. Based on Array data Manipulation.
  • Ans. 

    Using Bitwise OR operation to find the smallest missing number in an array.

    • Iterate through the array and perform Bitwise OR operation with each element to set corresponding bit in a bitmask

    • Iterate through the bitmask to find the first unset bit, which represents the smallest missing number

    • Example: Array [0, 1, 3, 4, 6] would have a bitmask of 10101, smallest missing number is 2

  • Answered by AI
  • Q2. Q2: Customized Data Extraction From Given Dynamic Array & Perform Some Math Operations On the Extracted Data
Round 4 - Technical 

(1 Question)

  • Q1. Write a Pseudo code for given scenario?
  • Ans. 

    Pseudo code for a scenario

    • Define variables and data structures needed

    • Write the main logic using conditional statements and loops

    • Handle edge cases and error conditions

    • Test the pseudo code with sample inputs

  • Answered by AI
Round 5 - Technical 

(1 Question)

  • Q1. System Design & Design Pattern based questions
Round 6 - HR 

(1 Question)

  • Q1. Not Applicable (Yet to be scheduled)

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Dsa questions , angular , .net core and SQL

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't join this company if you are passionate about work
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Feb 2023. There was 1 interview round.

Round 1 - Coding Test 

OOPS Principle.
SQL
Java Coding Round - with easy level of questions

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. C questions on oops concepts
  • Q2. Python and ml questions
Round 2 - HR 

(1 Question)

  • Q1. Salary discussion
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Move the 4 cubes from middle of the screen to left, right, bottom and top. Also, it should keep rotating and stop rotation once it reaches there.
  • Ans. 

    Move rotating cubes to different positions on screen and stop rotation once reached.

    • Create 4 animations to move each cube to left, right, bottom, and top of the screen

    • Add rotation animation to each cube

    • Stop rotation animation once cube reaches the desired position

  • Answered by AI
  • Q2. 2 logical questions where asked.
Round 2 - Technical 

(2 Questions)

  • Q1. How would I integrate/embed Unity application into Android.
  • Ans. 

    Integrating Unity application into Android involves exporting the Unity project as an Android project and then integrating it with Android Studio.

    • Export the Unity project as an Android project

    • Import the project into Android Studio

    • Modify the Android manifest file to include necessary permissions and settings

    • Integrate UnityPlayerActivity into the Android application

    • Build and run the Android application on a device or emu

  • Answered by AI
  • Q2. Interviewer checked my debugging skills

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Invert bits of a number
  • Ans. 

    Invert the bits of a given number

    • Use bitwise XOR operator (^) with 1 to flip each bit

    • Repeat the process for all bits in the number

    • Return the inverted number

  • Answered by AI
  • Q2. How do you support backward compatibility whiel designing a system
  • Ans. 

    Backward compatibility can be supported by using versioning, deprecation strategies, and maintaining clear communication with users.

    • Use versioning to clearly distinguish between different versions of the system

    • Implement deprecation strategies to phase out old features gradually

    • Maintain clear communication with users about upcoming changes and provide migration paths

    • Consider using compatibility layers or adapters to bri...

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I was interviewed before Mar 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. Pointer related questions.
  • Q2. Basic puzzles
Round 2 - Coding Test 

Some question on memory management and some puzzles.

Round 3 - Coding Test 

Problems related to pointer like in this scenario what should be the output etc.

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Coding Test 

2 hours Hackerrank test, after qualifying that 2 technical rounds and 1 HR round

Round 3 - Technical 

(2 Questions)

  • Q1. 1. Dynamic Programming Question to get the min path.
  • Q2. 2. Bit manipulation questions, like find missing number in an range.

Interview Preparation Tips

Interview preparation tips for other job seekers - Basic DS and Algo for software Engineers.
But for Electronics and Communication engineers the interview level is really tough.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed before Mar 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all Resume tips
Round 2 - Technical 

(3 Questions)

  • Q1. 1. Os vitualization is asked based on your resume
  • Q2. 2. C pointes 3. hasmap
  • Q3. 4. Questions based on your resume

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare OS, C related questions from geeks for geeks
Contribute & help others!
anonymous
You can choose to be anonymous

Applied Materials Interview FAQs

How to prepare for Applied Materials Senior Database Administrator interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Applied Materials. The most common topics and skills that interviewers at Applied Materials expect are Postgresql.
What are the top questions asked in Applied Materials Senior Database Administrator interview?

Some of the top questions asked at the Applied Materials Senior Database Administrator interview -

  1. If we got performance issue after migration wat action you will ta...read more
  2. After restoring db full backup, if tlog having LSN mismatch error wat you ...read more

Recently Viewed

SALARIES

BytesView Analytics

INTERVIEWS

Times Group

No Interviews

SALARIES

Applied Materials

INTERVIEWS

Times Group

No Interviews

INTERVIEWS

Ecom Express

Fresher

5.6k top interview questions

INTERVIEWS

Applied Materials

No Interviews

SALARIES

BytesView Analytics

INTERVIEWS

Applied Materials

No Interviews

INTERVIEWS

Times Group

No Interviews

INTERVIEWS

Applied Materials

No Interviews

Tell us how to improve this page.

Interview Questions from Similar Companies

Qualcomm Interview Questions
3.8
 • 255 Interviews
Intel Interview Questions
4.2
 • 215 Interviews
Tata Electronics Interview Questions
4.0
 • 147 Interviews
Texas Instruments Interview Questions
4.1
 • 120 Interviews
Synopsys Interview Questions
3.9
 • 88 Interviews
Molex Interview Questions
3.9
 • 53 Interviews
View all
Applied Materials Senior Database Administrator Salary
based on 5 salaries
₹9.2 L/yr - ₹15.8 L/yr
14% less than the average Senior Database Administrator Salary in India
View more details
Technical Lead
254 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
125 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Manufacturing Engineer
96 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
87 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Engineer Mechanical
61 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Applied Materials with

Lam Research

3.7
Compare

KLA

3.4
Compare

ASML

3.9
Compare

Entegris

2.3
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent