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

You regularly take backups of your database using RMAN with a recovery catalog. Your database is currently open and the temp01.dbf temp file belonging to the TEMP tablespace is corrupted.
Identify two methods to recover the temp file with the least disruption to database availability. (Choose two.)

• A.Add a new temp file to the TEMP tablespace with a new name, and then drop the temp file that is corrupted.
• B.Restart the database instance to create the temp file automatically.
• C.Drop the TEMP tablespace, and then re-create it with new temp files.
• D.Take the TEMP tablespace offline, drop the missing temp file, and then create a new temp file.

Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interval.
Which three are prerequisites to fulfill this requirement? (Choose three.)

• A.Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.
• B.The flashback any table privilege must be granted to the user.
• C.The recycle bin parameter must be set to on.
• D.The database must be running in archivelog mode.
• E.The select any transaction privilege must be granted to the user.
• F.Minimal supplemental logging must be enabled.

Which three RMAN persistent settings can be set for a database? (Choose three.)

• A.default destinations for backups
• B.backup retention policy
• C.default section size for backups
• D.default backup device type
• E.multiple backup device types for a single backup

You create two Resource Manager plans, one for night time workloads, the other for day time.
How would you make the plans switch automatically?

• A.Use scheduler windows.
• B.Use scheduler schedules.
• C.Set the switch_time plan directive for both plans.
• D.Use job classes.
• E.Use the mapping rule for the consumer groups.

Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)

• A.You cannot export data from a remote database.
• B.You can overwrite existing dump files during export.
• C.You can compress data but not metadata during export.
• D.You can rename tables during import.