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

ENCRYPT_TS is an encrypted tablespace that contains tables with data.
Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

• A.The data is decrypted during SORT and JOIN operations.
• B.The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
• C.The data remains encrypted when it is read into memory.
• D.The data remains encrypted when it is stored in the redo logs

Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

• A.to store RMAN scripts that are available to any RMAN client that can connect to target databases registered in the recovery catalog
• B.to automatically delete obsolete backups after a specified period of time
• C.to restrict the amount of space that is used by backups
• D.to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause
• E.to store backup information of multiple databases in one place

Which statements are true regarding system-partitioned tables? (Choose all that apply.)

• A.Traditional partition pruning and partitionwise joins are not supported on these tables.
• B.All DML statements must use partition-extended syntax.
• C.Unique local indexes cannot be created on a system-partitioned table.
• D.Only a single partitioning key column can be specified.
• E.The same physical attributes must be specified for each partition.

Your database is running in archive log mode and Automatic Undo Management is enabled.
Which two tasks should you perform before enabling Flashback Database?

• A.Enable the recyclebin.
• B.Enable Fast Recovery Area.
• C.Enable minimal supplemental logging.
• D.Enable undo retention guarantee.
• E.Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.

You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded.
Sometimes, you are not able to connect to the database instance because it hangs.
How can you detect the cause of the degraded performance?

• A.by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots
• B.by using Active Session History (ASH) data and performing hang analysis
• C.by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis
• D.by running ADDM in diagnostic mode