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

You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of l/Os. Which statement describes a solution to the above?

• A.Add directives to the Automatic Database Diagnostic Monitor (ADDM).
• B.Modify the profile for the targeted users for which control needs to be imposed.
• C.Set a threshold for the default system-defined moving window baseline.
• D.Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.

You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.
You executed the following RMAN commands:
RMAN> CONNECT TARGET sys/sys@APPPROD
RMAN> CONNECT AUXILIARY sys/sys@DUPDB
RMAN> DUPLICATE TARGET DATABASE TO
dupdb
FROM ACTIVE DATABASE
PASSWORD FILE
SPILE
NOFILENAMECHECK;
What are the implications of this command?

• A.It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.
• B.It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.
• C.It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.
• D.It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.

You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?

• A.Compute the baseline statistics.
• B.Take an immediate AWR snapshot.
• C.Decrease the window size for the baseline.
• D.Decrease the expiration time for the baseline.

You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?

• A.The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period.
• B.The collection level for the AWR should be set to BASIC.
• C.The moving window size must be less than Undo Retention.
• D.The moving window size should be greater than the Automatic Workload Repository (AWR) retention period.

While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?

• A.The backup succeeds because it fails over to one of the alternative archived redo log destinations.
• B.The backup succeeds but it would be without the missing archived log.
• C.The backup fails because one of the archived redo log files is missing.
• D.During backup, you are prompted for the alternative destination for the missing archived redo log file.