1Z0-184-25 試験問題を無料オンラインアクセス

What is the function of the COSINE parameter in the SQL query used to retrieve similar vectors?
topk = 3
sql = f"""select payload, vector_distance(vector, :vector, COSINE) as score from {table_name} order by score fetch approximate {topk} rows only"""

• A.It converts the vectors to a format compatible with the SQL database
• B.It indicates that the cosine distance metric should be used to measure similarity between vectors
• C.It specifies the type of vector encoding used in the database
• D.It filters out vectors with a cosine similarity below a certain threshold

Which statement best describes the core functionality and benefit of Retrieval Augmented Generation (RAG) in Oracle Database 23ai?

• A.It empowers LLMs to interact with private enterprise data stored within the database, leading to more context-aware and precise responses to user queries
• B.It enables Large Language Models (LLMs) to access and process real-time data streams from diverse sources to generate the most up-to-date insights
• C.It allows users to train their own specialized LLMs directly within the Oracle Database environment using their internal data, thereby reducing reliance on external AI providers
• D.It primarily aims to optimize the performance and efficiency of LLMs by using advanced data retrieval techniques, thus minimizing response times and reducing computational overhead

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?

• 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(512, FLOAT32))
• D.CREATE TABLE vectors (id NUMBER, embedding VECTOR(*, INT8))

What is the first step in setting up the practice environment for Select AI?

• A.Create a new user account with elevated privileges
• B.Create a policy to enable access to OCI Generative AI
• C.Drop any compartment that does not use OCI Generative AI
• D.Optionally create an OCI compartment

What is the primary difference between the HNSW and IVF vector indexes in Oracle Database 23ai?

• A.Both operate identically but differ in memory usage
• B.HNSW is partition-based, whereas IVF uses neighbor graphs for indexing
• C.HNSW uses an in-memory neighbor graph for faster approximate searches, whereas IVF uses the buffer cache with partitions
• D.HNSW guarantees accuracy, whereas IVF sacrifices performance for accuracy