Upload Button Icon Add office photos

Wistron

Compare button icon Compare button icon Compare

Filter interviews by

Wistron Oracle Database Administrator Interview Questions, Process, and Tips

Updated 22 Oct 2022

Wistron Oracle Database Administrator Interview Experiences

1 interview found

I applied via Naukri.com and was interviewed in Sep 2022. There were 3 interview rounds.

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 - Technical 

(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

  • Answered by AI
  • 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

  • Answered by AI
Round 3 - Technical 

(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

  • Answered by AI
  • 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...

  • Answered by AI
  • 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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident
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

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

  • Answered by AI
  • Q2. Python based problems
  • Q3. Embedded scenarios

Interview Preparation Tips

Interview preparation tips for other job seekers - Be frank about your self ration about your skills and maintain 2 way communication during the interview.

I applied via Campus Placement and was interviewed in Feb 2022. There were 2 interview rounds.

Round 1 - Aptitude Test 

It was aptitude and technical MCQ questions round

Round 2 - Technical 

(2 Questions)

  • Q1. Technical interview- regarding skills mentioned in resume and projects
  • Q2. In same round hr interview was done

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare well what you mentioned in resume.

I appeared for an interview in Jan 2021.

Round 1 - Coding Test 

(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 ARR of size N, 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.

  • Answered by AI
Round 2 - Coding Test 

(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.

  • Answered by AI

Interview Preparation Tips

Professional and academic backgroundI completed Computer Science Engineering from Delhi Technological University. I applied for the job as Software Engineer in DelhiEligibility criteriaNo percentage criteria(good in aptitude)Vertiv Co interview preparation:Topics to prepare for the interview - Array, oops, algorithms, data structures, stackTime required to prepare for the interview - 4 monthsInterview preparation tips for other job seekers

Tip 1 : Learn new things daily 
Tip 2 : Practice questions 
Tip 3 : Keep one question in mind to solve.

Application resume tips for other job seekers

Tip 1 : Description about your skills 
Tip 2 : Project details

Final outcome of the interviewSelected

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Salary expectation .
  • Q2. Why should I hire you?
Round 2 - One-on-one 

(2 Questions)

  • Q1. Mendix Advanced questions.
  • Q2. Everything which you mentioned in your resume.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Coding Test 

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.

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 - Technical 

(1 Question)

  • Q1. Electrical fundamental and AC thoery
Round 3 - HR 

(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

Interview preparation tips for other job seekers - Speak truth about privious job
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

Interview preparation tips for other job seekers - Please prepare in management level as well
Interview experience
4
Good
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 - Technical 

(1 Question)

  • Q1. Technical related questions
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Joining details

I applied via Approached by Company and was interviewed in May 2022. There were 3 interview rounds.

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 - HR 

(1 Question)

  • Q1. Formal questions according to HR
Round 3 - Technical 

(1 Question)

  • Q1. Questions according there relevant departments.

Interview Preparation Tips

Interview preparation tips for other job seekers - Go professionally and finish your interview.

Wistron Interview FAQs

How many rounds are there in Wistron Oracle Database Administrator interview?
Wistron interview process usually has 3 rounds. The most common rounds in the Wistron interview process are Technical and Resume Shortlist.
How to prepare for Wistron Oracle Database Administrator interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Wistron. The most common topics and skills that interviewers at Wistron expect are RMAN, Dataguard, Datapump, Oracle 10G and Oracle DBA.
What are the top questions asked in Wistron Oracle Database Administrator interview?

Some of the top questions asked at the Wistron Oracle Database Administrator interview -

  1. how can you recover the deleted datafiles if datafiles are not taken bac...read more
  2. what is difference between cold backup and hot bac...read more
  3. how to check dr dc s...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Flex Interview Questions
4.0
 • 189 Interviews
Foxconn Interview Questions
3.9
 • 157 Interviews
Navitasys India Interview Questions
4.2
 • 101 Interviews
TE Connectivity Interview Questions
4.1
 • 84 Interviews
Secure Meters Interview Questions
4.1
 • 69 Interviews
DBG Technology Interview Questions
3.8
 • 64 Interviews
Vertiv Interview Questions
3.9
 • 49 Interviews
ECIL Interview Questions
4.2
 • 48 Interviews
View all

Wistron Oracle Database Administrator Reviews and Ratings

based on 1 review

2.0/5

Rating in categories

2.0

Skill development

1.0

Work-life balance

4.0

Salary

5.0

Job security

1.0

Company culture

3.0

Promotions

1.0

Work satisfaction

Explore 1 Review and Rating
Junior Engineer
586 salaries
unlock blur

₹1.5 L/yr - ₹5 L/yr

Operator
379 salaries
unlock blur

₹0.8 L/yr - ₹3.5 L/yr

Engineer Trainee
333 salaries
unlock blur

₹2 L/yr - ₹3.6 L/yr

Engineer
238 salaries
unlock blur

₹2.3 L/yr - ₹7 L/yr

Senior Engineer
136 salaries
unlock blur

₹4 L/yr - ₹9.5 L/yr

Explore more salaries
Compare Wistron with

Flex

4.0
Compare

Foxconn

3.9
Compare

Dixon Technologies

4.0
Compare

ECIL

4.2
Compare
Did you find this page helpful?
Yes No
write
Share an Interview