Oracle Certification

A. Subqueries can contain GROUP BY and ORDER BY clauses

B. Main query and subquery can get data from different tables

F. Multiple columns or expressions can be compared between the main query and subquery

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.

This will produce Error:

Expression must have same datatype as corresponding expression

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.

A. The default internal storage of dates is in the numeric format

D. The RR date format automatically calculates the century from the SYSDATE function but allows

the user to enter the century if required