Jeraisy Oracle Database Administrator Interview Questions and Answers

Q1. How to sync primary and standby?
Ans. 
Primary and standby databases can be synced using Data Guard in Oracle.
• Configure Data Guard on primary and standby databases

• Enable redo transport services

• Monitor and resolve any synchronization issues

• Perform switchover or failover when necessary
Answered by AI
Add your answer
Q2. Performance tuning?
Add your answer

Q1. Why you want to change the job?
Ans. 
Seeking new challenges and growth opportunities in a dynamic environment.
• Looking for new challenges to enhance my skills and knowledge

• Seeking growth opportunities for career advancement

• Interested in working in a more dynamic and innovative environment
Answered by AI
Add your answer
Q2. Expected salary.
Add your answer

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. About oracle database functionality
Add your answer

Q1. Salary discussion
Add your answer

Database Management system SQL and PlSQL

Database Base Management system SQL and PlSQL

Database Management system

Database Management system

Database Management system

Database Management system

Database Base Management system

Q1. Database Management system
Add your answer
Q2. SQL and PlSQL Mango Data And Manu Database Management system
Add your answer
Q3. C Language and C++Language and Java
Add your answer
Q4. Data Analysis and Data entry
Add your answer
Q5. DBMS C,C++ Java Data Entry Ms Excel Ms Word Ms PP
Add your answer

Q1. Tell me about your roles and responsibilities
Add your answer
Q2. How to add diskgroup in disks
Ans. 
To add a diskgroup in disks, use the CREATE DISKGROUP command in Oracle ASM.
• Ensure that the disks are initialized and partitioned

• Use the ASMCA (ASM Configuration Assistant) or ASMCMD (ASM Command-Line Utility) to create the diskgroup

• Specify the diskgroup name, redundancy level, and the disks to be included in the diskgroup

• Example: CREATE DISKGROUP dg1 NORMAL REDUNDANCY DISK '/dev/sdb1', '/dev/sdc1'
Answered by AI
Add your answer
Q3. What will do in Real application cluater
Ans. 
Real Application Cluster (RAC) is a cluster database with shared disk architecture.
• RAC allows multiple instances to access a single database simultaneously.

• It provides high availability and scalability.

• RAC uses Oracle Clusterware to manage the cluster.

• Load balancing and failover are automatic in RAC.

• RAC requires additional hardware and software licenses.
Answered by AI
Add your answer