A database administrator is working with a JSON collection in Oracle Database 23ai. They need to enforce that every document in the collection contains a field 'employeeId' and that its value is unique across all documents. Which approach should be used?
You are designing a new application on Oracle Database 23ai that will use AI Vector Search. The application needs to store vector embeddings for product descriptions and perform similarity searches. Which two statements are true about the VECTOR data type and vector indexes in 23ai? (Choose two.)
You are the lead DBA for a SaaS platform on Oracle Database 23ai. Your development team frequently performs DDL changes on large production tables. They complain that DDL operations block active transactions and cause timeouts. You need to enable a feature that allows concurrent DML during certain DDL operations without requiring a maintenance window. Which 23ai feature should you implement?
A database administrator is configuring True Cache for a read-mostly application. The application connects directly to the True Cache instance. Which initialization parameter must be set on the True Cache instance to specify the primary database it will cache?
A financial services company runs an Oracle 23ai database that processes high-volume transactions. They need to enforce strict data integrity for a new application that requires immutable audit trails. The compliance team mandates that no user, including DBAs, can modify or delete rows once inserted. Which 23ai feature should be implemented to meet this requirement?
You are working with Oracle Database 23ai and need to manage schema-level privileges for a new application. The application requires that users can create tables and also grant those privileges to other users. Which two statements are true about schema-level privileges in 23ai? (Choose two.)
A database administrator is evaluating the use of True Cache in Oracle Database 23ai to offload read-only queries from the primary database. Which two statements about True Cache are correct? (Choose two.)
You are a DBA for an e-commerce application on Oracle Database 23ai. The application experiences high concurrency on an inventory table, where multiple sessions frequently update the same rows, causing lock contention. You decide to implement Lock-Free Reservations. Which two statements are true about this feature? (Choose two.)
An Oracle Database 23ai administrator supports an application that frequently runs ad hoc queries against a large JSON collection stored in an Oracle JSON column. Developers complain that every query must be rewritten to match the document structure, and they want the relational and JSON views of the same data to stay in sync without duplicating storage. The DBA enables JSON Relational Duality Views. Which statement correctly describes how the application benefits from this feature?
A financial services company runs an Oracle Database 23ai application that performs high-volume, concurrent inserts into a transaction history table. The DBA observes significant buffer busy waits and wants to reduce contention without changing the application. Which 23ai feature should be implemented?
Your team maintains a large Oracle Database 23ai data warehouse. A new reporting application requires the ability to store and query JSON documents alongside relational data without duplicating the data or writing complex transformation logic. The application will issue both standard SQL queries and Oracle Database API for MongoDB (Oracle API for MongoDB) commands against the same underlying data. Which 23ai feature should you implement to satisfy this requirement?
A retail company uses Oracle Database 23ai and wants to enable real-time analytics on a high-volume OLTP table without impacting transaction performance. They decide to use the True Cache feature. Which statement correctly describes how True Cache achieves this?
Your Oracle Database 23ai instance is running on an Exadata platform. You have a large table with a column of type VECTOR storing 768-dimensional embeddings. Users frequently run similarity searches using the VECTOR_DISTANCE function with the COSINE metric. To improve query performance, you create a vector index. After creation, you notice that some queries do not use the index and perform full table scans. What is the most likely reason for this behavior?
A DBA is using Oracle Database 23ai and wants to implement a schema-level privilege analysis to monitor privileges used by applications. Which two statements are true about this feature? (Choose two.)
You are designing a blockchain table in Oracle 23ai for an audit trail. You must ensure that the table provides tamper-evident storage and that users can verify the integrity of rows. Which two actions are required to set up and use a blockchain table correctly? (Choose two.)
Your Oracle Database 23ai instance uses True Cache to offload read-only queries from the primary database. A developer reports that a query against a table modified by another session returns stale data from True Cache. You need to ensure that the True Cache returns the most recent committed data for that query. Which action should you take?
You are managing a high-concurrency OLTP system on Oracle Database 23ai. Multiple sessions frequently update a single row in an inventory table, causing contention and lock waits. You want to eliminate this contention without changing the application logic. Which 23ai feature should you implement?
Your company is adopting Oracle Database 23ai and wants to store vector embeddings for an AI application. You need to create a table to store 128-dimensional vectors and perform similarity searches. Which data type should you use for the vector column?
A developer is creating a table with a lock-free reservation column to handle high-concurrency updates. The column is defined as NUMBER(5,0). After many transactions, the value reaches its maximum. What happens when a transaction attempts to reserve beyond the maximum?
A database administrator is enabling True Cache for a primary database. The application will connect to the True Cache instance for read-only queries. Which statement about the default behavior of a session connected to True Cache is correct?
A database administrator is creating a table to support high-concurrency transactions using lock-free reservations. Which clause must be included in the CREATE TABLE statement to enable lock-free reservations on a numeric column?
You are evaluating Oracle Database 23ai for a new application that requires storing and querying vector embeddings for a recommendation engine. The application will perform similarity searches on millions of vectors. Which 23ai feature should you use to efficiently store and query these vectors?
A telecommunications company is migrating a critical billing application to Oracle Database 23ai. The application performs complex analytical queries on a large partitioned table. The DBA wants to ensure that SQL execution plans remain stable after the migration and that any plan changes are automatically validated to prevent performance regressions. Which 23ai feature should be configured?