Question 1

You are tasked with creating a table to store vector embeddings with the following characteristics: Each vector must have exactly 512 dimensions, and the dimensions should be stored as 32-bitfloating point numbers. Which SQL statement should you use?

Options :

A : CREATE TABLE vectors (id NUMBER, embedding VECTOR(512))

B : CREATE TABLE vectors (id NUMBER, embedding VECTOR)

C : CREATE TABLE vectors (id NUMBER, embedding VECTOR(*, INT8

D : CREATE TABLE vectors (id NUMBER, embedding VECTOR(512, FLOAT32))

Answer: D

Question 2

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 3

Assuming we have a table called VT2 that contains vectors for mapping various shapes, colors, and sizes, what is the primary purpose of the following UPDATE statements? SQL> UPDATE vt2SET shape = 'TriangleWHERE id IN (2, 4, 7, 22, 31, 41, 44, 55);SQL> UPDATE vt2SET size = 'Medium'WHERE id IN (5, 22, 25, 32, 34, 42, 43, 53, 54, 55);

Options :

A : To add new rows of data to the VT2 table with different sizes and shapes.

B : To assign attributes like size and shape to existing vectors based on their IDs.

C : To delete rows from the VT2 table that do not meet specific criteria.

D : To modify the vector values stored in the VT2 table.

Answer: B

Question 4

What is the correct order of steps for building a RAG application using PL/SQL in Oracle Database 23ai?

Options :

A : Load ONNX Model, Vectorize Question, Load Document, Split Text into Chunks, Create Embeddings, Perform Vector Search, Generate Output

B : Load Document, Split Text into Chunks, Load ONNX Model, Create Embeddings, Vectorize Question, Perform Vector Search, Generate Output

C : Vectorize Question, Load ONNX Model, Load Document, Split Text into Chunks, Create Embeddings, Perform Vector Search, Generate Output

D : Load Document, Load ONNX Model, Split Text into Chunks, Create Embeddings, VectorizeQuestion, Perform Vector Search, Generate Output

Answer: B

Question 5

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

Smartly Prepare Exam with Free Online 1Z0-184-25 Practice Test

Buying Options: