READ Free Dumps For Oracle- 1z0-060
| Question ID 2129 | Examine this command: |
| Option A | A. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered. |
| Option B | B. Statistics collection is not done for the CUSTOMERS table when database stats are gathered. |
| Option C | C. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time. |
| Option D | D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics. |
| Option E | E. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics. |
| Correct Answer | C,D,E |
| Question ID 2130 | Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):
Which three are prerequisites for successful execution of the command? |
| Option A | A. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role. |
| Option B | B. All the user-defined tablespaces must be in read-only mode on the source database. |
| Option C | C. The export dump file must be created before starting the import on the target database. |
| Option D | D. The source and target database must be running on the same platform with the same endianness. |
| Option E | E. The path of data files on the target database must be the same as that on the source database. |
| Option F | F. The impdp operation must be performed by the same user that performed the expdp operation. |
| Correct Answer | A,B,D |
