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 Company Website and was interviewed before Apr 2021. There were 3 interview rounds.
I applied via Other and was interviewed before Oct 2019. There were 3 interview rounds.
I applied via Approached by Company and was interviewed in May 2022. There were 3 interview rounds.
based on 1 review
Rating in categories
Junior Engineer
586
salaries
| ₹1.5 L/yr - ₹5 L/yr |
Operator
379
salaries
| ₹0.8 L/yr - ₹3.5 L/yr |
Engineer Trainee
333
salaries
| ₹2 L/yr - ₹3.6 L/yr |
Engineer
238
salaries
| ₹2.3 L/yr - ₹7 L/yr |
Senior Engineer
136
salaries
| ₹4 L/yr - ₹9.5 L/yr |
Flex
Foxconn
Dixon Technologies
ECIL