Oracle Certification Exam Question:

Download Job Interview Questions and Answers PDF

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

Oracle Certification Interview Question
Oracle Certification Interview Question

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 oneoracle 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 Interview Questions And Answers PDF

Previous QuestionNext Question
Which three statements are true regarding subqueries? (Choose three.)
A. Subqueries can contain GROUP BY and ORDER BY clauses
B. Main query and subquery can get data from different tables
C. Main query and subquery must get data from the same tables
D. Subqueries can contain ORDER BY but not the GROUP BY clause
E. Only one column or expression can be compared between the main query and subqeury
F. Multiple columns or expressions can be compared between the main query and subquery		Explain What are transportable table spaces and the need to use them?