Oracle
1Z0-050 · Question #78
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…
Sign in or unlock 1Z0-050 to reveal the answer and full explanation for question #78. The question stem and answer options stay visible for context.
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
Unlock 1Z0-050 to see the answer
You've previewed enough free 1Z0-050 questions. Unlock 1Z0-050 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.