AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Wistron Oracle Database Administrator Interview Questions, Process, and Tips
Wistron Oracle Database Administrator Interview Experiences
1 interview found
Anonymous
I applied via Naukri.com and was interviewed in Sep 2022. There were 3 interview rounds.
(2 Questions)
- Q1. How can you recover the deleted datafiles if datafiles are not taken backup
- Ans.
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
- Q2. How to check dr dc sync
- Ans.
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
(3 Questions)
- Q1. What are er diagrams
- Ans.
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
- Q2. What is difference between cold backup and hot backup
- Ans.
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...
- Q3. How to connect to rman
- Ans.
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
Interview Preparation Tips
revise before the interview
Interview process was smooth,
interviewer was very supportive and patience guy who wants to listen without ego.
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Recruitment Consultant and was interviewed before Oct 2020. There were 5 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Project description
- Ans.
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
- Q2. Python based problems
- Q3. Embedded scenarios
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Feb 2022. There were 2 interview rounds.
It was aptitude and technical MCQ questions round
(2 Questions)
- Q1. Technical interview- regarding skills mentioned in resume and projects
- Q2. In same round hr interview was done
Interview Preparation Tips
I appeared for an interview in Jan 2021.
(1 Question)
Round duration - 30. minutes
Round difficulty - Easy
It was in the evening, question were moderate
- Q1.
Count Subsequences Problem Statement
Given an integer array
ARRof sizeN, your task is to find the total number of subsequences in which all elements are equal.Explanation:
A subsequence of an array i...
- Ans.
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.
(1 Question)
Round duration - 30 minutes
Round difficulty - Easy
It was in the night around 9:00 PM.
- Q1.
Pair Sum Problem Statement
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'.
Note:
... - Ans.
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.
Interview Preparation Tips
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
Skills evaluated in this interview
(2 Questions)
- Q1. Salary expectation .
- Q2. Why should I hire you?
(2 Questions)
- Q1. Mendix Advanced questions.
- Q2. Everything which you mentioned in your resume.
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.
(1 Question)
- Q1. Electrical fundamental and AC thoery
(4 Questions)
- Q1. Tell me about yourself.
- Q2. Why are you looking for a change?
- Q3. Why should we hire you?
- Q4. What are your salary expectations?
Interview Preparation Tips
Clear basic concepts of electrical
I applied via Other and was interviewed before Oct 2019. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. How to react in a critical situation to customer. Need to explain about the issue or give solution for the issue?
- Q2. How are you going to handle a 5 member team
Interview Preparation Tips
(1 Question)
- Q1. Technical related questions
(1 Question)
- Q1. Salary discussion
Interview Preparation Tips
I applied via Approached by Company and was interviewed in May 2022. There were 3 interview rounds.
(1 Question)
- Q1. Formal questions according to HR
(1 Question)
- Q1. Questions according there relevant departments.
Interview Preparation Tips
Wistron Interview FAQs
Tell us how to improve this page.
Wistron Interviews By Designations
- Wistron Operator Interview Questions
- Wistron Junior Engineer Interview Questions
- Wistron Engineer Trainee Interview Questions
- Wistron Industrial Engineer Interview Questions
- Wistron Senior Engineer Interview Questions
- Wistron Quality Engineer Interview Questions
- Wistron Process Engineer Interview Questions
- Wistron Production Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Oracle Apps DBA Interview Questions
- Oracle Application Database Administrator Interview Questions
- Senior Oracle Database Administrator Interview Questions
- Database Developer Interview Questions
- SQL Database Administrator Interview Questions
- Senior Database Administrator Interview Questions
- Oracle SCM Functional Consultant Interview Questions
- Oracle SQL and PLSQL Developer Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
Wistron Oracle Database Administrator Reviews and Ratings
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
- Home >
- Interviews >
- Wistron Interview Questions >
- Wistron Oracle Database Administrator Interview Questions
