i
Hughes Systique
Corporation
Filter interviews by
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
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...
Top trending discussions
I appeared for an interview before Apr 2023.
Ios round
questions asked involved questions from storages used in iOS
app life cycle
multiple app login with same creds autocomplete feature
Basic problem solving round
2 medium
1 b/w medium and hard
question were asked :
tree BFS and Stair question
dynamic programming
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...
I appeared for an interview before Jun 2024, where I was asked the following questions.
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...
I applied via Approached by Company and was interviewed before May 2023. There was 1 interview round.
Remove overlapping intervals to minimize removals.
Sort intervals by end time
Iterate through intervals, remove overlapping intervals
Return count of removed intervals
posted on 17 Sep 2024
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
I applied via Approached by Company and was interviewed in Sep 2024. There was 1 interview round.
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...
posted on 27 Sep 2024
Oop, database, spring boot, multithreading
I applied via Referral and was interviewed in Feb 2024. There was 1 interview round.
Android basic + DSA and problem solving
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 ...
I applied via Approached by Company and was interviewed in May 2024. There was 1 interview round.
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.
based on 1 interview experience
Principal Engineer
308
salaries
| ₹11.2 L/yr - ₹37.5 L/yr |
Senior Engineer
260
salaries
| ₹7.5 L/yr - ₹22 L/yr |
Senior Software Engineer
221
salaries
| ₹7.2 L/yr - ₹23 L/yr |
Software Engineer
176
salaries
| ₹4.5 L/yr - ₹14 L/yr |
Engineer
106
salaries
| ₹5.5 L/yr - ₹14.5 L/yr |
Fractal Analytics
Kiya.ai
MathCo
Innovatiview India Ltd