READ Free Dumps For Oracle- 1z0-023
| Question ID 8813 | Before a DBA creates a transportable tablespace, which two conditions must be completed? (Choose two)
|
| Option A | All indexes are disabled or dropped.
|
| Option B | The target system has precreated the tablespace.
|
| Option C | The target system is in the same operating system.
|
| Option D | The target system is in the same block size system.
|
| Option E | The tables containing nested tables are contained in the same tablespace.
|
| Correct Answer | CD |
Explanation Explanation/Reference: Explanation: Answers C and D are correct. There are two restrictions on a transportable tablespace : the target system must be in the same operating system and in the same block size as source system. Incorrect Answers: A: You don't need to drop or disable indexes for transportable tablespace. B: The target system don't need to have precreated the tablespace. E: You cannot create a transportable tablespace with the tables containing nested tables. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1146 Chapter 24: Oracle8i New Features Topics
| Question ID 8814 | Can you drop objects from a read-only tablespace?
|
| Option A | No
|
| Option B | Yes
|
| Option C | Only when using the DBA role
|
| Option D | Only when the tablespace is online
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct. You can drop objects from a read-only tablespace when it is online. Incorrect Answers: A: You can drop objects from a read-only tablespace if it's online. B: Answer is correct only if tablespace is online. C: Not only user with DBA role can drop objects from a read-only tablespace. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 340-341 Chapter 7: Managing the Physical Database Structure