Oracle Application Database Administrator

Oracle Application Database Administrator Interview Questions and Answers

Updated 21 Sep 2024

Q1. in RAC database 2 nodes are there how you will re-direct users to 2nd node only?

Ans.

To redirect users to the 2nd node in a RAC database, you can use services and connection load balancing.

Create a service for the 2nd node in the RAC database.
Configure connection load balancing to distribute connections evenly between the nodes.
Update the connection string in the application to point to the service for the 2nd node.
Test the connection to ensure users are redirected to the 2nd node.

Q2. What are the types of patches ?

Ans.

There are three types of patches: Proactive, Reactive, and Patch Set Updates.

Proactive patches are released to prevent known issues from occurring.
Reactive patches are released to fix issues that have already occurred.
Patch Set Updates are collections of patches that include bug fixes, security updates, and new features.
Examples of patch types include Critical Patch Updates, Security Patch Updates, and Interim Patch Sets.

Q3. How to apply ad patch ?

Ans.

To apply ad patch, use adpatch utility provided by Oracle E-Business Suite.

Ensure that the patch is compatible with your Oracle E-Business Suite version.
Download the patch and unzip it in the $PATCH_TOP directory.
Run adpatch utility with the patch directory path as input.
Follow the prompts and review the log files for any errors.
Restart the application services to complete the patching process.

Q4. How to apply adop patch ?

Ans.

To apply adop patch, use adop command with appropriate options.

Ensure that the system is in the correct state for patching
Download the patch and verify its integrity
Apply the patch using adop command with appropriate options
Run necessary post-patching tasks
Verify the patch applied successfully

Are these interview questions helpful?

Q5. Explain verious methodes of database backup

Ans.

Various methods of database backup include full backup, incremental backup, differential backup, and hot backup.

Full backup: Backs up the entire database, including all data and objects.
Incremental backup: Backs up only the changes made since the last backup, reducing backup time and storage requirements.
Differential backup: Backs up all changes made since the last full backup, providing a balance between full and incremental backups.
Hot backup: Takes a backup while the datab...read more

Q6. what is Oracle Block Change

Ans.

Oracle Block Change is a feature that tracks and records changes made to database blocks.

Oracle Block Change is used for efficient data replication and synchronization.
It helps in identifying and transferring only the changed data blocks instead of the entire database.
Oracle GoldenGate utilizes Oracle Block Change technology for real-time data integration.
Block Change Tracking (BCT) is a feature in Oracle Database that enables incremental backups by tracking changed blocks.

Share interview questions and help millions of jobseekers 🌟

Q7. Explain what is ASM

Ans.

ASM stands for Automatic Storage Management. It is a feature of Oracle Database that provides a file system and volume manager for managing database files.

ASM simplifies storage management by eliminating the need for manual file system and volume management tasks.
It provides striping and mirroring of database files to improve performance and reliability.
ASM manages storage at the disk group level, where a disk group is a collection of physical disks.
It automatically rebalance...read more

Q8. Explain Architecture of RMAN

Ans.

RMAN architecture consists of components like RMAN executable, target database, recovery catalog, and auxiliary database.

RMAN executable is a command-line utility used for backup and recovery operations.
Target database is the database being backed up or recovered.
Recovery catalog is a schema in a separate database that stores RMAN metadata.
Auxiliary database is a temporary database used during restore and recovery operations.
RMAN uses channels to parallelize backup and recove...read more