Genpact Oracle Apps DBA Interview Questions and Answers

Q1. How to add RAC node in19c DB?
Ans. 
To add a RAC node in 19c DB, you need to run the 'addNode.sh' script on the new node.
• Ensure the new node meets all the prerequisites for adding to the RAC cluster.

• Run the 'addNode.sh' script on the new node to add it to the existing RAC cluster.

• Verify the addition of the new node by checking the cluster status and resources.
Answered by AI
Add your answer
Q2. How to do troubleshoot EBS R12.2 Login issue?
Ans. 
To troubleshoot EBS R12.2 login issue, check for incorrect login credentials, session timeout, browser cache, and server connectivity.
• Verify the correctness of login credentials entered by the user.

• Check for session timeout settings in EBS R12.2.

• Clear browser cache and cookies to eliminate any login issues caused by stored data.

• Ensure proper server connectivity to the EBS R12.2 instance.
Answered by AI
Add your answer

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...read more
Add your answer

Q1. Tell me the high level overview of dataguard installation?
Add your answer
Q2. What are your daily tasks adn what things you handel in your team?
Add your answer

Q1. What is pull request
Ans. 
A pull request is a method of submitting contributions to a project on GitHub for review and merging.
• Pull requests are commonly used in version control systems like Git to propose changes to a codebase.

• They allow developers to collaborate and discuss changes before merging them into the main branch.

• Pull requests typically include a description of the changes, related issues, and any necessary tests or documentation.

• Rev...read more
Answered by AI
Add your answer

Q1. What is sateful set
Ans. 
Stateful set is a Kubernetes controller that manages the deployment and scaling of a set of pods with persistent storage.
• Stateful set ensures that each pod in the set has a unique identity and stable network identity.

• Stateful set pods are created in order and are not replaced until they are deleted.

• Stateful set is commonly used for stateful applications like databases where each pod requires persistent storage.

• Example:...read more
Answered by AI
Add your answer

Sql queries on top clause

Q1. Why u want to join
Ans. 
I am passionate about database management and eager to contribute my skills to your team.
• I have a strong background in database administration

• I am excited about the opportunity to work with a reputable company like yours

• I am eager to learn and grow in my career as a SQL DBA
Answered by AI
Add your answer
Q2. What is the salary expectation
Ans. 
I am looking for a competitive salary based on my experience, skills, and the responsibilities of the role.
• Research the average salary range for MS SQL DBAs in your location and industry

• Consider your years of experience and any specialized skills or certifications you have

• Be prepared to negotiate based on the specific responsibilities and requirements of the role
Answered by AI
Add your answer

Q1. Tell about yourself
Ans. 
Experienced Oracle DBA with 5+ years of hands-on experience in managing databases, optimizing performance, and ensuring data security.
• 5+ years of experience as an Oracle DBA

• Proficient in database management, performance optimization, and data security

• Skilled in troubleshooting and resolving database issues

• Strong knowledge of Oracle database architecture and SQL

• Certified Oracle Database Administrator (OCA/OCP)
Answered by AI
Add your answer

Q1. About oracle database functionality
Add your answer

Q1. Salary discussion
Add your answer

Asked question from basic aptitude topics

Q1. Asked question coding languages like c, python, java, SQL
Add your answer

Q1. Discussed about terms and policies of company. Also work profile
Add your answer