Premium Employer

i

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

Hexaware Technologies Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Hexaware Technologies Oracle Database Administrator Interview Questions and Answers

Updated 22 Oct 2024

Hexaware Technologies Oracle Database Administrator Interview Experiences

2 interviews found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. How to sync primary and standby?
  • Ans. 

    Primary and standby databases can be synced using Data Guard in Oracle.

    • Configure Data Guard on primary and standby databases

    • Enable redo transport services

    • Monitor and resolve any synchronization issues

    • Perform switchover or failover when necessary

  • Answered by AI
  • Q2. Performance tuning?
Round 2 - HR 

(2 Questions)

  • Q1. Why you want to change the job?
  • Ans. 

    Seeking new challenges and growth opportunities in a dynamic environment.

    • Looking for new challenges to enhance my skills and knowledge

    • Seeking growth opportunities for career advancement

    • Interested in working in a more dynamic and innovative environment

  • Answered by AI
  • Q2. Expected salary.

Skills evaluated in this interview

Round 1 - One-on-one 

(3 Questions)

  • Q1. Tell me about your roles and responsibilities
  • Q2. How to add diskgroup in disks
  • Ans. 

    To add a diskgroup in disks, use the CREATE DISKGROUP command in Oracle ASM.

    • Ensure that the disks are initialized and partitioned

    • Use the ASMCA (ASM Configuration Assistant) or ASMCMD (ASM Command-Line Utility) to create the diskgroup

    • Specify the diskgroup name, redundancy level, and the disks to be included in the diskgroup

    • Example: CREATE DISKGROUP dg1 NORMAL REDUNDANCY DISK '/dev/sdb1', '/dev/sdc1'

  • Answered by AI
  • Q3. What will do in Real application cluater
  • Ans. 

    Real Application Cluster (RAC) is a cluster database with shared disk architecture.

    • RAC allows multiple instances to access a single database simultaneously.

    • It provides high availability and scalability.

    • RAC uses Oracle Clusterware to manage the cluster.

    • Load balancing and failover are automatic in RAC.

    • RAC requires additional hardware and software licenses.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Work hard automatically sucess will come

Skills evaluated in this interview

Oracle Database Administrator Interview Questions Asked at Other Companies

asked in Wistron
Q1. how can you recover the deleted datafiles if datafiles are not ta ... read more
asked in Wipro
Q2. 19c upgradation steps Challanges faced during upgradation. Datagu ... read more
asked in Accenture
Q3. How would you monitor a db performance with OEM AWR report?
asked in Genpact
Q4. How to select a particular row from a table.
Q5. How oracle architecture is work. How to check if user password ex ... read more

What people are saying about Hexaware Technologies

View All
fascinatingsherlock
Verified Icon
1w
works at
Hexaware Technologies
Job switch
Trying to grab an opportunity in Mumbai in BlackRock Does anyone have a reference??
Got a question about Hexaware Technologies?
Ask anonymously on communities.

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. Questions on data structures

I applied via Naukri.com and was interviewed in Jul 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Angular user defined logics and its reflection in browser, javascript consoles . Basics of java platforms jvm, java collections, SQL keys, joins, logics of data structures.

Interview Preparation Tips

Interview preparation tips for other job seekers - It was very interacting and challenging interview for me as I tried many hopes to get a job during this adverse pandemic. It really boosted my self-confidence in reaching a job by myself.Still miles to go for reaching my success rim.

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

Interview Questionnaire 

1 Question

  • Q1. Oops concept , DBMS , os and tests your problem solving skill

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep calm and if you don't know the concept accept it

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

Interview Questionnaire 

1 Question

  • Q1. Basics of computer science subjects - operating system, computer networking, DBMS, data structures and algorithms.

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on core fundamentals and keep geeksforgeeks handy.

I applied via Campus Placement and was interviewed before Feb 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 

General aptitude

Round 2 - Coding Test 

Let us C, Java

Round 3 - HR 

(1 Question)

  • Q1. Why should we hire you?

Interview Preparation Tips

Interview preparation tips for other job seekers - Stay calm, & prepare with brain instead of emotions!

I applied via Campus Placement and was interviewed before Nov 2020. There were 6 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Java basics, College Projects

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was good. Be confident and answer. If you don't know the answer, tell that without hesitation.

