Infosys Oracle Database Administrator Interview Questions and Answers

DBA stands for Database Administrator. The architecture of DBA involves managing and maintaining databases to ensure data integrity and security.

• DBA is responsible for installing, configuring, and upgrading database software.

• They monitor database performance and troubleshoot issues.

• DBA designs and implements backup and recovery strategies to prevent data loss.

• They also manage user access and security permissions within...read more

Maintaining the database involves regular monitoring, performance tuning, applying patches, and ensuring backups are taken regularly.

• Regularly monitor database performance and usage

• Perform routine maintenance tasks such as applying patches and updates

• Take regular backups to ensure data integrity and disaster recovery

• Implement security measures to protect the database from unauthorized access

• Optimize database performanc...read more

A lean supply chain focuses on minimizing waste and maximizing efficiency in the flow of goods and services.

• Focuses on reducing waste in all aspects of the supply chain

• Emphasizes efficiency in production, transportation, and distribution

• Involves continuous improvement and optimization of processes

• Utilizes tools like Just-In-Time inventory management and Kanban systems

• Examples include Toyota's production system and Dell...read more

Kaizen is a Japanese business philosophy of continuous improvement, while Kanban is a scheduling system for lean manufacturing.

• Kaizen focuses on making small, incremental improvements in processes and systems.

• Kaizen involves all employees in the organization and encourages suggestions for improvement.

• Kanban is a visual scheduling system that helps manage workflow by limiting work in progress.

• Kanban uses cards or signal...read more

Managed Oracle databases, optimized performance, and ensured data integrity in a high-availability environment.

• Led a team in migrating a legacy database to Oracle 19c, improving performance by 30%.

• Implemented backup and recovery strategies using RMAN, ensuring zero data loss during outages.

• Monitored database performance using AWR and ASH reports, identifying and resolving bottlenecks.

• Automated routine maintenance tasks...read more

A config file is a file that contains configuration settings for a software application or system.

• Config files are used to store parameters and settings that determine the behavior of an application or system.

• They are typically written in plain text format and can be edited using a text editor.

• Config files are often used to specify database connection details, server settings, application preferences, etc.

• Examples of c...read more

RAC DBA stands for Real Application Clusters Database Administrator. It is responsible for managing Oracle databases that are part of a cluster.

• RAC DBA manages Oracle databases that are part of a cluster

• It involves configuring and maintaining the cluster infrastructure

• Ensures high availability and scalability of the database

• Performs tasks like installation, patching, backup, and recovery in a clustered environment