1Z0-184-25 Question 25
Single answerYou are managing an Autonomous Database on Oracle Cloud Infrastructure where you store product embeddings in a table named PRODUCT_EMBEDDINGS. Each row has a VECTOR column (dimension 512) used for similarity searches. You need to update the embeddings for a subset of products based on newly trained models. How should you perform the update to ensure the vector index remains valid for future searches?
- A
Use a standard UPDATE statement ensuring the replacement array matches the exact dimension, so the index updates automatically as the data changes.
- B
Insert rows with the new embeddings into a temporary table, drop the vector index on PRODUCT_EMBEDDINGS, and recreate it after copying the data back.
- C
Truncate the PRODUCT_EMBEDDINGS table and reload the embeddings in a single bulk load to rebuild the index at once.
- D
Manually drop and recreate the vector index for each row that you update.
Show answer and explanation
Correct answer: A
Explanation
When updating vector columns in Oracle Cloud Infrastructure, it is crucial to maintain the exact dimension and data type to keep the underlying vector index consistent. The index is automatically updated with standard DML, so you do not need to drop and rebuild it for incremental changes. For more details, refer to Oracle� documentation on 'Vector Datatype and Indexing in Autonomous Database'.
- A. Correct.
Correct. Oracle� vector index is automatically maintained if the new vector dimensions are correct, so a simple UPDATE is sufficient. The dimension must match exactly to avoid errors.
- B. Incorrect.
Incorrect. Dropping and recreating the vector index is not necessary for routine updates and would cause downtime and extra overhead.
- C. Incorrect.
Incorrect. Truncating the table can be highly disruptive. It unnecessarily removes all existing data, which is inefficient unless you need a complete refresh.
- D. Incorrect.
Incorrect. The vector index does not need to be dropped and recreated on a row-by-row basis; it is automatically maintained with standard DML operations.