Software Engineer Interview Questions & Answers

NTT Data user image NIDHI PRIYADARSHINI

posted on 9 Apr 2015

Interview Questionnaire 

6 Questions

  • Q1. Tell me about your project
  • Ans. 

    Developed a web-based project management tool for a startup

    • Used React for the frontend and Node.js for the backend

    • Implemented user authentication and authorization using JWT

    • Integrated with third-party APIs such as Trello and Slack

    • Implemented real-time updates using WebSockets

    • Deployed on AWS using EC2 and RDS

  • Answered by AI
  • Q2. Write the idea or algorithm for d program of fibonacci series
  • Ans. 

    Fibonacci series is a sequence of numbers where each number is the sum of the two preceding ones.

    • Start with 0 and 1 as the first two numbers

    • Add the previous two numbers to get the next number

    • Repeat until desired number of terms

  • Answered by AI
  • Q3. One question from your subject
  • Q4. Introduce yourself
  • Ans. 

    I am a software engineer with experience in developing web applications and mobile apps.

    • Proficient in programming languages such as Java, Python, and JavaScript

    • Skilled in using frameworks like React, Angular, and Spring Boot

    • Experienced in working with databases such as MySQL and MongoDB

    • Familiar with Agile development methodologies and DevOps practices

  • Answered by AI
  • Q5. If I give you a box full of pencils..in how many ways can you use it
  • Ans. 

    There are numerous ways to use a box full of pencils depending on the context and purpose.

    • Pencils can be used for writing, drawing, sketching, coloring, shading, and more.

    • They can be used for artistic purposes, schoolwork, office work, or personal use.

    • Pencils can also be used as a tool for measurement, as a makeshift stylus, or even as a musical instrument.

    • The number of ways to use a box full of pencils is virtually li...

  • Answered by AI
  • Q6. Do you have any question for me

Interview Preparation Tips

Round: Test
Experience: Time management is very important to clear the aptitude test. Besides this a lot of practice is also very important.  This round is the major filteration round. Though each round is a major filteration round cuz NTT DATA is not a bulk recruiter like cts, infy etc. Almost 2-3 thousand students were there for this round from 6 different colleges and only 100 of them were selected.
Tips: Its better to start with the preparation from before and do consider the previous year placement papers available at indiabix. You can practice more n more. Apart from this you can go through the r.s aggarwal aptitude book also.

Round: Group Discussion
Experience: There were many panels and each panel had 10-12 students. The H.r first decided some other topic but when he asked wether everybody is aware of the topic ..there were few who didn't know about it. .so he picked up another topic. Fortunately he asked me to start with the discussion.  Always try to be the one to break the ice.
Tips: The only key to crack this round is that yku should talk. You should definitely not confuse gd with debate. You should not argue or by any chance shouldn't sound arrogant.

Round: Technical Interview
Experience: They will definitely ask about your project so be thorough with that. Ntt data is a Japanese company . Though this is IT but it will ask  from the subject of your own choice from people those who have a non IT background. After you get shortlisted in d gd they will give you a form to fill. Do fill that form without fail. If it is blank then even if u go to the hr round he will reject you.
Tips: Just be confident and always smile. Be careful on what you write in your resume cuz they can ask about anything based on your resume.

Round: HR Interview
Experience: This round was a cake walk. Just be confident and updated about the company.  Do ask him a question if he asks you to do that.but make sure it shouldn't be vague or out of the picture.
Tips: Keep smiling and don't get nervous.  If they ask you about location preferences,  dun get firm at one place.try to be flexible.

General Tips: Donot loose hope at any cost. You never know when your moment is going to arrive. Do practice the aptitude as much as you can. Finally NTT DATA selected only 50 overall in wch 11 were from my college n i was lucky to be one of them. the offer letter was issued the same day and we were all venerated.  Its just a game of confidence. All the best
Skill Tips: Try to add some co curricular activities and justify your role.
Skills: communication, technical knowledge, management skills, leadership
College Name: SATHYABAMA UNIVERSITY
Motivation: You will find the it companies mostly head quartered in U.S but this company is in Japan. Plus you have better opportunity and growth compared to other companies cuz its not a bulk recruiter.

