READ Free Dumps For Oracle- 1z0-050
| Question ID 5939 | You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB. You issued the following RMAN commands to create a duplicate database: RMAN> CONNECT target sys/sys@APPPROD RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE DB_FILE_NAME_CONVERT '/oracIe/oradata/prod/1, '/scratch/oracIe/oradata/dupdb/1 SPILE PARAMETER_VALUE_CONVERT'/oracle/oradata/prod/1, '/scratch/oracIe/oradata/dupdb/1 SET SGA_MAX_SIZE = '300M1 SET SGA_TARGET = '250M' SET LOG_FILE_NAME_CONVERT '/oracle/oradata/prod/redo/', Which three are the prerequisites for the successful execution of the above command? (Choose three.) |
| Option A | The source database should be open. |
| Option B | The target database should be in ARCHIVELOG mode if it is open. |
| Option C | RMAN should be connected to both the instances as SYSDBA |
| Option D | The target database backups should be copied to the source database backup directories. |
| Option E | The password file must exist for the source database and have the same SYS user password as the target. |
| Correct Answer | A,C,E |
| Question ID 5940 | You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements will be true in this scenario? (Choose all that apply.) |
| Option A | The disk automatically goes offline. |
| Option B | The disk is immediately dropped from the disk group. |
| Option C | The ASM tracks the extents that are modified during the outage. |
| Option D | The ASM migrates the extents from the unavailable disk to the remaining disks |
| Correct Answer | A,C |