Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

What is the significance of using local ONNX models for embedding within the database?

A.

Support for legacy SQL*Plus clients

B.

Improved accuracy compared to external models

C.

Reduced embedding dimensions for faster processing

D.

Enhanced security because data remains within the database

Which function should you use to determine the storage format of a vector?

A.

VECTOR_DIMENSION_FORMAT

B.

VECTOR_CHUNKS

C.

VECTOR_NORM

D.

VECTOR_EMBEDDING

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

A.

Creating a new table using CTAS (CREATE TABLE AS SELECT) that includes the VECTOR column from the original table

B.

Dropping an existing VECTOR column from the table

C.

Modifying the data type of an existing VECTOR column to a non-VECTOR type

D.

Adding a new VECTOR column to the table

Which SQL function is used to create a vector embedding for a given text string in Oracle Database 23ai?

A.

GENERATE_EMBEDDING

B.

CREATE_VECTOR_EMBEDDING

C.

EMBED_TEXT

D.

VECTOR_EMBEDDING

What is the primary function of an embedding model in the context of vector search?

A.

To define the schema for a vector database

B.

To execute similarity search operations within a database

C.

To transform text or data into numerical vector representations

D.

To store vectors in a structured format for efficient retrieval

In Oracle Database 23ai, which SQL function calculates the distance between two vectors using the Euclidean metric?

A.

L1_DISTANCE

B.

L2_DISTANCE

C.

HAMMING_DISTANCE

D.

COSINE_DISTANCE

What is the default distance metric used by the VECTOR_DISTANCE function if none is specified?

A.

Euclidean

B.

Hamming

C.

Cosine

D.

Manhattan

Which is a characteristic of an approximate similarity search in Oracle Database 23ai?

A.

It compares every vector in the dataset

B.

It trades off accuracy for faster performance

C.

It always guarantees 100% accuracy

D.

It is slower than exact similarity search

How is the security interaction between Autonomous Database and OCI Generative AI managed in the context of Select AI?

A.

By encrypting all communication between the Autonomous Database and OCI Generative AI using TLS/SSL protocols

B.

By utilizing Resource Principals, which grant the Autonomous Database instance access to OCI Generative AI without exposing sensitive credentials

C.

By establishing a secure VPN tunnel between the Autonomous Database and OCI Generative AI service

D.

By requiring users to manually enter their OCI API keys each time they execute a natural language query

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.

Change the index type to HNSW for better accuracy

C.

Increase the VECTOR_MEMORY_SIZE initialization parameter

D.

Re-create the index with a higher EFCONSTRUCTION value