READ Free Dumps For Oracle- 1z0-020
| Question ID 8272 | Your standby database has been in read-only mode for the past five hours. During this time ten log switched have taken place on the production database. The DBA now wants to put the database into a sustained recovery mode. What happens to the archive logs? |
| Option A | They are applied to the standby database while in read-only mode. |
| Option B | They are applied to the standby database automatically when the DBA issues the ALTER DATABASE RECOVER MANAGED DATABASE command. |
| Option C | They are applied to the standby database automatically when the DBA issues the ALTER DATABASE RECOVER DATABASE command. |
| Option D | The DBA must manually apply the archived logs to the database, before putting the database into standby mode. |
| Option E | The archive logs are stored on the production server, and are transferred across when the standby database returns to managed recovery. |
| Correct Answer | B |
| Question ID 8273 | A DBA now has the ability to mark certain blocks of a table as being corrupt. This will enable a full table scan to skip over them. In order to achieve this, which command should a DBA issue? |
| Option A | ALTERTABLE<table_name> MARK<block_id> ; |
| Option B | SELECT*FROM<table_name> SKIP<block_id> ; |
| Option C | Run the DBVERIFY utility on the relevant datafile |
| Option D | ALTER TABLESPACE<table_space> MARK<block_id> ; |
| Option E | EXECUTE DBMS_REPAIR.SKIP_CORRUPT_BLOCKS ('<scema_name>,'table_name> '') |
| Correct Answer | C |