The Guardian Database Administrator DBA Interview Questions and Answers

Oracle upgrade involves planning, testing, and executing the upgrade process.

• Identify the current and target versions

• Review the upgrade documentation and release notes

• Perform a test upgrade in a non-production environment

• Backup the database before upgrading

• Run the pre-upgrade script to identify potential issues

• Upgrade the software and database components

• Run the post-upgrade script to complete the upgrade process

• Perform...read more

Sequential read reads data in order while scattered read reads data randomly.

• Sequential read is faster for large amounts of data accessed in order.

• Scattered read is faster for small amounts of data accessed randomly.

• Sequential read is used for full table scans while scattered read is used for index lookups.

• Sequential read is efficient for reading data from disk while scattered read is efficient for reading data from me