READ Free Dumps For Oracle- 1z0-050
| Question ID 5969 | You issued the following command on the temporary tablespace LMTEMP in your database: SQL>ALTER TABLESPACE Imtemp SHRINK SPACE KEEP 20M; Which requirement must be fulfilled for this command to succeed? |
| Option A | The tablespace must be locally managed. |
| Option B | The tablespace must have only one temp file. |
| Option C | The tablespace must be made nondefault and offline. |
| Option D | The tablespace can remain as the default but must have no active sort operations. |
| Correct Answer | A |
| Question ID 5970 | You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task? |
| Option A | Enable Flashback Data Archive for the tables. |
| Option B | Enable supplemental logging for the database. |
| Option C | Specify undo retention guarantee for the database. |
| Option D | Create Flashback Data Archive on the tablespace on which the tables are stored. |
| Option E | Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size. |
| Correct Answer | A |