Filter interviews by
I applied via Naukri.com and was interviewed in Sep 2022. There were 3 interview rounds.
Recovering deleted datafiles without backup
Check if the datafiles are still in the operating system's recycle bin or trash folder
Use data recovery software to scan the hard drive for deleted files
If the above methods fail, try to recreate the datafiles using the CREATE DATAFILE command
If the tablespace is still intact, use the RMAN RECOVER TABLESPACE command to recover the data
To check DR DC sync, use Data Guard Broker or query V$DATAGUARD_STATS view.
Use Data Guard Broker to check the status of the standby database and its synchronization with the primary database.
Query V$DATAGUARD_STATS view to check the redo apply lag and transport lag between the primary and standby databases.
Check the alert log files of both primary and standby databases for any errors or warnings related to data synchro...
ER diagrams are visual representations of entities and their relationships in a database.
ER stands for Entity-Relationship
ER diagrams are used to design and model databases
Entities are represented as rectangles, relationships as diamonds, and attributes as ovals
Examples of entities include customers, orders, and products
Examples of relationships include one-to-one, one-to-many, and many-to-many
Cold backup is taken when the database is offline while hot backup is taken when the database is online.
Cold backup is taken when the database is shut down and all files are copied to a backup location.
Hot backup is taken while the database is still running and all files are copied to a backup location.
Cold backup is slower and requires downtime while hot backup is faster and does not require downtime.
Cold backup is mo...
To connect to RMAN, use the 'rman' command in the command prompt or terminal.
Open the command prompt or terminal
Type 'rman' and press enter
Enter the username and password for the target database
Use the 'connect' command to connect to the target database
Use the 'run' command to execute RMAN commands
Top trending discussions
I applied via Recruitment Consultant and was interviewed before Oct 2020. There were 5 interview rounds.
Developed a web-based project management tool for a software development company.
Used Agile methodology for project management
Implemented user authentication and authorization
Integrated with third-party tools like JIRA and GitHub
Provided real-time project progress tracking
Generated reports for project analysis
I applied via Campus Placement and was interviewed in Feb 2022. There were 2 interview rounds.
It was aptitude and technical MCQ questions round
I appeared for an interview in Jan 2021.
Round duration - 30. minutes
Round difficulty - Easy
It was in the evening, question were moderate
Given an integer array ARR
of size N
, your task is to find the total number of subsequences in which all elements are equal.
A subsequence of an array i...
Count the total number of subsequences in which all elements are equal in an integer array.
Iterate through the array and count the frequency of each element.
Calculate the total number of subsequences for each element using the formula (frequency * (frequency + 1) / 2).
Sum up the total number of subsequences for all elements and return the result modulo 10^9 + 7.
Round duration - 30 minutes
Round difficulty - Easy
It was in the night around 9:00 PM.
You are given an integer array 'ARR' of size 'N' and an integer 'S'. Your task is to find and return a list of all pairs of elements where each sum of a pair equals 'S'.
Given an array and a target sum, find all pairs of elements that add up to the target sum.
Iterate through the array and for each element, check if the complement (target sum - current element) exists in a hash set.
If the complement exists, add the pair to the result list.
Sort the pairs based on the first element and then the second element.
Return the list of pairs as the final result.
Tip 1 : Learn new things daily
Tip 2 : Practice questions
Tip 3 : Keep one question in mind to solve.
Tip 1 : Description about your skills
Tip 2 : Project details
I applied via LinkedIn and was interviewed in Aug 2024. There was 1 interview round.
2 coding questions one was greedy and 2nd one was of dp.
I applied via Other and was interviewed before Oct 2019. There were 3 interview rounds.
In critical situations, prioritize clear communication, empathy, and a focus on solutions to maintain customer trust.
Acknowledge the issue promptly to show the customer you are aware and concerned.
Provide a clear explanation of the problem, avoiding technical jargon that may confuse the customer.
Offer a solution or a plan of action, detailing the steps you will take to resolve the issue.
Keep the customer updated on pro...
I applied via Company Website and was interviewed before Apr 2021. There were 3 interview rounds.
I'm seeking new challenges and opportunities for growth that align with my career goals and aspirations.
Desire for professional growth: I'm looking to expand my skill set and take on more leadership responsibilities.
Seeking a better cultural fit: I want to work in an environment that values collaboration and innovation.
Interest in new technologies: I'm excited about the opportunity to work with cutting-edge technologie...
I bring a unique blend of technical expertise, leadership skills, and a passion for innovation that aligns with your company's goals.
Proven track record of leading successful projects, such as the recent migration of a legacy system to a cloud-based solution, improving efficiency by 30%.
Strong problem-solving skills demonstrated through my role in optimizing a critical application, reducing downtime by 40% and enhancin...
I applied via Naukri.com and was interviewed before Sep 2021. There were 3 interview rounds.
Understand cultural differences, build relationships, communicate clearly and respectfully.
Research and learn about Chinese culture and customs.
Be patient and build relationships before discussing business.
Communicate clearly and respectfully, avoiding direct confrontation.
Be aware of nonverbal communication and body language.
Use a translator if necessary.
Be prepared for negotiations and understand the importance of sa...
based on 1 review
Rating in categories
Junior Engineer
618
salaries
| ₹2 L/yr - ₹4.8 L/yr |
Operator
388
salaries
| ₹1.2 L/yr - ₹3.5 L/yr |
Engineer Trainee
333
salaries
| ₹2 L/yr - ₹3.5 L/yr |
Engineer
225
salaries
| ₹2.5 L/yr - ₹6.5 L/yr |
Quality Engineer
137
salaries
| ₹1.7 L/yr - ₹5.8 L/yr |
Flex
Foxconn
Dixon Technologies
ECIL