READ Free Dumps For Oracle- 1z0-050
| Question ID 1857 | 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 | A. It produces an error because data already exists in the table. |
| Option B | B. It produces an error because compression can be enabled at table creation only. |
| Option C | C. It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately. |
| Option D | 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 |
| Question ID 1858 | Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.) |
| Option A | A. flashback query |
| Option B | B. distributed transactions |
| Option C | C. logging in and logging out of sessions |
| Option D | D. all DDL statements having bind variables |
| Option E | E. direct path load of data from external files |
| Correct Answer | C,D |