READ Free Dumps For Oracle- 1z0-050
| Question ID 1959 | Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates? |
| Option A | A. AWR baselines are always created as repeating baselines. |
| Option B | B. AWR baselines can be created on the basis of two time values. |
| Option C | C. AWR baselines are always created with infinite expiration duration. |
| Option D | D. AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration. |
| Correct Answer | B |
| Question ID 1960 | What two statements are true regarding the recommendations received from the SQL Access Advisor? (Choose two.) |
| Option A | A. It can recommend partitioning only on tables that have at least 10,000 rows. |
| Option B | B. It cannot generate recommendations that support multiple workload queries. |
| Option C | C. It can recommend only B-tree indexes and not bitmap or function-based indexes. |
| Option D | D. It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type. |
| Correct Answer | A,D |