READ Free Dumps For Oracle- 1z0-050
| Question ID 6029 | Evaluate the following command: |
| Option A | The LOB values are automatically compressed. |
| Option B | The LOB values are cached by default in the buffer cache. |
| Option C | The LOB values are automatically stored in encrypted mode. |
| Option D | All LOB data that is identical in two or more rows in a LOB column share the same data blocks. |
| Correct Answer | D |
SQL> CREATE TABLE design_data (id NUMBER, doc CLOB) LOB(doc) STORE AS SECUREFILE(DEDUPLICATE); Which statement is true regarding the above command| Question ID 6030 | You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1; What is the effect of this command? |
| Option A | The tablespace having Flashback Archive is dropped. |
| Option B | The Flashback Archive FLA1 is dropped only if it is empty. |
| Option C | The Flashback Data Archive and historical data are dropped. |
| Option D | The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive. |
| Correct Answer | D |