READ Free Dumps For Oracle- 1z0-050
| Question ID 6055 | Which dependent object will get invalidated even if it is not affected by the table redefinition? |
| Option A | views |
| Option B | triggers |
| Option C | packages |
| Option D | synonyms |
| Correct Answer | B |
| Question ID 6056 | You are managing an Oracle Database 11 g instance. You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication? (Choose all that apply.) |
| Option A | The source database backup must be copied over the net for test database, |
| Option B | The source database must be run in ARCHIVELOG mode if the database is open. |
| Option C | The source database must be shut down cleanly if the database is in mounted state. |
| Option D | A net service name should be set up and a listener configured with the target as well as the source database. |
| Correct Answer | B,C,D |