A database administrator wants to change the VECTOR_MEMORY_SIZE parameter for a pluggable database (PDB) in Oracle Database 23ai. Which SQL command is correct?

• A.ALTER SYSTEM SET VECTOR_MEMORY_SIZE=1G SCOPE=BOTH
• B.ALTER DATABASE SET VECTOR_MEMORY_SIZE=1G SCOPE=VECTOR
• C.ALTER SYSTEM SET VECTOR_MEMORY_SIZE=1G SCOPE=SGA
• D.ALTER SYSTEM RESET VECTOR_MEMORY_SIZE

Comment: *

Name: *

Email: *

Verification: *

If a query vector uses a different distance metric than the one used to create the index, whathappens?

• A.The query fails
• B.An exact match search is triggered
• C.The index automatically updates
• D.A warning is logged, but the query executes

Comment: *

Name: *

Email: *

Verification: *

Which operation is NOT permitted on tables containing VECTOR columns?

• A.SELECT
• B.UPDATE
• C.DELETE
• D.JOIN ON VECTOR columns

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

In the following Python code, what is the significance of prepending the source filename to each text chunk before storing it in the vector database?
bash
CollapseWrapCopy
docs = [{"text": filename + "|" + section, "path": filename} for filename, sections in faqs.items() for section in sections]
# Sample the resulting data
docs[:2]

• A.It preserves context and aids in the retrieval process by associating each vectorized chunk with its original source file
• B.It helps differentiate between chunks from different files but has no impact on vectorization
• C.It speeds up the vectorization process by providing a unique identifier for each chunk
• D.It improves the accuracy of the LLM by providing additional training data

Comment: *

Name: *

Email: *

Verification: *