Oracle Certification Exam Question: Download Oracle Certification PDF

Explain What are transportable table spaces and the need to use them?

Answer:

Transportable tablespaces are the fastest way for moving large volume of data between two oracle databases. We can use the transportable tablespaces feature to copy a set of tablespaces from one oracle database to another. Moving data using transportable tablespaces is much faster than performing either an export/import or unload/load the same data.

Download Oracle Certification PDF Read All 25 Oracle Certification Questions

Previous Question

Next Question

What are transportable table spaces and the need to use them?

Explain Which two statements are true regarding working with dates? (Choose two.)
A. The default internal storage of dates is in the numeric format
B. The default internal storage of dates is in the character format
C. The RR date format automatically calculates the century from the SYSDATE function and does
not allow the user to enter the century
D. The RR date format automatically calculates the century from the SYSDATE function but allows
the user to enter the century if required?