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

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. Runtime pollymorphism

Interview Preparation Tips

Round: Test
Experience: I scored good.
Tips: Core java good knowledge.
Duration: 30 minutes
Total Questions: 25

Round: Technical Interview
Experience: like this many ques from core java and hibernate and sql also and I scored good.
Tips: Command over core java and sql also.

I appeared for an interview in Sep 2017.

Interview Questionnaire 

3 Questions

  • Q1. What is deadlock
  • Ans. 

    Deadlock is a situation where two or more processes are unable to proceed because each is waiting for the other to release a resource.

    • Deadlock occurs when two or more processes are stuck in a circular wait, where each process is waiting for a resource held by another process.

    • Four necessary conditions for deadlock are mutual exclusion, hold and wait, no preemption, and circular wait.

    • Example: Process A holds resource X a...

  • Answered by AI
  • Q2. Which technology you know and worked
  • Ans. 

    I have experience with various technologies including Java, Python, HTML/CSS, JavaScript, and SQL.

    • Java

    • Python

    • HTML/CSS

    • JavaScript

    • SQL

  • Answered by AI
  • Q3. Why you are looking for change and what is your notice period
  • Ans. 

    I am looking for a change to explore new opportunities and challenges. My notice period is 30 days.

    • Seeking new opportunities and challenges

    • Want to learn and grow in a different environment

    • Exploring better career prospects

    • Seeking a company with a better work-life balance

    • Notice period is 30 days

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: 25 objective ques from Java and 25 from English
Tips: should prepare with Java Technology
Duration: 1 hour
Total Questions: 50

Round: Technical Interview
Experience: describe clearly
Tips: should prepared

Round: Technical Interview
Experience: do you know about jsf
Tips: yes, I worked

Round: Technical + HR Interview
Experience: this is my dream company actually, and notice is 15 to 20 days.
Tips: be confident

Skills evaluated in this interview

I appeared for an interview in Sep 2017.

Interview Questionnaire 

4 Questions

  • Q1. Technical interview take by client technical person actually they are hiring for another client so they took total 3 technical round and final will HR round
  • Q2. Asking about life cycle of Dot net mvc contols entity frame work and SQL queries
  • Q3. Problem based on oops and SQL queries outputs
  • Q4. Basic questions about my self ,salary discussion basic formalities form I have to fill up

Interview Preparation Tips

Round: Test
Experience: There were around 15 objective question that includes mvc, c#.net and SQL server. It was very simple question like different types of filters,Acton results in mvc. Basic oops concept and dot net web page regarding

Round: Resume Shortlist
Experience: After completing test round another was technical round discussed maily for mvc and SQL server questions. Around 30 mint discussion. After qualify this round another round will start from client technical staff.

General Tips: It was for 2-3 year experience person very simple to crack but focus on you which profile you are looking for study interview questions from net
Skills: Dot net mve oops concept jQuery and SQL server

I applied via Campus Placement and was interviewed before Nov 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Joins in SQL
  • Ans. 

    Joins are used in SQL to combine data from two or more tables based on a related column.

    • Types of joins include inner join, left join, right join, and full outer join.

    • Inner join returns only the matching rows from both tables.

    • Left join returns all rows from the left table and matching rows from the right table.

    • Right join returns all rows from the right table and matching rows from the left table.

    • Full outer join returns ...

  • Answered by AI
  • Q2. Web applications, mobile applications, Hybrid applications

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up the basics of Java and Mysql

Skills evaluated in this interview

I applied via Naukri.com and was interviewed before Nov 2019. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Servlet life cycle, bubble sort, quick sort, binary search, how can a software ensure GDPR rules being followed, SQL queries (second highest salary)

Interview Preparation Tips

Interview preparation tips for other job seekers - you will need to give a psychometric test, some beginner sometimes mediocre level programming test and final technical interview which may last till an hour. Do read about 1 or 2 Newgen products before going for the interview. They will definitely ask. Just be confident.Offer letter generally comes within 2 weeks. All the best !!

I applied via Naukri.com and was interviewed before Apr 2021. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. They specifically didn’t asked any questions by looking at my strong resume but just asked me if to come Hyderabad for training of a month

Interview Preparation Tips

Interview preparation tips for other job seekers - If you are good in technical knowledge then it would be easy for you to get opportunity here at client site you will learn a lot as mostly you will be at your own, companies technical support is not very good so mostly you are on your own

I applied via Recruitment Consultant and was interviewed before Feb 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Method overloading, method overriding, life cycle of thread,oops concepts

Interview Preparation Tips

Interview preparation tips for other job seekers - There were 4 rounds. 1. Technical written test, here, pattern, string, array questions were asked. 2.Face to face .
3. Manager round, here scenario based questions on jdbc,hybernate and other family background details.
4. HR round.

I applied via Recruitment Consultant and was interviewed in Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions on SDLC & STLC , system testing, regression testing, diff between functional and non functional testing, Smoke testing, Adhoc testing. Some simple SQL questions .

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and try to answer each amd every question correctly.

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

Interview Questionnaire 

2 Questions

  • Q1. Concat two linked lists in alternative way
  • Ans. 

    Concatenate two linked lists alternatively

    • Create a new linked list

    • Traverse both linked lists simultaneously

    • Alternate between adding nodes from each list to the new list

    • If one list is longer than the other, add the remaining nodes to the end of the new list

  • Answered by AI
  • Q2. Java and oops

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for Java and a certain of algo n ds

Skills evaluated in this interview

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.5k Interviews
Infosys Interview Questions
3.6
 • 7.6k 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
 • 797 Interviews
ITC Infotech Interview Questions
3.6
 • 336 Interviews
KPIT Technologies Interview Questions
3.4
 • 282 Interviews
View all
Clover Infotech Oracle Apps DBA Salary
based on 10 salaries
₹4.2 L/yr - ₹17.5 L/yr
At par with 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

₹1.8 L/yr - ₹9.5 L/yr

Senior Software Engineer
836 salaries
unlock blur

₹4.2 L/yr - ₹15.9 L/yr

Application Support Engineer
577 salaries
unlock blur

₹1.8 L/yr - ₹8.3 L/yr

Technical Support Engineer
557 salaries
unlock blur

₹2 L/yr - ₹8 L/yr

Oracle Database Administrator
492 salaries
unlock blur

₹1.8 L/yr - ₹10 L/yr

Explore more salaries
Compare Clover Infotech with

ITC Infotech

3.6
Compare

3i Infotech

3.5
Compare

Sify Technologies

3.8
Compare

Microland

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