READ Free Dumps For Oracle- 1z0-050
| Question ID 5945 | Which statement about the enabling of table compression in Oracle Database 11g is true? |
| Option A | Compression can be enabled at the table, tablespace, or partition level for direct loads only. |
| Option B | Compression can be enabled only at the table level for both direct loads and conventional DML. |
| Option C | Compression can be enabled at the table, tablespace, or partition level for conventionalDML only. |
| Option D | Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML. |
| Correct Answer | D |
| Question ID 5946 | Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.) |
| Option A | Supplemental log must be enabled. |
| Option B | Supplemental log must be enabled for the primary key |
| Option C | Undo retention guarantee for the database must be configured. |
| Option D | Execute permission on the DBMS_FLASHBACK package must be granted to the user. |
| Correct Answer | A,B,D |