1Z0-042 試験問題を無料オンラインアクセス

Which two operations require undo data? (Choose two.)

• A.rolling forward during instance recovery
• B.recording a transaction to redo log files
• C.recovering from failed transactions
• D.committing a transaction
• E.rolling back a transaction

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?

• A.use the direct path data load of Oracle export and import utility
• B.use the conventional path data load of SQL*Loader utility
• C.use the external table population
• D.use the Oracle Data Pump export and import utility

Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.)

• A.It can be increased up to the value of the SGA_MAX_SIZE parameter.
• B.Reducing the value of the SGA_TARGET parameter takes away memory from both autotuned and manually sized components.
• C.Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared memory management feature.
• D.Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the autotuned components.

Data files of which three tablespaces can be recovered by performing an open recovery? (Choose three.)

• A.TEMP
• B.INDEX
• C.SYSAUX
• D.UNDO
• E.SYSTEM

Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning, media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this situation?

• A.restore only the corrupted data file and perform tablespace recovery
• B.recover using Oracle Flashback Database technology
• C.restore the data files from backup and perform a complete recovery
• D.restore the entire database from the most recent backup and start the instance and open the database
• E.restore the data files from backup and perform cancel-based recovery