pass DBA Interview Questions and Answers

RAC architecture includes multiple nodes sharing a single database. Day to day issues include load balancing and node failures.

• RAC stands for Real Application Clusters

• Multiple nodes share a single database

• Load balancing is a key component

• Node failures can cause downtime

• Common day to day issues include performance tuning and resource allocation

• Oracle Clusterware is used to manage the cluster

• Oracle Automatic Storage Management (ASM) is often used for storage management

RMAN B backup is faster and more efficient than Expdp backup.

• RMAN B backup is an Oracle utility that creates a backup of the database using block-level backups.

• Expdp backup is an Oracle utility that creates a backup of the database using logical backups.

• RMAN B backup is faster and more efficient than Expdp backup because it only backs up the changed blocks.

• RMAN B backup is also more reliable because it uses checksums to ensure data integrity.

• Expdp backup is useful for creatin...read more

10 essential Linux commands for DBA administrators

• ls - list directory contents

• cd - change directory

• mkdir - make directory

• rm - remove files or directories

• cp - copy files or directories

• mv - move or rename files or directories

• grep - search for a pattern in a file

• top - display system processes

• ps - display information about running processes

• chmod - change file permissions