READ Free Dumps For Oracle- 1z0-050
| Question ID 5983 | You upgraded Oracle Database 10g to Oracle Database 11 g. How would this affect the existing users' passwords? |
| Option A | All passwords automatically become case-sensitive. |
| Option B | All passwords remain non-case-sensitive till they are changed. |
| Option C | All passwords remain non-case-sensitive and cannot be changed. |
| Option D | All passwords remain non-case-sensitive until their password attribute in the profile is altered. |
| Correct Answer | B |
| Question ID 5984 | What recommendations does the SQL Access Advisor provide for optimizing SQL queries? (Choose all that apply.) |
| Option A | selection of SQL plan baselines |
| Option B | partitioning of tables and indexes |
| Option C | creation of index-organized tables |
| Option D | creation of bitmap, function-based, and B-tree indexes |
| Option E | optimization of materialized views for maximum query usage and fast refresh |
| Correct Answer | B,D,E |