Oracle AI Database Foundations Associate (1Z0-1195-26) - Practice Exam 1

1. A business user wants to ask a data question in natural language and have the database help translate it into a suitable query. Which Oracle capability should the team investigate?
2. A client application is configured to use a database wallet for a supported secure connection. How should the team handle that wallet?
3. A company adds new product documents to a semantic-search collection. Which action is required for those documents to participate meaningfully in embedding-based retrieval?
4. A company processes many short account updates and also runs analytical queries over historical records. What distinction should a practitioner understand?
5. A dashboard should show total sales by month rather than a separate line for every raw transaction. Which data-processing step is needed?
6. A data pipeline accesses files in Object Storage before loading them into a database. Which practice is appropriate for the required credentials or resource authorization?
7. A database should be reachable only through an approved private network path. Which connectivity configuration is most relevant?
8. A developer chooses an Autonomous AI Database because Oracle automates many infrastructure and database-management tasks. Which responsibility still belongs to the application team?
9. A developer creates an APEX application over confidential customer records. Which statement about security is correct?
10. A developer has permission to view an Autonomous AI Database resource in OCI but cannot query an application table. What should the team understand?
11. A fraud team needs to explore relationships among people, accounts, and transactions. Which data-model capability is especially suited to relationship traversal?
12. A mobile application sends product records with nested attributes. Which data representation naturally supports such semistructured records?
13. A model-development team uses sales records to predict customer churn. Why should it separate training examples from suitable evaluation examples?
14. A policy assistant uses vector search to retrieve evidence for a generated answer. Which TWO practices are appropriate? Select TWO.
15. A project evaluates Oracle AI Database's converged approach. Which expected benefit is reasonable?
16. A retail application must store structured order rows and preserve flexible product properties that vary by category. Which TWO data forms can be useful in a converged Oracle database? Select TWO.
17. A small team needs a database-backed web application with forms and reports while minimizing handwritten interface code. Which Oracle capability is the most direct fit?
18. A support portal needs to find documents whose meaning matches a question even when they use different words. Which Oracle AI Database capability should the team evaluate?
19. A team accidentally changes business data and needs a recovery strategy. What is the appropriate foundations-level approach?
20. A team compares exact vector search with an approximate vector index. Which trade-off should it understand?
21. A team enables natural-language database querying. Which control remains necessary when generated SQL accesses business tables?
22. A team loads sales data containing inconsistent date formats and duplicate records. What should it do before treating resulting charts as reliable business evidence?
23. A team provisions an Autonomous AI Database for a new application. Which input should it choose based on expected workload requirements?
24. A team stores customer records in relational tables and product attributes as JSON. It wants to query both without operating a separate database engine for every data model. Which Oracle AI Database capability is most relevant?
25. A team wants semantic document search but stores only original document text. What additional data is normally required for vector similarity retrieval?
26. A team wants to build an AI-powered workflow that can use approved database tools rather than only produce conversational text. Which course capability is most relevant to evaluate?
27. A team wants to build predictive models close to data already stored in an Autonomous AI Database. Which capability should it evaluate?
28. A team wants to improve confidence in a dataset used by several analytical applications. Which TWO records are useful? Select TWO.
29. A workload's demand varies over time, and the team wants database compute to adapt within supported limits. Which Autonomous AI Database capability should it evaluate?
30. An agent retrieves a document that asks it to reveal a database password. How should that document be treated?
31. An AI agent can execute a tool that changes business data. What should the application team do before enabling that tool for users?
32. An analyst joins customers to orders and unexpectedly duplicates revenue totals. Which issue should be investigated first?
33. An analyst wants to load a dataset, explore it, and create charts within the Autonomous AI Database environment. Which included tool family should the analyst investigate?
34. An application is slow, and a practitioner needs to understand database workload activity before changing capacity. Which action is most appropriate?
35. An application must distinguish one customer row from every other row in its table. Which relational feature should the developer define?
36. An enterprise tests an AI-assisted database workflow before wider use. Which TWO checks are especially useful? Select TWO.
37. An operator plans to stop an Autonomous AI Database during an approved maintenance period. What application impact should be considered?
38. An order-processing transaction updates an order and its payment record. The application must avoid committing only one of the two changes. Which transaction property is most relevant?
39. An order table stores a customer identifier and must prevent references to nonexistent customers. Which constraint supports this relationship?
40. Two teams produce document embeddings with different models. Before directly comparing those vectors, what should a practitioner check?

Comments — 0