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
3.6

based on 5.6k Reviews

Filter interviews by

Hexaware Technologies SQL Database Administrator Interview Questions and Answers

Updated 12 Aug 2022

Hexaware Technologies SQL Database Administrator Interview Experiences

1 interview found

Round 1 - Technical 

(1 Question)

  • Q1. Difference between index and statistics
  • Ans. 

    Index is used to speed up data retrieval while statistics are used by the query optimizer to create an efficient query plan.

    • Indexes are created on columns to speed up data retrieval

    • Statistics are used by the query optimizer to create an efficient query plan

    • Indexes are used to enforce uniqueness and primary key constraints

    • Statistics are used to estimate the number of rows returned by a query

    • Indexes can be clustered or n...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Get ready more about sql server Basics and performnace tuning

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. HADR,PERFORMANCE TUNING
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Aug 2024. There were 8 interview rounds.

Round 1 - Assignment 

Database Management system SQL and PlSQL

Round 2 - Assignment 

Database Base Management system SQL and PlSQL

Round 3 - Aptitude Test 

Database Management system

Round 4 - Aptitude Test 

Database Management system

Round 5 - Group Discussion 

Database Management system

Round 6 - Assignment 

Database Management system

Round 7 - Case Study 

Database Base Management system

Round 8 - HR 

(5 Questions)

  • Q1. Database Management system
  • Q2. SQL and PlSQL Mango Data And Manu Database Management system
  • Q3. C Language and C++Language and Java
  • Q4. Data Analysis and Data entry
  • Q5. DBMS C,C++ Java Data Entry Ms Excel Ms Word Ms PP

Interview Preparation Tips

Interview preparation tips for other job seekers - Database Management system SQL and PlSQL and C Language and C++Language and Java And Web design and Web Developer
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. How you will find that some user SQL running slow without discussing with user?
  • Q2. How you will patch specific db components to reduce downtime?
  • Ans. 

    To patch specific db components to reduce downtime, follow these steps:

    • Identify the specific components that need to be patched

    • Plan the patching process during a scheduled maintenance window

    • Backup the database before applying patches

    • Apply patches to the specific components one by one

    • Test the patched components to ensure they are functioning correctly

    • Monitor the database for any issues post-patching

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. Why you have so many hopping in your resume?
  • Q2. How you will rate yourself as an dba?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared technically.
Be loyal in interview , if you don't know just tell
Try to be solution oriented person
Give genuine real time faced issues
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jan 2023. There were 3 interview rounds.

Round 1 - Assignment 

Scenario based Troubleshooting tasks

Round 2 - HR 

(1 Question)

  • Q1. 1. Reason for job switch 2. Why want to join HPE
Round 3 - Group Discussion 

Group discussion with Client for their feedback on candidate

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on technical certification and learn new skills

I applied via Recruitment Consultant and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

4 Questions

  • Q1. Are you aware of DevOp? How to use in producing output for client?
  • Ans. 

    Yes, DevOps is a set of practices that combines software development and IT operations to deliver high-quality software faster.

    • DevOps is a culture and set of practices that emphasizes collaboration, automation, and monitoring throughout the software development lifecycle.

    • It involves integrating development, testing, deployment, and operations teams to streamline the software delivery process.

    • By using DevOps, database a...

  • Answered by AI
  • Q2. What is the application that is better than Spark in AWS?
  • Ans. 

    AWS Glue is an application that is better than Spark in AWS.

    • AWS Glue is a fully managed extract, transform, and load (ETL) service that makes it easy to prepare and load data for analytics.

    • It provides a serverless environment for running ETL jobs and supports various data sources and destinations.

    • AWS Glue also offers automatic schema discovery, data cataloging, and data transformation capabilities.

    • It integrates well wi...

  • Answered by AI
  • Q3. How do you connect to to AWS as a developer?
  • Ans. 

    To connect to AWS as a developer, you can use the AWS Management Console, AWS CLI, or AWS SDKs.

    • Use the AWS Management Console to access AWS services through a web-based user interface.

    • Utilize the AWS Command Line Interface (CLI) to interact with AWS services using commands in the terminal.

    • Leverage AWS Software Development Kits (SDKs) to integrate AWS services into your applications.

    • For example, you can use the AWS SDK ...

  • Answered by AI
  • Q4. What is the security system of AWS access?
  • Ans. 

    AWS provides a comprehensive security system for access control.

    • AWS Identity and Access Management (IAM) allows you to manage access to AWS services and resources.

    • IAM enables you to create and manage users, groups, and roles, and assign permissions to them.

    • AWS provides various authentication methods like username/password, multi-factor authentication, and integration with external identity providers.

    • Access can be contr...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Sometimes the interviewer can be a glober - who really doesn't know what they are talking about. They will even ask you what they do not know. They can even ask you things that are NOT applicable and they will stand with it to show that they know better. Above all as a candidate for the role that you really want to go with, ensure that you are aware of what you say, be prepared for the interview as if you know nothing. Ensure that you are well informed on the line of task. Also be prepated to provide the interviewer one good project that you had already carried out based on the application required for the profile. Be calm always if the company recruit you, it is their luck as you always have ample opportunity with other company as well.

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. HADR,PERFORMANCE TUNING

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

Interview Questionnaire 

1 Question

  • Q1. About architecture? User creation? Tablespace resize and relocate? About all the backups?? About privileges? About patching?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confidents and answer the technical question with your knowledge incase I don't know anything just accept it and learn that what's that..

I applied via Referral and was interviewed in Jan 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Expert level SQL knowledge,questions on SQL queries

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and if you don't know the answer asked in interview do not panic
Just assure the interviewer that ur ready to learn anything given an opportunity
Do not fake or do not show the desperation for the job
Never tell yes to everything
Provide a stipulated time for you to learn the process

Hexaware Technologies Interview FAQs

How many rounds are there in Hexaware Technologies SQL Database Administrator interview?
Hexaware Technologies interview process usually has 1 rounds. The most common rounds in the Hexaware Technologies interview process are Technical.
How to prepare for Hexaware Technologies SQL 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 Log Shipping, SQL Server, Database Administration, Database Mirroring and High Availability.

Tell us how to improve this page.

Join Hexaware Technologies Experience the impact across your digital ecosystem and beyond.
Hexaware Technologies SQL Database Administrator Salary
based on 84 salaries
₹3.5 L/yr - ₹9.5 L/yr
22% less than the average SQL Database Administrator Salary in India
View more details

Hexaware Technologies SQL Database Administrator Reviews and Ratings

based on 3 reviews

3.2/5

Rating in categories

2.8

Skill development

2.8

Work-life balance

3.2

Salary

2.8

Job security

3.7

Company culture

3.9

Promotions

3.1

Work satisfaction

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

₹5.3 L/yr - ₹20 L/yr

System Analyst
3k salaries
unlock blur

₹6.8 L/yr - ₹29 L/yr

Software Engineer
2.9k salaries
unlock blur

₹2 L/yr - ₹10 L/yr

Senior Executive
2k salaries
unlock blur

₹0.8 L/yr - ₹6.2 L/yr

Technical Architect
1.9k salaries
unlock blur

₹10 L/yr - ₹36 L/yr

Explore more salaries
Compare Hexaware Technologies with

Cognizant

3.8
Compare

TCS

3.7
Compare

Infosys

3.7
Compare

Wipro

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