1Z0-184-25 Question 167
Select 2Your organization uses an Oracle Autonomous Database for analytics, and you plan to enable the 'Select AI' feature so business users can query sales data in plain English. You have granted them the necessary privileges on the SALES table and created synonyms to simplify references. Which two statements are correct about using natural language prompts with Select AI in this scenario?
- A
Select AI automatically configures advanced indexes at runtime without additional user input or cost.
- B
Users must have the appropriate privileges to access the underlying data for the natural language query to succeed.
- C
You can review and adjust the AI-generated SQL statement before executing it against the database.
- D
Synonyms are not needed because the AI engine ensures it references the correct table automatically.
Show answer and explanation
Correct answers: B, C
Explanation
When using Select AI with Autonomous Database, administrators should ensure that end-users have the correct privileges on the tables they need to query, and they should configure synonyms or well-chosen table names for clarity. Users can always validate and fine-tune the AI-generated SQL statements before execution, aligning with standard database security and performance practices. For more details, refer to Oracle� Autonomous Database documentation on managing access privileges and using AI-based natural language queries.
- A. Incorrect.
Option 1: Incorrect. While Select AI can intelligently propose queries, it does not automatically deploy or manage new indexes on the table without user involvement. Indexing strategies remain under the database administrator� control.
- B. Correct.
Option 2: Correct. To query data using either SQL or natural language prompts, users must have privileges such as SELECT on the relevant tables or views. Otherwise, the AI-driven query cannot return data.
- C. Correct.
Option 3: Correct. Select AI typically generates SQL statements based on the user� natural language prompt, and you can review, refine, or modify these statements before executing them. This step allows you to ensure the query meets your needs.
- D. Incorrect.
Option 4: Incorrect. Synonyms or explicit references often help the AI engine map user-friendly names to actual database objects. While Select AI can handle some contextual analysis, best practice is to define synonyms or use canonical table names for clarity.