PrepAway - Latest Free Exam Questions & Answers

Which command(s) can be used to do this?

Tables TABLE_A and TABLE_B in database TESTDB have the same data structure (same columns with
the same definitions). You wish to unload the data from the two tables into a single file In PC/IXF
format. Which command(s) can be used to do this?

PrepAway - Latest Free Exam Questions & Answers

A.
EXPORT TO combined.ixf OF IXF SELECT * FROM table_a UNION ALL SELECT *
FROM table_b

B.
EXPORT TO combined.ixf OF IXF SELECT * FROM table_a, table_b

C.
EXPORT TO combined.ixf OF IXF SELECT * FROM table_a:
EXPORT APPEND TO combined.ixf OF IXF SELECT * FROM table_b;

D.
EXPORT TO combined.ixf OF IXF SELECT * FROM table a INTERSECT SELECT *
FROM table b


Leave a Reply