READ Free Dumps For Oracle- 1z0-050
| Question ID 1817 | 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 | A. Enable Flashback Data Archive for the tables. |
| Option B | B. Enable supplemental logging for the database. |
| Option C | C. Specify undo retention guarantee for the database. |
| Option D | D. Create Flashback Data Archive on the tablespace on which the tables are stored. |
| Option E | 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 |
| Question ID 1818 | Your organization decided to upgrade the existing Oracle 10g database to Oracle 11 g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script: |
| Option A | A. It performs parallel recompilation of only the stored PL/SQL code. |
| Option B | B. It performs sequential recompilation of only the stored PL/SQL code. |
| Option C | C. It performs parallel recompilation of any stored PL/SQL as well as Java code. |
| Option D | D. It performs sequential recompilation of any stored PL/SQL as well as Java code. |
| Correct Answer | C |