READ Free Dumps For Oracle- 1z0-050
| Question ID 6089 | What two statements are true regarding the recommendations received from the SQL Access Advisor? (Choose two.) |
| Option A | It can recommend partitioning only on tables that have at least 10,000 rows. |
| Option B | It cannot generate recommendations that support multiple workload queries. |
| Option C | It can recommend only B-tree indexes and not bitmap or function-based indexes. |
| Option 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 |
| Question ID 6090 | What are the advantages of variable extent size support for large ASM files? (Choose two.) |
| Option A | It improves performance in the extended cluster configuration by reading from a local copy of an extent. |
| Option B | It improves resync operations when the disk comes online after being taken offline for maintenance purposes. |
| Option C | This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents. |
| Option D | Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool. |
| Correct Answer | C,D |