READ Free Dumps For Oracle- 1z0-050
| Question ID 5965 | Which two changes and their effect on the system can be tested by using the Database Replay feature? (Choose two.) |
| Option A | multiplexing of the control file |
| Option B | database and operating system upgrades |
| Option C | adding the redo log member to the database |
| Option D | changing the database storage to ASM-managed storage |
| Correct Answer | B,D |
| Question ID 5966 | You executed the following commands: SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false; SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS('SHI, 'CUSTOMERS', 'PUBLISH'.'false'); SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH', 'CUSTOMERS');
|
| Option A | The statistics are stored in the pending statistics table in the data dictionary. |
| Option B | The statistics are treated as the current statistics by the optimizer for all sessions. |
| Option C | The statistics are treated as the current statistics by the optimizer for the current sessions only. |
| Option D | The statistics are temporary and used by the optimizer for all sessions until this session terminates. |
| Correct Answer | A |
Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?