| Exam Code/Number: | 1Z0-042Join the discussion |
| Exam Name: | Oracle database 10g:Administration I |
| Certification: | Oracle |
| Question Number: | 185 |
| Publish Date: | May 21, 2026 |
|
Rating
100%
|
|
Which two database operations can be performed at the MOUNT stage of database startup? (Choose two.)
In the PROD database you have granted the RESUMABLE system privilege to the CONNECT role. Resumable space operation has been enabled for all user sessions. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead, you want the problem to be resolved by a database trigger automatically. Which combination of triggering time and event would you use to achieve this objective?
You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?
You notice this warning in the alert log file:
ORA-19815: WARNING: db_recovery_file_dest_size of 3221225472 bytes is 100.00% used, and has 0 remaining bytes available.
What would you do to reclaim the used space in the Flash Recovery Area?
Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file ? (Choose two.)
