Which statement describes the purpose of the system$clustering_ratio function?

• A. To retrieve the clustering ratio of a table.
• B. To retrieve the depth.
• C. To retrieve clustering information.
• D. To modify clustering.

Answer: (A)

System$clustering_ratio provides a numeric value that indicates how well a table’s data is ordered with respect to its clustering keys. It’s a read‑only metric used to gauge clustering quality and to help decide whether reclustering might improve performance. It does not return a general depth of clustering, it does not modify clustering, and there are other functions that can give broader clustering details. So describing its purpose as retrieving the clustering ratio of a table best captures what this function does.