READ Free Dumps For Oracle- 1z0-023
| Question ID 8894 | What would a DBA do to create the metadata for transportable tablespace?
|
| Option A | Use the DBMS_TTS package.
|
| Option B | Use the CREATE METADATA command.
|
| Option C | Use the TRANSPORT_TABLESPACE export parameter
|
| Option D | Use the ALTER TABLESPACE tablespace METADATA ´filename´; command.
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct. To create the metadata for transportable tablespace a DBA must use the TRANSPORT_TABLESPACE export parameter. Incorrect Answers: A: The DBMS_TTS package will not create the metadata for transportable tablespace. B: There is no CREATE METADATA command in Oracle. D: There is no ALTER TABLESPACE ... METADATA command in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1146 Chapter 24: Oracle8i New Features Topics
| Question ID 8895 | Which role needs to be assigned to a user in order to export object owned by another user?
|
| Option A | EXPORT_ALL
|
| Option B | EXP_DATABASE
|
| Option C | DBA_SYS_PRIVS
|
| Option D | EXP_FULL_DATABASE
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct. To be able to export object owned by another user EXP_FULL_DATABASE role needs to be assigned to a user. Incorrect Answers: A: There is no EXPORT_ALL role in Oracle. B: There is no EXP_DATABASE role in Oracle. C: There is no DBA_SYS_PRIVS role in Oracle, there is only DBA_SYS_PRIVS data dictionary view. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 534-538 Chapter 11: Data Loads and National Language Support