Oracle AI Vector Search Professional - 1Z0-184-25 Exam Questions [2026]

QUESTION NO: 1
Which Oracle Cloud Infrastructure (OCI) service is directly integrated with Select AI?

A. OCI Language B. OCI Generative AI C. OCI Vision D. OCI Data Science

Correct Answer: B

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 2
Which operation is NOT permitted on tables containing VECTOR columns?

A. DELETE B. UPDATE C. SELECT D. JOIN ON VECTOR columns

Correct Answer: D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 3
What is the function of the COSINE parameter in the SQL query used to retrieve similar vectors?
topk = 3
sql = f"""select payload, vector_distance(vector, :vector, COSINE) as score from {table_name} order by score fetch approximate {topk} rows only"""

A. It converts the vectors to a format compatible with the SQL database B. It filters out vectors with a cosine similarity below a certain threshold C. It specifies the type of vector encoding used in the database D. It indicates that the cosine distance metric should be used to measure similarity between vectors

Correct Answer: D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 4
How does an application use vector similarity search to retrieve relevant information from a database, and how is this information then integrated into the generation process?

A. Encodes the question and database chunks into vectors, finds the most similar using cosine similarity, and includes them in the LLM prompt B. Clusters similar text chunks and randomly selects one from the most relevant cluster C. Converts the question to keywords, searches for matches, and inserts the text into the response D. Trains a separate LLM on the database and uses it to answer, ignoring the general LLM

Correct Answer: A

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 5
Which DDL operation is NOT permitted on a table containing a VECTOR column in Oracle Database 23ai?

A. Adding a new VECTOR column to the table B. Creating a new table using CTAS (CREATE TABLE AS SELECT) that includes the VECTOR column from the original table C. Dropping an existing VECTOR column from the table D. Modifying the data type of an existing VECTOR column to a non-VECTOR type

Correct Answer: D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 6
You are storing 1,000 embeddings in a VECTOR column, each with 256 dimensions using FLOAT32. What is the approximate size of the data on disk?

A. 256 KB B. 1 GB C. 1 MB D. 4 MB

Correct Answer: D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 7
A machine learning team is using IVF indexes in Oracle Database 23ai to find similar images in a large dataset. During testing, they observe that the search results are often incomplete, missing relevant images. They suspect the issue lies in the number of partitions probed. How should they improve the search accuracy?

A. Add the TARGET_ACCURACY clause to the query with a higher value for the accuracy B. Increase the VECTOR_MEMORY_SIZE initialization parameter C. Re-create the index with a higher EFCONSTRUCTION value D. Change the index type to HNSW for better accuracy

Correct Answer: A

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).