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

Examine the RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisite must be met before accomplishing the backup?

• A.The password for the encryption must be set up.
• B.All the tablespaces in the database must be encrypted.
• C.Oracle wallet for the encryption must be set up.
• D.Oracle Database Vault must be enabled.

Your database supports an OLTP workload. Examine the output of the query:
SQL> SELECT target_mttr, estimated_mttr
FROM v$instance_recovery
Target_mttr estimated_mttr
---------------------- ---------------------------
0 76
To ensure faster instance recovery, you set the fast_start_mttr_target initialization parameter to 30.
What is the effect of this setting on the database?

• A.The overhead on database performance is increased because of frequent writes to disk.
• B.The frequency of log switches is increased.
• C.Automatic checkpoint tuning is disabled.
• D.The MTTR advisor is disabled.

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

• A.Enable Memory Access Mode, which reads performance data from SGA.
• B.Use emergency monitoring to fetch data directly from SGA for analysis.
• C.Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
• D.Use Active Session History (ASH) data and hang analysis in regular performance monitoring,
• E.Run ADDM in diagnostic mode.

Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidently truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database.
Which two best methods are performed the truncated table data? (Choose two.)

• A.Database Point-in-Time Recovery
• B.Flashback Transaction Backout
• C.Tablespace Point-in-Time Recovery
• D.Table Point-in-Time Recovery.
• E.Flashback Database

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

• A.You can use EM express to manage multiple databases running on the same server.
• B.You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.
• C.By default, EM express is available for a database after database creation.
• D.You can create and configure pluggable databases by using EM express.
• E.You can perform basic administrative tasks for pluggable databases by using the EM express interface.