READ Free Dumps For Oracle- 1z0-020
| Question ID 7804 | In the DBA_TRIGGERS data dictionary view, the value in the TABLE_NAME column will be NULL in which two situations? (Choose two) |
| Option A | The trigger is a schema trigger. |
| Option B | The trigger is a database trigger. |
| Option C | The trigger was created with the CREATE ANY TRIGGER privilege. |
| Option D | The trigger was created by a user who connected with the CONNECT INTERNAL command. |
| Correct Answer | AB |
| Question ID 7805 | 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 |