Which two statements are true regarding the functionality of the remap command in ASMCMD?
A. It repairs blocks that have read disk I/O errors.
B. It checks whether the alias metadata directory and the file directory are linked correctly.
C. It repairs blocks by always reading them from the mirror copy and writing them to the original location.
D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.
Given below are RMAN commands to enable backup optimization and set the retention policy:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;
RMAN> CONFIGURE BACKUP OPTIMIZATION ON;
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
The USERS tablespace has never been backed up. You take the USERS tablespace offline on Monday.
Viewthe Exhibit to examine the operations performed by using RMAN.
Which two statements are true about the backup of the USERS tablespace? (Choose two.)
A. It will be backed up as a part of database backup on Friday.
B. It will be backed up as a part of database backup on Tuesday.
C. It will not be backed up as a part of database backup on Wednesday.
D. The command on Sunday deletes the backup of the USERS tablespace taken on Tuesday.
There was media failure and you decide to check the data files for block corruption. Which would you use to create a report on any corruptions found?
A. the DBNEWID utility
B. the DBVERIFY utility
C. the ANALYZE command
D. the RMAN REPORT command
E. the RMAN CROSSCHECK command
F. the CHECK_OBJECT procedure of the DBMS_REPAIR package
Examine the following command for RMAN backup:
RMAN> RUN {
ALLOCATE CHANNEL c1 DEVICE TYPE sbt;
ALLOCATE CHANNEL c2 DEVICE TYPE sbt;
ALLOCATE CHANNEL c3 DEVICE TYPE sbt;
BACKUP
INCREMENTAL LEVEL = 0
(DATAFILE 1,4,5 CHANNEL c1)
(DATAFILE 2,3,9 CHANNEL c2)
(DATAFILE 6,7,8 CHANNEL c3);
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
}
Which statement is true regarding the approach in the command?
A. The RMAN multiplexing level is 4.
B. It is the use of asynchronous I/O by RMAN.
C. It is a case of parallelization of the backup set.
D. It is an implementation of a multi section backup.
Evaluate the following block of code:
What is the outcome of the above code?
A. It produces an error because a fully qualified host name needs to be specified.
B. It produces an error because the range of ports associated with the hosts has not been specified.
C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.
D. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
You execute these RMAN commands:
BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST;
What will these commands do?
A. create a backup of the database and recover all corrupted blocks found in the backup
B. perform a backup validation and list all logically and physically corrupt blocks in the database
C. perform a backup validation and populate the memory structure used by the vscopy_corruption view with details of any corrupt blocks found
D. perform a backup validation and populate the memory structure used by the vsDATABASE_BLOCK_CORRUPTION view, then recover any corrupt blocks
E. create an image copy of the database and recover all corrupted blocks found in the image copy
You want to track and store all transactional changes to a table over its lifetime. To accomplish this task,
you enabled Flashback Data Archive with the retention of 5 years. After some time, the business
requirement changed and you were asked to change the retention from 5 years to 3 years.
To accomplish this, you issued the following command:
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR; What is the implication of this
command?
A. The command produces an error because the retention time cannot be reduced.
B. All historical data is retained but the subsequent flashback data archives are maintained for only three years.
C. All historical data is purged and the new flashback data archives are maintained for three years.
D. All historical data older than three years is purged from the flashback archive FLA1.
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)
A. The ADR base keeps all diagnostic information in binary format
B. SQL*Plus provides the ADRI script, which can be used to work with ADR
C. The ADR can be used for problem diagnosis only when the database is open
D. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
E. The ADR can be used for problem diagnosis even when the database instance is down
F. The ADR base is shared across multiple instances
Which two statements are true about a job chain? (Choose two.)
A. A job chain can contain a nested chain of jobs.
B. The jobs in a job chain cannot have more than one dependency.
C. A job of the CHAIN type can be run using event-based or time-based schedules.
D. The jobs in a job chain can be executed only by using the events generated by the Scheduler
The Automatic Workload Repository (AWR) snapshot interval is set to 1 hour. A user of your database notifies you that the system was slow between 10:00 PM and 10:10 PM, but the Automatic Database Diagnostic Management (ADDM) analysis for the time period between
10:00
PM and 11:00 PM does not show this performance problem. What would you suggest to analyze this performance problem for the user?
A.
SQL Tuning Advisor
B.
SQL Performance Analyzer
C.
Active Session History report
D.
AWR Compare Periods report
