Upload Button Icon Add office photos

IMPACT Infotech

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

IMPACT Infotech Oracle Database Administrator Interview Questions and Answers

Updated 24 Jun 2020

IMPACT Infotech Oracle Database Administrator Interview Experiences

1 interview found

I applied via Recruitment Consultant

Interview Questionnaire 

2 Questions

  • Q1. Architecture of database,cloning,flashback,catalog Database,monitoring of database,backup,restoration,export,import
  • Q2. Architecture of Oracle Database,Managing of controlfile,Datafile,redologfile,archicivelogfile,cloning,flashback,catalog Database,monitoring of database,backup,restoration,export,import

Interview Preparation Tips

Interview preparation tips for other job seekers - As a Oracle Database Administrator you should must be prepared with your hands on knowledge,i had not much time for prepration because my interview scheduled under 1 hour .also Theoretical knowledge, I had completed both important Round technical and client Side Round my interview 45and 30 minutes.Those is very intresting and typical interviews so my request is to all resources please you should must be prepare for give any time interview.

Interview questions from similar companies

I was interviewed before Sep 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 140 minutes
Round difficulty - Medium

Test timing was at 2:00 pm , it was conducted in a college and the environment was good for the test. Camera was a primary part of test, so no suspicious activity.

  • Q1. 

    Sum of Two Numbers Represented as Arrays

    Given two numbers in the form of two arrays where each element of the array represents a digit, calculate the sum of these two numbers and return this sum as an ar...

  • Ans. 

    Given two numbers represented as arrays, calculate their sum and return the result as an array.

    • Iterate through the arrays from right to left, adding digits and carrying over if necessary

    • Handle cases where one array is longer than the other by considering the remaining digits

    • Ensure the final sum array does not have any leading zeros

  • Answered by AI
Round 2 - Face to Face 

Round duration - 20 minutes
Round difficulty - Easy

The round was conducted at around 12 p.m. I was called at the college location and then it was conducted. The interviewer was quite polite and frank.

Round 3 - HR 

Round duration - 8 minutes
Round difficulty - Easy

This round was conducted right after finishing and clearing the technical round at the same place and on the same day.

Interview Preparation Tips

Eligibility criteriaAbove 60 %Wipro Limited interview preparation:Topics to prepare for the interview - OOPS, Data Structures, Database Concepts, Coding problemsTime required to prepare for the interview - 2-3 monthsInterview preparation tips for other job seekers

Tip 1 : Practice atleast 2-3 Coding problems daily so your logic building becomes stronger.
Tip 2 : Exercise problems based on OOPS concepts and others too.
Tip 3 : If you can have your own project built, then it's the major point and will act as a plus point.

Application resume tips for other job seekers

Tip 1 : Your resume should be in standard form, short and simple will be more effective.
Tip 2 : Whatever you have learned, you need to mention it in your resume as that will be your primary source of selection and having project on your resume is important.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Hr

Interview Preparation Tips

Interview preparation tips for other job seekers - You should be true to what you are putting before the interviewer . Try to put your ideas Add something you did well in your career like in projects /research which you know very well and versed in concepts about it for open interview so that interviewer can get bandwidth where he can ask questions from. This is simply a key .

I applied via Campus Placement and was interviewed in Dec 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. 1.Describe a situation where you have taken a quick decision and failed, and a situation where you succeeded. 2. What is a skill you have tried to achieve but failed? 3. Describe a decision you have taken ...

Interview Preparation Tips

Interview preparation tips for other job seekers - 1. Always try to take risk in small problems . When you face the consequences, you would be able to tackle bigger problems.
2. Every skill you learn, even if you didn't excel in it is not to be considered a waste of time/failure, you learn something simply by participating.

I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Tell me about Yourself, some questions related to machine learning, and I was asked more questions to differentiate like differences between ml and ai, python and c, c and java and procedural and functiona...

Interview Preparation Tips

Interview preparation tips for other job seekers - Get a complete grip on your resume and be confident about what you say, If you don't know the answer it is okay to agree that you don't know the answer so that interviewer can ask the next questions.

I applied via Job Portal and was interviewed before Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Oops Concepts,JAVA 8

Interview Preparation Tips

Interview preparation tips for other job seekers - Quite simple and easy. 1st round technical.2nd round HR

I applied via Campus Placement and was interviewed before Aug 2021. There were 2 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 

Easy DSA questions and some questions on resume

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't join if you are a fresher and want to grow as a developer. I had resigned that time I am writing this review

I applied via Campus Placement and was interviewed in Mar 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. How do you get the second to last element from a SQL table?
  • Ans. 

    To get the second to last element from a SQL table, use the OFFSET-FETCH clause.

    • Use the ORDER BY clause to sort the table in descending order.

    • Use the OFFSET-FETCH clause to skip the last row and fetch the second to last row.

    • Example: SELECT column_name FROM table_name ORDER BY column_name DESC OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY;

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice by building a simple full stack web application.

Skills evaluated in this interview

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

Round 1 - Technical 

(1 Question)

  • Q1. C language and Java questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be ready with good technical skills to face the interview

Interview Questionnaire 

1 Question

  • Q1. Drupal data migration
Contribute & help others!
anonymous
You can choose to be anonymous

IMPACT Infotech Interview FAQs

How to prepare for IMPACT Infotech Oracle 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 IMPACT Infotech. The most common topics and skills that interviewers at IMPACT Infotech expect are Database Administration, Oracle DBA, Oracle RAC and Performance Monitoring.
What are the top questions asked in IMPACT Infotech Oracle Database Administrator interview?

Some of the top questions asked at the IMPACT Infotech Oracle Database Administrator interview -

  1. Architecture of database,cloning,flashback,catalog Database,monitoring of datab...read more
  2. Architecture of Oracle Database,Managing of controlfile,Datafile,redologfile,ar...read more

Recently Viewed

INTERVIEWS

Teamware Solutions

No Interviews

SALARIES

Conneqt Business Solutions

INTERVIEWS

Accurate Background

No Interviews

INTERVIEWS

Accurate Background

No Interviews

DESIGNATION

SALARIES

Conneqt Business Solutions

SALARIES

Conneqt Business Solutions

INTERVIEWS

Teamware Solutions

No Interviews

INTERVIEWS

ABC Consultants

No Interviews

SALARIES

Spectrum Talent Management

Tell us how to improve this page.

IMPACT Infotech Oracle Database Administrator Salary
based on 6 salaries
₹1.9 L/yr - ₹4.5 L/yr
53% less than the average Oracle Database Administrator Salary in India
View more details

IMPACT Infotech Oracle Database Administrator Reviews and Ratings

based on 2 reviews

3.0/5

Rating in categories

3.0

Skill development

3.0

Work-life balance

2.5

Salary

2.5

Job security

2.0

Company culture

1.5

Promotions

2.5

Work satisfaction

Explore 2 Reviews and Ratings
Desktop Support Engineer
304 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Network Engineer
139 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Desktop Support Engineer L2
133 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Support Engineer
57 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

System Administrator
44 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare IMPACT Infotech 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