Skills evaluated in this interview

Interview Questionnaire 

2 Questions

  • Q1. Java ( socket programming, OOPS, DS )
  • Q2. Write about your dream
  • Ans. 

    My dream is to build innovative software solutions that positively impact people's lives.

    • Developing cutting-edge technology

    • Creating user-friendly interfaces

    • Solving complex problems

    • Collaborating with talented individuals

    • Making a difference in society

    • Continuous learning and growth

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: GRE givers , you can make it through this. Brush up your technical skills for the programming section.
Tips: GRE quant and verbal and quick review from tutorialspoint.com would do the trick.

Round: Group Discussion
Experience: I had fun. I won a few debate competitions in various technical symposiums so, It gave a good experience about being quiet at the right moment.
Tips: Turn to your GRAB-ON mode. Never miss any chance. Learn to know when to be quiet and when to talk in a GD. Try to bring down the heat If two participants are getting into a argumentative discussion.

Round: Stress Interview
Experience: It was really difficult. Exactly after the GD, we were asked to right an essay in a very less time and our capability to manage the stress was observed.
Tips: Be calm and write all that you know in a presentable way.

Round: Technical Interview
Experience: I did a project in my 3rd year which included few concepts on Socket programming which helped me a bit in this round. I answered confidently and I was put to a confidence test too to see how sure I was about the answer.
Tips: A quick review on the day of interview and involving in friendly discussion about programming languages before the test helps.

Round: HR Interview
Experience: I was asked few technical questions in this round and later moved on to the general logical questions. Questions like, cutting a bread into multiple slices, finding the corresponding switch among 3 switches for 3 bulbs in room were asked. Find the sum of 1-10 in 4 seconds was asked suddenly. Thanks to Arithmetic Progressions :P.
Tips: Use your logical ability to answer.

Skills: Java, C, Body Language, Mental ability, Confidence.
College Name: Malla Reddy Institute of Engineering & Technology ( MRIET )
Motivation: Ranked among the top 50 of the Fortune 500. Expanding organizations which include lot of opportunities.

Hexaware Technologies Interview FAQs

How many rounds are there in Hexaware Technologies Oracle Database Administrator interview?
Hexaware Technologies interview process usually has 1-2 rounds. The most common rounds in the Hexaware Technologies interview process are One-on-one Round, Technical and HR.
How to prepare for Hexaware Technologies 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 Hexaware Technologies. The most common topics and skills that interviewers at Hexaware Technologies expect are Oracle DBA, Datapump, Migration, Oracle and Oracle RAC.
What are the top questions asked in Hexaware Technologies Oracle Database Administrator interview?

Some of the top questions asked at the Hexaware Technologies Oracle Database Administrator interview -

  1. How to sync primary and stand...read more
  2. What will do in Real application clua...read more
  3. How to add diskgroup in di...read more

Tell us how to improve this page.

Hexaware Technologies Oracle Database Administrator Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
Join Hexaware Technologies Experience the impact across your digital ecosystem and beyond.
Hexaware Technologies Oracle Database Administrator Salary
based on 41 salaries
₹4.5 L/yr - ₹15.8 L/yr
34% more than the average Oracle Database Administrator Salary in India
View more details

Hexaware Technologies Oracle Database Administrator Reviews and Ratings

based on 3 reviews

4.0/5

Rating in categories

3.0

Skill development

4.9

Work-life balance

4.0

Salary

2.1

Job security

4.0

Company culture

1.1

Promotions

4.0

Work satisfaction

Explore 3 Reviews and Ratings
Senior Software Engineer
3.8k salaries
unlock blur

₹5.5 L/yr - ₹20.1 L/yr

System Analyst
2.9k salaries
unlock blur

₹7.7 L/yr - ₹29 L/yr

Software Engineer
2.9k salaries
unlock blur

₹2 L/yr - ₹10 L/yr

Senior Executive
2.2k salaries
unlock blur

₹0.8 L/yr - ₹6.1 L/yr

Technical Architect
2k salaries
unlock blur

₹10 L/yr - ₹37 L/yr

Explore more salaries
Compare Hexaware Technologies with

Cognizant

3.7
Compare

TCS

3.7
Compare

DXC Technology

3.7
Compare

Mphasis

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