Oracle 1Z0-184-25 Quiz 1 Topic 1 Questions 1-5

Question: 1

You are asked to fetch the top five vectors nearest to a query vector, but only for a specific category of documents. Which query structure should you use?

AUse UNION ALL with vector operations

BPerform the similarity search without a WHERE clause

CApply relational filters and a similarity search in the query

DUse VECTOR_INDEX_HINT and NO WHERE clause

Show Answer

Question: 2

What is the primary purpose of a similarity search in Oracle Database 23ai?

AOptimize relational database operations to compute distances between all data points in a database

BTo find exact matches in BLOB data

CTo retrieve the most semantically similar entries using distance metrics between different vectors

DTo group vectors by their exact scores

Show Answer

Question: 3

Which vector index available in Oracle Database 23ai is known for its speed and accuracy, making it a preferred choice for vector search?

ABinary Tree (BT) index

BInverted File System (IFS) index

CInverted File (IVF) index

DHierarchical Navigable Small World (HNSW) index

Show Answer

Question: 4

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?

A1 MB

B4 MB

C256 KB

D1 GB

Show Answer

Question: 5

Which SQL statement correctly adds a VECTOR column named "v" with 4 dimensions and FLOAT32 format to an existing table named "my_table"?

AALTER TABLE my_table MODIFY (v VECTOR(4, FLOAT32))

BALTER TABLE my_table ADD (v VECTOR(4, FLOAT32))

CUPDATE my_table SET v = VECTOR(4, FLOAT32)

DALTER TABLE my_table ADD v VECTOR(4, FLOAT32)

Show Answer

Oracle 1Z0-184-25 Quiz:1 Topic:1 Questions:1-5