Question 1

Which of the fpllowing statements is NOT true regarding operations on VECTOR columns?

Options :

A : You can use CTAS (Create Table As Select) to create a new table with a VECTOR column based on an existing table.

B : You tan update a VECTOR column based on the value of another column in the same table.

C : You can drop a VECTOR column from a table using ALTER DROP COLUMN.

D : You can perform direct comparisons between two VECTOR columns using operators like

Answer: D

Question 2

What is the purpose of the Vector Pool in Oracle Database 23ai?

Options :

A : To manage database partitioning

B : To store HNSW vector indexes and IVF index metadata

C : To enable longer SQL execution

D : To store non-vector data types

Answer: B

Question 3

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?

Options :

A :

Encodes the question and database chunks into vectors, finds the most similar using cosine similarity, and includes them in the LLM prompt

B : Trains a separate LLM on the database and uses it to answer, ignoring the general LLM

C : Converts the question to keywords, searches for matches, and inserts the text into the response

D : Clusters similar text chunks and randomly selects one from the most relevant cluster

Answer: A

Question 4

What type of data, can be used for creating Vector Embeddings?

Options :

A : Image data

B : Audio data

C : Text data

D : All of the above

Answer: D

Question 5

Which operation is NOT permitted on tables containing VECTOR columns?

Options :

A : SELECT

B : UPDATE

C : DELETE

D : JOIN ON VECTOR columns

Answer: D

Higher Test Marks with Free Online 1Z0-184-25 Exam Practice

Buying Options: