Premium Employer

i

This company page is being actively managed by Clover Infotech Team. If you also belong to the team, you can get access from here

Clover Infotech Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clover Infotech Oracle Apps DBA Interview Questions, Process, and Tips

Updated 8 Nov 2021

Clover Infotech Oracle Apps DBA Interview Experiences

1 interview found

I applied via Recruitment Consultant and was interviewed before Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

16 Questions

  • Q1. What is oracle application database administrator?
  • Ans. 

    An Oracle Application Database Administrator is responsible for managing and maintaining the Oracle database used by Oracle Applications.

    • Responsible for installation, configuration, and upgrading of Oracle database

    • Ensures database security and performance optimization

    • Manages backup and recovery processes

    • Performs database monitoring and troubleshooting

    • Responsible for user management and access control

    • Works closely with ...

  • Answered by AI
  • Q2. Cloning process. Single/multinode
  • Q3. Issue faced on client side and resolution for that.
  • Ans. 

    Client faced issue with concurrent request and resolved by increasing the number of processes.

    • Client reported slow performance while running concurrent requests.

    • Checked the number of processes and found it to be less than required.

    • Increased the number of processes and tested the concurrent request again.

    • Performance improved and issue resolved.

  • Answered by AI
  • Q4. Difference between R12.1 and R12.2
  • Ans. 

    R12.2 has more features and improvements than R12.1

    • R12.2 has a new online patching feature

    • R12.2 has a new user interface

    • R12.2 has improved security features

    • R12.2 has enhanced mobile support

    • R12.2 has a new tool for managing concurrent programs

  • Answered by AI
  • Q5. Did you know about oracle secure backup
  • Ans. 

    Yes, Oracle Secure Backup is a tape backup management software for Oracle databases.

    • Oracle Secure Backup provides centralized management of tape backup and recovery operations for Oracle databases.

    • It supports various tape devices and media types.

    • It offers encryption and compression options for backup data.

    • It can be integrated with Oracle Recovery Manager (RMAN) for seamless backup and recovery.

    • It also provides reportin

  • Answered by AI
  • Q6. Why form taking time to load.
  • Ans. 

    Forms may take time to load due to various reasons.

    • Network latency

    • Heavy database queries

    • Large number of concurrent users

    • Inefficient coding

    • Insufficient hardware resources

  • Answered by AI
  • Q7. Why report is running slow.
  • Ans. 

    Reports can run slow due to various reasons.

    • Inefficient SQL queries

    • Large data sets

    • Inadequate hardware resources

    • Poorly designed report layout

    • Network latency

    • Lack of indexing

    • Database contention

    • Insufficient memory allocation

    • Outdated software versions

  • Answered by AI
  • Q8. Why index rebuild is so important.
  • Ans. 

    Index rebuild is important for improving database performance.

    • Rebuilding indexes helps to remove fragmentation and improve query performance.

    • It also helps to reduce disk I/O and improve overall database efficiency.

    • Regular index rebuilds can prevent index corruption and improve database stability.

    • Index rebuilds can be scheduled during off-peak hours to minimize impact on users.

    • Examples of tools for index rebuilds includ

  • Answered by AI
  • Q9. Benifits of dr drill.
  • Q10. If input/output error encountered.
  • Ans. 

    Input/output error indicates a problem with reading or writing data to a storage device.

    • Check if the storage device is properly connected and functioning.

    • Check if the file system is corrupted.

    • Check if there is enough space on the storage device.

    • Check if there are any hardware issues with the storage device.

    • Check if there are any software issues with the operating system or application.

    • Try to recover the data from backu

  • Answered by AI
  • Q11. How to add DMZ node.
  • Ans. 

    To add DMZ node, we need to configure the DMZ server and add it to the existing Oracle E-Business Suite environment.

    • Configure the DMZ server with the required software and patches.

    • Create a new context file for the DMZ node.

    • Update the DMZ context file with the required parameters.

    • Run the AutoConfig on the DMZ node.

    • Add the DMZ node to the existing Oracle E-Business Suite environment.

    • Configure the firewall to allow traffi...

  • Answered by AI
  • Q12. What is load balancer? Use of it!
  • Ans. 

    A load balancer is a device that distributes network traffic across multiple servers to improve performance and availability.

    • Load balancers can improve website or application performance by distributing traffic evenly across multiple servers.

    • They can also improve availability by redirecting traffic to healthy servers in case of server failure.

    • Load balancers can be hardware or software-based and can be configured to use...

  • Answered by AI
  • Q13. Log file locations
  • Q14. Start stop sequence of erp application and database. Impact if sequence get wrong
  • Ans. 

    Start stop sequence of ERP app and DB. Impact if sequence gets wrong.

    • Start DB first, then ERP app

    • Stop ERP app first, then DB

    • Wrong sequence can cause data corruption or loss

    • May result in incomplete transactions or errors during startup

  • Answered by AI
  • Q15. If one of the application top get deleted how to restore?
  • Ans. 

    To restore a deleted application top, use adadmin utility to recreate the application top.

    • Use adadmin utility to recreate the application top

    • Select option 2 (Maintain Applications Files menu)

    • Select option 1 (Maintain Applications Files)

    • Select option 2 (Copy Oracle Applications Files to the File System)

    • Enter the application short name and version to recreate the application top

  • Answered by AI
  • Q16. Oacore issue encountered?
  • Ans. 

    Oacore issue refers to problems encountered in the Oracle Application Framework (OAF) layer of Oracle E-Business Suite.

    • Oacore issues can cause application performance problems, such as slow page load times or unresponsive pages.

    • Common causes of Oacore issues include memory leaks, database connectivity problems, and configuration errors.

    • To troubleshoot Oacore issues, DBAs can use tools like Oracle Enterprise Manager (OE...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - We can asked employees regarding his past experience & from printed resume.

Skills evaluated in this interview

Oracle Apps DBA Jobs at Clover Infotech

View all

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. I were very happy with technical discussion with Infosys, and It went good.
  • Q2. I have faced lot of technical question regarding Oracle DBA, Oracle Apps DBA.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

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

Round 1 - Technical 

(1 Question)

  • Q1. Roles and responsibilities of current company, What is difference between 12.1 and 12.2 application Adop patching Database patching Weblogic Performance tuning Clonning Backups Data Guard configurat...

I applied via Company Website and was interviewed before Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions on Java,SQL,some trending technologies(IOT,Big data),pattern questions, programming questions with different approaches.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basics of DSA, have knowledge about the databases, some common dml ,ddl statements, programming knowledge of a particular language like C,Java, python,etc...have good command on oops concepts... little bit of frameworks knowledge will also help

I applied via Referral and was interviewed before Jan 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Java questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basic questions

I applied via Newspaper Ad and was interviewed before Jun 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 
Round 2 - Technical 

(1 Question)

  • Q1. Basic questions of java.
Round 3 - HR 

(1 Question)

  • Q1. Intro and other hr related questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Cover the basic questions regarding the programming language.

I applied via Referral and was interviewed before Apr 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Puzzles, Psychometric Test

Round 2 - One-on-one 

(1 Question)

  • Q1. Some water in 3 Jars question, you had to measure out 5L correctly

Interview Preparation Tips

Interview preparation tips for other job seekers - Make the interview interactive, I got this input from another Senior. Before i went into the interview room the volunteers were telling all those who goes into Room No 1 is screwed. I was praying i don't get room no 1. But fortunately for me I got room no 1 because when the interviewer gave me the puzzle and handed over pen and paper he went back to relax his posture and when i explained i will fill the 5L Jar first, he immediately came forward to listen to me, at that moment i knew i got the job because i felt the previous candidates never made their interview interactive and that's why he went back to relax his posture.

I applied via Walk-in and was interviewed before Jul 2021. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. .net questions - routing in asp.net MVC ?

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing . Prepare well for interview on .Net technology stack

I applied via Company Website and was interviewed before Jun 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

First round was coding as well as aptitude done together went well I guess focusing on codes helps a lot.

Round 2 - Technical 

(1 Question)

  • Q1. 2nd round included tr and mr round went quite enegritic

Interview Preparation Tips

Interview preparation tips for other job seekers - Resume skills matters a lot don't fill resume the technologies you don't even aware of

I applied via Campus Placement and was interviewed before Jan 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Good

Round 2 - Technical 

(1 Question)

  • Q1. Basic question from C++.Some questions from Data structure and computer architecture.

Interview Preparation Tips

Topics to prepare for TCS Software Engineer interview:
  • C++
Interview preparation tips for other job seekers - Prepare well. Aptitude is not very easy so you have to prepare well.

Clover Infotech Interview FAQs

How to prepare for Clover Infotech Oracle Apps DBA 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 Clover Infotech. The most common topics and skills that interviewers at Clover Infotech expect are Oracle Apps DBA, Apps DBA, Backup, CCTV Monitoring and Cloning.
What are the top questions asked in Clover Infotech Oracle Apps DBA interview?

Some of the top questions asked at the Clover Infotech Oracle Apps DBA interview -

  1. What is oracle application database administrato...read more
  2. If one of the application top get deleted how to restor...read more
  3. Issue faced on client side and resolution for tha...read more

Tell us how to improve this page.

Join Clover Infotech Digital Solutions for the New-Age Enterprise

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Infosys Interview Questions
3.6
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
Mphasis Interview Questions
3.4
 • 789 Interviews
KPIT Technologies Interview Questions
3.4
 • 280 Interviews
NeoSOFT Interview Questions
3.9
 • 261 Interviews
View all
Clover Infotech Oracle Apps DBA Salary
based on 10 salaries
₹4.2 L/yr - ₹17.5 L/yr
6% more than the average Oracle Apps DBA Salary in India
View more details

Clover Infotech Oracle Apps DBA Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

4.0

Skill development

3.0

Work-life balance

4.0

Salary

4.0

Job security

3.0

Company culture

5.0

Promotions

4.0

Work satisfaction

Explore 1 Review and Rating
Software Engineer
1.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
839 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Application Support Engineer
569 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Support Engineer
563 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Oracle Database Administrator
489 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Clover Infotech with

TCS

3.7
Compare

Wipro

3.7
Compare

Infosys

3.6
Compare

HCLTech

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