Oracle
1Z0-060 · Question #27
1Z0-060 Question #27: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-060 to reveal the answer and full explanation for question #27. The question stem and answer options stay visible for context.
Question
Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table's indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?
Options
- AOracle Data Pump.
- BAn ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
- CAn ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
- DOnline Table Redefinition.
- EEdition-Based Table Redefinition.
Unlock 1Z0-060 to see the answer
You've previewed enough free 1Z0-060 questions. Unlock 1Z0-060 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.