Chat with us

Read online free dumps for Oracle- 1z0-023

Here you can read online questions and answers for Oracle Exam 1z0-023 (Architecture and Administration ) 100% free...

Question ID 8722

What is one reason for using the package DBMS_TTS? DATA01 has

Option A

To verify that a tablespace is self-contained.

Option B

To drop indexes outside a transportable tablespace.

Option C

To create the metadata for a transportable tablespace.

Option D

To attach transportable tablespaces datafiles to the database.

Correct Answer A
Description
Update Date and Time 2017-08-10 03:25:31

Question ID 8723

What is one reason for using the package DBMS_TTS? DATA01 has

Option A

To verify that a tablespace is self-contained.

Option B

To drop indexes outside a transportable tablespace.

Option C

To create the metadata for a transportable tablespace.

Option D

To attach transportable tablespaces datafiles to the database.

Correct Answer A
Description Explanation/Reference: Explanation: Answer A is correct. You need to use the package DBMS_TTS to check that a tablespace is self-contained. Incorrect Answers: B: You don't need to drop indexes outside a transportable tablespace, the DBMS_TTS package is not used for this purpose either. C: To create metadata for a transportable tablespace use TRANSPORT_TABLESPACE export parameter. D: This package is not used to attach transportable tablespaces datafiles to the database. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1146 Chapter 24: Oracle8i New Features Topics
Update Date and Time 2017-08-10 03:27:33