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