Upload Button Icon Add office photos
Engaged Employer

i

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

Hughes Systique Corporation Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Hughes Systique Corporation Senior Database Administrator Interview Questions and Answers

Updated 23 Dec 2024

Hughes Systique Corporation Senior Database Administrator Interview Experiences

1 interview found

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

(3 Questions)

  • Q1. Backup and recovery for rac db instances
  • Ans. 

    Backup and recovery for RAC DB instances involves using RMAN for backups and restoring from backups in case of failures.

    • Use RMAN for taking backups of RAC DB instances

    • Implement a backup strategy that includes full, incremental, and archive log backups

    • Test the backups regularly to ensure they can be restored successfully

    • In case of failures, restore the database using RMAN backups

  • Answered by AI
  • Q2. Sql db running slow
  • Ans. 

    Identify and resolve performance issues in SQL databases through various optimization techniques.

    • Check for missing indexes; for example, use 'EXPLAIN' to analyze query plans.

    • Optimize queries by avoiding SELECT *; specify only needed columns.

    • Regularly update statistics to ensure the query optimizer has accurate data.

    • Consider partitioning large tables to improve query performance.

    • Monitor server resources (CPU, memory, di...

  • Answered by AI
  • Q3. Dataguard sync issue

Interview Preparation Tips

Interview preparation tips for other job seekers - Core dba, rac , performance, data base migration, OEM, shells scripting etc

Top trending discussions

View All
Interview Tips & Stories
1w
toobluntforu
·
works at
Cvent
Can speak English, can’t deliver in interviews
I feel like I can't speak fluently during interviews. I do know english well and use it daily to communicate, but the moment I'm in an interview, I just get stuck. since it's not my first language, I struggle to express what I actually feel. I know the answer in my head, but I just can’t deliver it properly at that moment. Please guide me
Got a question about Hughes Systique Corporation?
Ask anonymously on communities.

Interview questions from similar companies

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

I appeared for an interview before Apr 2023.

Round 1 - Coding Test 

Ios round
questions asked involved questions from storages used in iOS
app life cycle
multiple app login with same creds autocomplete feature

Round 2 - Coding Test 

Basic problem solving round
2 medium
1 b/w medium and hard
question were asked :
tree BFS and Stair question
dynamic programming

Round 3 - System design 

(1 Question)

  • Q1. Design app like whatsapp.
  • Ans. 

    Design a messaging app like WhatsApp with features for real-time communication, security, and user engagement.

    • User Authentication: Implement secure login via phone number or email.

    • Real-time Messaging: Use WebSocket for instant message delivery.

    • Media Sharing: Allow users to send images, videos, and documents.

    • Group Chats: Enable users to create and manage group conversations.

    • End-to-End Encryption: Ensure messages are enc...

  • Answered by AI
Round 4 - One-on-one 

(1 Question)

  • Q1. Basic firment round with director.

Interview Preparation Tips

Topics to prepare for Zeta Senior Software Engineer interview:
  • IOS
  • UIKit
  • dynamic programming
  • tree BFS
  • System Design
Interview preparation tips for other job seekers - Candidate should be good in Logical questions and Problem solving. should have good hands on skills in UIKit.

Senior Database Administrator Interview Questions Asked at Other Companies

Q1. What actions would you take if we encountered performance issues ... read more
asked in Teradata
Q2. Data dictionary tables and where the history Data is stored
Q3. After restoring a database from a full backup, if the transaction ... read more
asked in Nielsen
Q4. How many clustered and non-clustered indexes can be created on a ... read more
asked in Oracle
Q5. Why Standby Redo logfiles are required. How to troubleshoot node- ... read more
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I appeared for an interview before Jun 2024, where I was asked the following questions.

  • Q1. Android Core Concepts, lifecycles, kotlin concepts and custom views
  • Q2. Design a Google Calendar-like application that includes features for scheduling meetings and outline the API contracts.
  • Ans. 

    Design a scheduling application similar to Google Calendar with API contracts for meeting management.

    • User Authentication: Implement OAuth for secure login.

    • Event Creation: POST /events to create a new meeting with details like title, time, and participants.

    • Event Retrieval: GET /events/{id} to fetch details of a specific meeting.

    • Event Update: PUT /events/{id} to modify existing meeting details.

    • Event Deletion: DELETE /eve...

  • Answered by AI
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 before May 2023. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Complete Code for Ludo Game. Sort of Machine coding round.
  • Q2. Given an array of intervals and return the minimum number of intervals you need to remove to make the rest of the intervals non-overlapping.
  • Ans. 

    Remove overlapping intervals to minimize removals.

    • Sort intervals by end time

    • Iterate through intervals, remove overlapping intervals

    • Return count of removed intervals

  • Answered by AI

Skills evaluated in this interview

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

I was asked to implement lru cache which i did but still didn’t made to next round as apparently i didn’t complete the working code though in my opinion i did

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Problems related to Binary Search
  • Q2. Problem statement on BST
  • Ans. 

    Discussing Binary Search Trees (BST) and their properties, operations, and applications.

    • A BST is a binary tree where each node has at most two children.

    • For any node, values in the left subtree are less, and values in the right subtree are greater.

    • Common operations include insertion, deletion, and searching for values.

    • Example: Inserting 10, 5, 15 into a BST results in a tree with 10 as root, 5 as left child, and 15 as r...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - DSA basics
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Oop, database, spring boot, multithreading

Are these interview questions helpful?
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Need to find output of given code
  • Q2. Solve some puzzles
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 tips
Round 2 - Coding Test 

Android basic + DSA and problem solving

Round 3 - Technical 

(1 Question)

  • Q1. Android in depth
  • Ans. 

    Android is a mobile operating system developed by Google, based on the Linux kernel.

    • Android is open-source and allows developers to create applications using Java or Kotlin.

    • Android apps can be distributed through the Google Play Store or other third-party app stores.

    • Android supports a wide range of devices, from smartphones and tablets to smart TVs and wearables.

    • Android provides a rich set of APIs for accessing device ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Good culture, but security of job is a major issue here

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in May 2024. There was 1 interview round.

Round 1 - Coding Test 

HackerRank Test - 2 Medium Questions
1. Given an Array Weights of Chocolates, Find Maximum amount of Chocolate that can be saved after "d" days, if you eat half the weight of one of the chocolates every day.
2. Find Closest String with equal number of vowels and consonants.

Interview Preparation Tips

Topics to prepare for CoinDCX Senior Software Engineer interview:
  • Data Structures
  • Algorithms

Hughes Systique Corporation Interview FAQs

How many rounds are there in Hughes Systique Corporation Senior Database Administrator interview?
Hughes Systique Corporation interview process usually has 1 rounds. The most common rounds in the Hughes Systique Corporation interview process are Technical.
What are the top questions asked in Hughes Systique Corporation Senior Database Administrator interview?

Some of the top questions asked at the Hughes Systique Corporation Senior Database Administrator interview -

  1. Backup and recovery for rac db instan...read more
  2. Sql db running s...read more
  3. Dataguard sync is...read more

Tell us how to improve this page.

Overall Interview Experience Rating

5/5

based on 1 interview experience

Interview Questions from Similar Companies

Fractal Analytics Interview Questions
4.0
 • 214 Interviews
MathCo Interview Questions
3.0
 • 116 Interviews
Zeta Interview Questions
3.3
 • 74 Interviews
Kiya.ai Interview Questions
3.4
 • 50 Interviews
CoinDCX Interview Questions
3.8
 • 30 Interviews
MoEngage Interview Questions
3.9
 • 27 Interviews
Seclore Interview Questions
4.0
 • 27 Interviews
Demandbase Interview Questions
3.8
 • 18 Interviews
View all
Principal Engineer
308 salaries
unlock blur

₹11.2 L/yr - ₹37.5 L/yr

Senior Engineer
260 salaries
unlock blur

₹7.5 L/yr - ₹22 L/yr

Senior Software Engineer
221 salaries
unlock blur

₹7.2 L/yr - ₹23 L/yr

Software Engineer
176 salaries
unlock blur

₹4.5 L/yr - ₹14 L/yr

Engineer
106 salaries
unlock blur

₹5.5 L/yr - ₹14.5 L/yr

Explore more salaries
Compare Hughes Systique Corporation with

Fractal Analytics

4.0
Compare

Kiya.ai

3.4
Compare

MathCo

3.0
Compare

Innovatiview India Ltd

3.9
Compare
write
Share an Interview