READ Free Dumps For Oracle- 1z0-050
| Question ID 6005 | 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:
| |||
| Option A | It produces an error because data already exists in the table. | |||
| Option B | It produces an error because compression can be enabled at table creation only. | |||
| Option C | It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately. | |||
| Option D | It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data. | |||
| Correct Answer | C |
ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS;
What would be the outcome of this command?| Question ID 6006 | Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.) |
| Option A | flashback query |
| Option B | distributed transactions |
| Option C | logging in and logging out of sessions |
| Option D | all DDL statements having bind variables |
| Option E | direct path load of data from external files |
| Correct Answer | C,D |