CGI Group Lead Oracle DBA Interview Questions and Answers

Q1. How you will find that some user SQL running slow without discussing with user?
Add your answer
Q2. How you will patch specific db components to reduce downtime?
Ans. 
To patch specific db components to reduce downtime, follow these steps:
• Identify the specific components that need to be patched

• Plan the patching process during a scheduled maintenance window

• Backup the database before applying patches

• Apply patches to the specific components one by one

• Test the patched components to ensure they are functioning correctly

• Monitor the database for any issues post-patching
Answered by AI
Add your answer

Q1. Why you have so many hopping in your resume?
Add your answer
Q2. How you will rate yourself as an dba?
Add your answer

Q1. Self about my fis experience
Add your answer
Q2. Tell about my contribution
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

Q1. 19c upgradation steps Challanges faced during upgradation. Dataguard configuration Opatch rollback steps. RMAN duplication
Ans. 
Upgrading to Oracle Database 19c and related challenges
• Ensure compatibility of existing applications with 19c

• Perform pre-upgrade tasks such as backup and patching

• Upgrade the database using DBUA or manual methods

• Address challenges such as deprecated features and changes in behavior

• Configure Data Guard for high availability and disaster recovery

• Rollback an OPatch using the -rollback option

• Use RMAN duplication to create a
Answered by AI
Add your answer

Q1. How user login flow happens for ERP?
Ans. 
User login flow for ERP involves authentication, authorization, and session management.
• User enters credentials on login page

• Credentials are verified against database

• If credentials are valid, user is authenticated and authorized to access ERP modules

• A session is created for the user

• User can access ERP modules until session expires or user logs out
Answered by AI
Add your answer
Q2. Many online resources available. You can answer based on your understanding
Add your answer

Q1. Can we apply ebs patches using adpatch in EBS 12.2?

Ans. 

Yes, we can apply EBS patches using adpatch in EBS 12.2.

• Adpatch is the standard utility for applying patches in EBS.

• It can be used to apply patches to both the application and database tiers.

• Adpatch can be run in interactive or non-interactive mode.

• It is recommended to apply patches in a test environment before applying them in production.

• Adpatch logs can be found in the $APPL_TOP/admin//log directory.

View 1 more answer