Oracle
1Z0-050 · Question #78
1Z0-050 Question #78: Real Exam Question with Answer & Explanation
The correct answer is C. It compresses all data added or modified henceforth but the existing data in the table is not. See the full explanation below for the reasoning.
Question
Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command: ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS; What would be the outcome of this command?
Options
- AIt produces an error because data already exists in the table.
- BIt produces an error because compression can be enabled at table creation only.
- CIt compresses all data added or modified henceforth but the existing data in the table is not
- DIt immediately compresses all existing data as well as new data, resulting from either fresh
Community Discussion
No community discussion yet for this question.