Exam 1z0-1157-26 Topic 1 Question 56 Discussion

Actual exam question for Oracle's 1z0-1157-26 exam
Question #: 56
Topic #: 1
Which SQL function computes distance between vectors in Oracle AI Vector Search?

Suggested Answer: C Vote an answer

Oracle AI Vector Search uses the SQL function VECTOR_DISTANCE() as its principal mechanism for computing mathematical distance between two vector representations. The function accepts two vector expressions and can optionally accept a distance metric. Oracle describes VECTOR_DISTANCE as the main vector-distance function and supports metrics appropriate to similarity-search workloads, with cosine behavior available according to the query and vector-index configuration.
Vector distance is fundamental to semantic retrieval because an embedding model represents meaning as numerical coordinates in multidimensional space. A query embedding can therefore be compared with stored embeddings, and results can be ranked according to their calculated distance. Oracle's documentation demonstrates this pattern using ORDER BY VECTOR_DISTANCE(...) to identify vectors semantically closest to the query vector.
Oracle also provides shorthand functions such as L1_DISTANCE , L2_DISTANCE , COSINE_DISTANCE , and INNER_PRODUCT , but none of the alternative names supplied in this question- VECTOR_SCORE , SCORE_SIMILARITY , or EMBEDDING_DISTANCE -is the principal Oracle SQL function being tested.
Therefore, C is unequivocally correct and matches the uploaded source answer.
Study Guide reference/topic: Agentic AI for Oracle AI Database - Oracle AI Vector Search, VECTOR_DISTANCE, distance metrics, and similarity search.

by Hale at Oct 11, 2026, 03:56 AM

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

0
0
0
10