I85PREP
⌘ K
Oracle Autonomous Database Professional study materials
Oracle Autonomous Database Professional study resources

Oracle Autonomous Database Professional practice questions

One question at a time. Build your Oracle Autonomous Database Professional understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Autonomous Database Fundamentals

Which existing Oracle Cloud Infrastructure resource is selected to host an Autonomous Database instance when you create it on dedicated Exadata infrastructure?

  1. A bare metal GPU shape dedicated to analytics
  2. A Kubernetes node pool managed by the customer
  3. An Object Storage bucket used as the database home
  4. An Autonomous Container Database running on Exadata infrastructure Correct answer.

Explanation

On dedicated Exadata infrastructure, an Autonomous Database is created within a selected existing Autonomous Container Database. Creating the database does not itself create a new container; provisioning the container is a separate operation. The container hosts Autonomous Databases on the underlying Exadata infrastructure.

Question 2Autonomous Database Fundamentals

An Autonomous Database is configured with the workload type Transaction Processing. Which statement describes how this choice affects the database?

  1. It converts the database into a read-only replica for reporting
  2. It disables SQL tuning and automatic indexing to reduce overhead
  3. It optimizes the instance for high-concurrency short transactions and enables automatic indexing Correct answer.
  4. It forces all tables to be stored as columnar IMA format

Explanation

The workload type is set at creation and determines the default optimization profile. Transaction Processing favors many concurrent short transactions and includes automatic indexing, while decision support workloads tune for large scans and joins. The choice does not make the database read-only or change table storage formats directly.

Question 3Autonomous Database Fundamentals

Which capability is provided by the Autonomous Database serverless deployment model but not by a dedicated Exadata infrastructure deployment?

  1. A fixed allocation of Exadata compute for one customer
  2. Elastic scaling to zero compute when idle Correct answer.
  3. Isolation from other tenants on shared infrastructure
  4. Automatic patching of the database software

Explanation

Serverless Autonomous Database can automatically scale compute and can be configured to auto-scale to zero when idle, resuming on demand. Patching and isolation are handled differently, but dedicated infrastructure gives a customer exclusive Exadata resources rather than shared multi-tenant capacity.

Question 4Autonomous Database Fundamentals

What is the role of the ADMIN user in a newly provisioned Autonomous Database?

  1. It is a read-only account for monitoring and cannot create objects
  2. It is a temporary account deleted after the first connection
  3. It is the database administrator account that owns the schema and manages users and privileges Correct answer.
  4. It is a service account used only by Oracle Support for patching

Explanation

Every Autonomous Database includes an ADMIN account created at provisioning time. ADMIN holds database administrator privileges, can create schemas and users, and is used to grant access to application accounts. It is not read-only, temporary, or reserved for Oracle Support.

Question 5Autonomous Database Fundamentals

A developer needs to connect to an Autonomous Database from a SQL client on a laptop outside the cloud network. Which connection method is required by default?

  1. A connection that requires disabling the database's encryption
  2. A connection using a wallet containing the client credentials and connection strings Correct answer.
  3. A direct connection using the database's private IP address
  4. A connection through the DBMS_CLOUD package only

Explanation

By default Autonomous Database accepts only secure TCP connections, and clients use a downloaded client credentials wallet that contains the connection strings and certificates. Private endpoints or other network options can change reachability, but a wallet-based secure connection is the standard default for external clients.

Question 6Autonomous Database Fundamentals

Which statement about automatic backups of an Autonomous Database is accurate?

  1. Backups must be scheduled manually with DBMS_SCHEDULER
  2. Automatic backups are managed by the service and retained according to the configured retention policy Correct answer.
  3. Backups are only taken when the database is shut down
  4. Backups are stored in a customer-managed Object Storage bucket that the customer must create first

Explanation

Autonomous Database performs automatic backups as a managed service, and retention is governed by the backup retention setting the customer configures. Customers do not need to create buckets or schedule jobs for the default automatic backups.

Question 7Autonomous Database Fundamentals

An administrator wants to restore an Autonomous Database to a point in time within the retention window. Which mechanism supports this?

  1. Importing a Data Pump dump from Object Storage
  2. Point-in-time restore using the service console, OCI CLI, or API Correct answer.
  3. Running RMAN RESTORE DATABASE from a compute instance
  4. Cloning the database to a new instance and deleting the original

Explanation

Autonomous Database supports point-in-time restore to any timestamp within the backup retention period, initiated through the console, CLI, or API. Data Pump imports restore logical objects, not the whole database to a timestamp, and customers do not run RMAN directly against the service.

Question 8Autonomous Database Fundamentals

Which feature allows an Autonomous Database to automatically create indexes based on observed workload patterns?

  1. Automatic Storage Management
  2. Automatic indexing Correct answer.
  3. Automatic Workload Repository
  4. Automatic partitioning

Explanation

Automatic indexing monitors the workload, validates candidate indexes, and creates or drops indexes when they demonstrably improve performance. It is distinct from partitioning, storage management, and workload repository features.

Question 9Autonomous Database Fundamentals

A team wants to run analytic queries on an Autonomous Data Warehouse while it also serves concurrent reporting users. Which feature is designed to accelerate those queries without manual tuning?

  1. Manual creation of bitmap join indexes on every table
  2. Automatic In-Memory columnar population based on workload Correct answer.
  3. Disabling the query optimizer to force full table scans
  4. Setting the database to read-only mode

Explanation

Autonomous Database automatically populates the In-Memory column store based on workload and access patterns, accelerating analytic scans without manual intervention. Manual index creation, optimizer disabling, and read-only mode are not the designed acceleration path.

Question 10Autonomous Database Fundamentals

Which Oracle Cloud Infrastructure Identity and Access Management construct is used to grant a group of users permission to manage Autonomous Databases in a compartment?

  1. A VCN security list rule
  2. A policy with a statement granting manage autonomous-databases in the compartment Correct answer.
  3. A database user with the DBA role
  4. A wallet file distributed to each user

Explanation

Access to OCI resources is governed by IAM policies that grant verb and resource-type permissions to groups at a compartment scope. Database roles control in-database privileges, while security lists and wallets control network and connection security, not resource management permissions.

Question 11Autonomous Database Fundamentals

What does the auto-scaling setting on an Autonomous Database control?

  1. The retention period for automatic backups
  2. The ability to use up to three times the base OCPU count when demand increases Correct answer.
  3. The size of the client credentials wallet
  4. The number of read replicas created for reporting

Explanation

When auto-scaling is enabled, the database can temporarily use additional compute, up to three times the base OCPU count, to handle demand spikes and then scale back. It does not govern replicas, backup retention, or wallet contents.

Question 12Autonomous Database Fundamentals

An application must read data from files stored in an OCI Object Storage bucket without loading them into database tables. Which Autonomous Database capability is appropriate?

  1. A database link to the Object Storage service
  2. A materialized view refresh on a schedule
  3. A local tablespace pointing at the bucket
  4. External tables defined with DBMS_CLOUD Correct answer.

Explanation

DBMS_CLOUD lets you query Object Storage files directly through external tables, so data can be read without being loaded into the database. Database links connect to other databases, and tablespaces cannot point at object storage buckets.

Question 13Autonomous Database Fundamentals

Which statement about scaling an Autonomous Database's compute resources is correct?

  1. Compute scaling requires exporting and reimporting the database
  2. Compute can be scaled up or down online without downtime in most cases Correct answer.
  3. Compute is fixed at creation and cannot be changed
  4. Compute can only be increased, never decreased

Explanation

Autonomous Database supports online scaling of OCPUs, both up and down, and the change is applied without taking the database offline in typical cases. It is not a fixed-at-creation attribute and does not require export and import.

Question 14Autonomous Database Fundamentals

A customer needs network traffic to the Autonomous Database to stay within their virtual cloud network and never traverse the public internet. Which configuration meets this requirement?

  1. A private endpoint in the customer's VCN subnet Correct answer.
  2. A public endpoint with an access control list restricted to the customer's IP range
  3. Enabling auto-scaling on the database
  4. A wallet with a longer password

Explanation

A private endpoint places the database on a subnet in the customer's VCN so traffic stays on the private network. A public endpoint with an ACL still uses a public-facing path, and neither wallets nor auto-scaling change network routing.

Question 15Autonomous Database Fundamentals

Which tool is provided specifically for loading data into an Autonomous Database from files in Object Storage or from a local file?

  1. Oracle GoldenGate Studio
  2. Oracle Data Pump expdp only
  3. SQL*Plus COPY command only
  4. The Data Studio Load Data wizard or DBMS_CLOUD procedures Correct answer.

Explanation

Autonomous Database provides Data Studio, including a Load Data wizard, and PL/SQL procedures in DBMS_CLOUD for loading files from Object Storage or local sources. Data Pump export is for unloading, and GoldenGate is for replication.

Question 16Autonomous Database Fundamentals

What is the purpose of a refreshable clone of an Autonomous Database?

  1. To provide a read-only copy that periodically refreshes from the source database Correct answer.
  2. To store automatic backups in a second region
  3. To host the client credentials wallet
  4. To replace the source database after a failover

Explanation

A refreshable clone is a copy that can be refreshed on demand or on a schedule from its source, making it useful for reporting or testing against current data. It does not replace the source, store backups, or host wallets.

Question 17Autonomous Database Fundamentals

Which statement describes the maintenance model for Autonomous Database software?

  1. Patching is optional and disabled by default
  2. Customers apply quarterly patch bundles manually during a maintenance window they choose
  3. Oracle applies patches automatically, with customers able to influence the maintenance schedule Correct answer.
  4. Patching requires a full database export and import

Explanation

Autonomous Database is a managed service, so Oracle applies patches automatically. Customers can configure the maintenance schedule to control when patching occurs but do not apply patches manually.

Question 18Autonomous Database Fundamentals

An analyst wants to use a notebook-style interface to query and visualize data inside Autonomous Database. Which built-in tool serves this purpose?

  1. Oracle Enterprise Manager Cloud Control
  2. Oracle Machine Learning Notebooks Correct answer.
  3. Oracle Recovery Manager
  4. Oracle SQL Developer Data Modeler

Explanation

Oracle Machine Learning Notebooks is the built-in notebook interface for querying and analyzing data in Autonomous Database and visualizing results. The other options serve management, modeling, or backup and recovery purposes rather than notebook analysis.

Question 19Autonomous Database Fundamentals

A customer wants the Autonomous Database to be isolated on dedicated Exadata hardware for regulatory reasons. Which deployment option should they choose?

  1. Dedicated Exadata infrastructure Correct answer.
  2. A public endpoint with an ACL
  3. A refreshable clone
  4. Serverless with auto-scaling enabled

Explanation

Dedicated deployment provisions the Autonomous Database on Exadata infrastructure reserved for that customer, providing hardware isolation. Serverless is multi-tenant, and endpoints, ACLs, and clones do not change the underlying infrastructure tenancy.

Question 20Autonomous Database Fundamentals

Which privilege-related statement is true for application schemas in Autonomous Database?

  1. Application users automatically receive DBA privileges
  2. Application users must be granted privileges by ADMIN or a delegated administrator Correct answer.
  3. Application schemas cannot be created by anyone
  4. Privileges are managed only through IAM policies

Explanation

ADMIN or another authorized administrator creates application schemas and grants the needed privileges. Application users do not receive DBA by default, schemas can be created, and IAM policies govern OCI resources rather than in-database object privileges.

Question 21Autonomous Database Fundamentals

A workload runs heavy batch reports at night and light transactional traffic during the day. Which combination best uses Autonomous Database features to control cost while meeting demand?

  1. Disabling automatic backups to free compute
  2. A read-only clone used for all writes
  3. A fixed high OCPU count with auto-scaling disabled
  4. A base OCPU count with auto-scaling enabled and a maintenance schedule set for off-peak hours Correct answer.

Explanation

Auto-scaling lets the database use extra compute during demand spikes and return to the base count afterward, while scheduling maintenance off-peak avoids disruption. A fixed high count wastes capacity, and disabling backups or writing to a read-only clone is not viable.

Question 22Autonomous Database Fundamentals

Which statement about the Autonomous Database service console is accurate?

  1. It replaces SQL for all data manipulation
  2. It provides monitoring, scaling, backup, and clone operations for the database Correct answer.
  3. It is available only from a compute instance inside the VCN
  4. It stores the database files on the client machine

Explanation

The service console in the OCI Console exposes operational tasks such as monitoring, scaling, backup and restore, and cloning. It is a browser-based management interface and does not replace SQL or store database files locally.

Question 23Autonomous Database Fundamentals

A team observes that a query plan changed and performance degraded after a deployment. Which Autonomous Database feature helps identify and address plan regressions automatically?

  1. Dropping all indexes
  2. Automatic SQL plan management Correct answer.
  3. Disabling the optimizer
  4. Manual hint injection into every query

Explanation

Automatic SQL plan management captures and evaluates execution plans, preventing regressions by using verified plans. Hint injection, disabling the optimizer, and dropping indexes are manual and often harmful interventions.

Question 24Autonomous Database Fundamentals

Which statement about the relationship between an Autonomous Database and its Autonomous Container Database is correct?

  1. An Autonomous Database can exist without any container database
  2. An Autonomous Container Database is a client-side wallet
  3. An Autonomous Database is stored in Object Storage only
  4. Each Autonomous Database runs inside an Autonomous Container Database on Exadata infrastructure Correct answer.

Explanation

An Autonomous Database is created within an Autonomous Container Database, which runs on Exadata infrastructure and provides the underlying resources. It cannot exist without a container database, and wallets and Object Storage are unrelated to this hierarchy.

Question 25Autonomous Database Fundamentals

A company needs a copy of production data for testing with minimal impact on the production database. Which approach is most appropriate in Autonomous Database?

  1. Run all tests directly against production
  2. Create a clone of the production database Correct answer.
  3. Export the production database and import it into a new database during peak hours
  4. Copy the wallet to the test team

Explanation

Cloning creates a separate database from the source, allowing testing without affecting production. Export and import during peak hours is disruptive, testing against production is unsafe, and copying a wallet does not create a test environment.

Question 26Autonomous Database Fundamentals

Which database engine underlies every Autonomous Database, regardless of whether it is deployed as Autonomous Data Warehouse or Autonomous Transaction Processing?

  1. Oracle NoSQL Database
  2. PostgreSQL
  3. MySQL HeatWave
  4. Oracle Database Correct answer.

Explanation

Autonomous Database is a fully managed Oracle Database service; the workload shape (warehouse or transaction processing) changes configuration and defaults, not the engine. MySQL HeatWave, PostgreSQL, and NoSQL are separate Oracle cloud services with different engines and interfaces.

Question 27Autonomous Database Fundamentals

An Autonomous Database is created without specifying a compartment other than the default. Which statement describes how OCI compartment placement affects the resource?

  1. The database is governed by the compartment it was created in, and access policies scoped to that compartment apply to it Correct answer.
  2. The database is automatically placed in the root compartment regardless of the request
  3. Compartment assignment is irrelevant because Autonomous Database ignores IAM policies
  4. The database inherits compartment membership from the VCN subnet it uses

Explanation

Compartments are the fundamental OCI grouping for resources and the scope at which IAM policies grant access. An Autonomous Database lives in the compartment chosen at creation, and policy statements written against that compartment (or its parent) determine who can manage it.

Question 28Autonomous Database Fundamentals

Which workload type should be selected when creating an Autonomous Database intended primarily for mixed ad hoc queries over large columnar datasets and dimensional models?

  1. Autonomous Data Warehouse Correct answer.
  2. Autonomous APEX Application Development
  3. Autonomous Transaction Processing
  4. Autonomous JSON Database

Explanation

Autonomous Data Warehouse is tuned for analytic workloads such as star-schema queries and large scans, with columnar and parallel execution defaults. Transaction Processing targets OLTP concurrency, while JSON and APEX service types target document-centric and low-code application use cases respectively.

Question 29Autonomous Database Fundamentals

What does the term 'serverless' mean when applied to the default Autonomous Database offering?

  1. No database server processes exist because queries execute inside the client driver
  2. Oracle provisions and manages the underlying Exadata infrastructure, and the customer does not choose or patch database servers Correct answer.
  3. The database is limited to a single dedicated Exadata machine per tenancy
  4. The database runs on customer-provided compute instances that Oracle only monitors

Explanation

In the serverless model Oracle owns capacity planning, provisioning, patching, and infrastructure availability, and the customer interacts only with the database service. The customer never selects, patches, or connects to database hosts.

Question 30Autonomous Database Fundamentals

Which statement best describes the role of the ADMIN user in a newly provisioned Autonomous Database?

  1. ADMIN is a read-only monitoring account that cannot create users
  2. ADMIN is an operating-system login on the Exadata host
  3. ADMIN is an OCI IAM user that replaces database authentication entirely
  4. ADMIN is the initial database administrator account used to create schemas and grant privileges, and its password is set at provisioning Correct answer.

Explanation

The ADMIN database user is created with the instance and is used to create application schemas, grant privileges, and perform administrative SQL. Its password is supplied during provisioning and can be reset later by an authorized OCI user.

Question 31Autonomous Database Fundamentals

Which connection method lets a SQL client reach an Autonomous Database over the public internet with TLS while requiring no VPN or bastion host?

  1. A TLS listener endpoint using a wallet or TLS-only connection string Correct answer.
  2. A database link from an on-premises database using unencrypted Net8
  3. An SSH tunnel to the Exadata storage cell
  4. A direct SQL*Net connection to the database host IP on port 1521 without encryption

Explanation

Public endpoints on Autonomous Database accept TLS-protected connections, and clients typically use a downloaded wallet or a TLS-only connection string. Plain unencrypted SQL*Net and host-level access are not available because customers do not control the hosts.

Question 32Autonomous Database Fundamentals

Which Oracle client credential container is commonly downloaded from the service console to enable mutual TLS connections to an Autonomous Database?

  1. An OCI API signing key
  2. A client credentials wallet (zip) containing certificates and connection descriptors Correct answer.
  3. A Kerberos keytab file
  4. An SSH private key pair

Explanation

The wallet bundles the trusted certificates and tnsnames entries needed for mTLS connections to the database. Kerberos keytabs, SSH keys, and OCI API signing keys serve unrelated authentication purposes.

Question 33Autonomous Database Fundamentals

Which statement about the availability of an Autonomous Database across availability domains is accurate for the serverless offering?

  1. Cross-region replication is mandatory at provisioning time
  2. The customer must create a standby database in a second availability domain for any protection
  3. The database runs in exactly one availability domain with no Oracle-managed failover
  4. Oracle manages resilience on shared Exadata infrastructure, and the customer does not configure Data Guard standby databases manually Correct answer.

Explanation

With serverless Autonomous Database, Oracle handles infrastructure fault tolerance, and customers are not required to build and manage Data Guard configurations themselves. Optional features such as cross-region standby exist for additional disaster protection but are not mandatory.

Question 34Autonomous Database Fundamentals

A developer wants an application schema to be isolated from other schemas and to own its objects. Which action should the ADMIN user take in Autonomous Database?

  1. Use the ADMIN schema directly for all application objects
  2. Ask OCI IAM to create a database schema through a policy statement
  3. Create a new database user with the required quota and grant it the privileges the application needs Correct answer.
  4. Grant the application the SYSDBA privilege so it can create its own schema

Explanation

Application isolation is achieved by creating a dedicated database user that owns its objects and receives only the privileges it needs. SYSDBA is not available to application users, IAM policies do not create schemas, and sharing ADMIN violates least privilege.

Question 35Autonomous Database Fundamentals

A team must prevent any network path to its Autonomous Database except from a specific private subnet. Which configuration accomplishes this?

  1. Create a database link from the application subnet
  2. Configure a private endpoint and restrict ingress with network security groups or security lists Correct answer.
  3. Disable TLS on the listener so only known IPs can connect
  4. Use a public endpoint and rely on the database password alone

Explanation

A private endpoint places the database's listener inside a customer subnet, and NSGs or security lists then control which sources may reach it. Public endpoints are reachable from the internet subject to ACLs, and passwords alone do not restrict network origin.

Question 36Autonomous Database Fundamentals

A data engineer wants to query objects in an OCI Object Storage bucket directly from SQL without copying the files into tables. Which capability should be used?

  1. A materialized view refreshed by a scheduled job that downloads files
  2. A database link to the Object Storage service
  3. An RMAN backup of the bucket
  4. External tables over the Object Storage bucket, queried with SQL Correct answer.

Explanation

Autonomous Database supports external tables whose data resides in Object Storage, letting SQL read the files in place. Database links target other databases, RMAN does not read buckets, and scheduled downloads are a copy-based workaround rather than direct query.

Question 37Autonomous Database Fundamentals

Which built-in Autonomous Database capability helps identify SQL statements that consume the most database time and offers tuning advice?

  1. Autonomous Database performance hub with SQL tuning insights Correct answer.
  2. The OCI Audit log for the tenancy
  3. The VCN flow log dashboard
  4. The Object Storage lifecycle policy report

Explanation

Performance Hub surfaces active session history, SQL monitoring, and tuning recommendations for expensive statements. Audit logs, lifecycle policies, and flow logs concern governance, storage, and network traffic rather than SQL performance.

Question 38Autonomous Database Fundamentals

An application connects with a medium service name in its connection string. What does the service name primarily determine?

  1. The geographic region where the database is hosted
  2. The IAM policy that authorizes the connection
  3. The backup retention period for the database
  4. The resource consumer group and parallelism profile applied to the session Correct answer.

Explanation

Service names such as low, medium, and high map sessions to consumer groups with different parallelism and resource limits. They do not change region, backup policy, or authorization, which are configured elsewhere.

Question 39Autonomous Database Fundamentals

A team wants to run a workload that needs session-level settings and package state preserved across many calls. Which connection approach is most appropriate?

  1. Disabling session reuse in the client driver
  2. Opening a brand-new connection for every individual call
  3. A connection pool that keeps sessions alive and reuses them Correct answer.
  4. Using only stateless REST calls for every operation

Explanation

Session state such as package variables, temporary tables, and session settings persists only while the session lives, so pooling preserves it across calls. Creating a connection per call discards state, and stateless REST calls cannot hold session state at all.

Question 40Autonomous Database Fundamentals

Which statement describes how Autonomous Database handles patching of the database software?

  1. Oracle applies patches automatically during maintenance windows that the customer can influence Correct answer.
  2. Patching is disabled by default and must be enabled per schema
  3. The customer must download and apply quarterly patch bundles manually
  4. Patches are applied only when the customer opens a support ticket

Explanation

Autonomous Database is a managed service in which Oracle schedules and applies software maintenance, while customers can configure maintenance scheduling preferences. Manual patch application and ticket-driven patching are not part of the model.

Question 41Autonomous Database Fundamentals

A reporting schema needs read access to tables owned by a sales schema. Which approach follows Autonomous Database privilege best practice?

  1. Grant the DBA role to the reporting user
  2. Share the sales schema password with the reporting team
  3. Grant SELECT on the specific sales tables to the reporting user Correct answer.
  4. Grant SELECT ANY TABLE to PUBLIC

Explanation

Least privilege means granting only the object privileges needed, so SELECT on the specific tables is appropriate. Broad roles, PUBLIC grants, and credential sharing all expand access far beyond the requirement.

Question 42Autonomous Database Fundamentals

What is the effect of setting a tablespace quota for an application user in Autonomous Database?

  1. It caps how much space that user's segments may consume in the tablespace Correct answer.
  2. It limits the number of concurrent sessions the user may open
  3. It determines the database's backup retention window
  4. It restricts the user to read-only queries

Explanation

A quota on a tablespace limits the storage that a user's objects can occupy there and causes space errors once exceeded. It has no bearing on session counts, read-only status, or backup retention.

Question 43Autonomous Database Fundamentals

A team needs a fully isolated Autonomous Database on dedicated Exadata infrastructure for compliance reasons. Which deployment choice satisfies this?

  1. Autonomous Database serverless
  2. Autonomous Database on dedicated infrastructure Correct answer.
  3. An Exadata Cloud@Customer quarter rack shared with other tenants
  4. A base database system on a virtual machine

Explanation

Dedicated infrastructure gives a tenancy its own Exadata resources for Autonomous Database, which supports isolation requirements. Serverless shares Oracle-managed infrastructure, a base database system is not Autonomous Database, and a shared rack does not provide exclusive use.

Question 44Autonomous Database Fundamentals

A workload's query plans regressed after a schema change. Which Autonomous Database capability should be examined first to compare plan history and performance?

  1. The Object Storage bucket inventory
  2. The VCN route table
  3. SQL Performance Analyzer and plan history in the performance tooling Correct answer.
  4. The tenancy's budget alerts

Explanation

Autonomous Database includes SQL tuning tools that track plan changes and let you compare execution performance before and after a change. Bucket inventories, route tables, and budget alerts are unrelated to SQL plan regression.

Question 45Autonomous Database Fundamentals

An application must continue serving reads if the primary region becomes unavailable. Which Autonomous Database feature addresses this requirement?

  1. A local backup retained for sixty days
  2. An external table pointing at a remote bucket
  3. A cross-region Autonomous Data Guard standby with a read-only role Correct answer.
  4. A refreshable clone in the same region

Explanation

Autonomous Data Guard provides a standby in another region that can take over, and the standby can serve read-only workloads. A same-region clone, a backup, and an external table do not provide cross-region read availability.

Question 46Autonomous Database Fundamentals

A team wants to ensure that only members of a specific OCI group can start or stop an Autonomous Database while other groups may only view it. Which mechanism enforces this?

  1. Database roles granted to each OCI user's schema
  2. TLS certificates issued per group
  3. IAM policies that grant manage or read verbs on the database resource to the respective groups Correct answer.
  4. Network security groups attached to the private endpoint

Explanation

OCI IAM policies map groups to verbs such as manage, use, and read on resource types and compartments, which is how control-plane actions like start and stop are authorized. Database roles, NSGs, and certificates govern different layers.

Question 47Autonomous Database Fundamentals

An analyst needs to join an external table over Object Storage with a local dimension table and then persist the result for repeated reporting. Which approach is most efficient?

  1. Copy the bucket into a new bucket and query it as an external table
  2. Query the external table and local table together every time the report runs
  3. Create a table or materialized view from the join so repeated queries read local storage Correct answer.
  4. Use a database link to the bucket and join remotely

Explanation

Persisting the joined result as a table or materialized view avoids repeatedly scanning and parsing external files. Re-running the external join each time, duplicating the bucket, or linking to storage adds cost without persistence.

Question 48Autonomous Database Fundamentals

A workload spikes unpredictably, and the team wants compute to grow automatically within a configured base without manual resizing. Which setting should be enabled?

  1. Auto-scaling on the database's base OCPU count Correct answer.
  2. A private endpoint with a larger subnet
  3. A larger fixed OCPU count with no auto-scaling
  4. A refreshable clone sized for peak load

Explanation

Auto-scaling allows the service to use additional compute beyond the base OCPU count when demand rises, then return to base. A larger fixed size overprovisions, and clones or subnets do not add compute elasticity.

Question 49Autonomous Database Fundamentals

A customer must guarantee that data at rest is encrypted with keys they control and can revoke. Which configuration meets this requirement in Autonomous Database?

  1. Encrypt individual columns with a password stored in application code
  2. Rely on Oracle-managed keys with no customer involvement
  3. Enable TLS on the client connection string
  4. Use customer-managed keys stored in an OCI Vault for the database's encryption Correct answer.

Explanation

Customer-managed keys in OCI Vault let the customer control and revoke the key protecting data at rest. Oracle-managed keys do not give that control, application-level column encryption is a separate measure, and TLS protects data in transit only.

Question 50Autonomous Database Fundamentals

An Autonomous Database is configured with auto scaling enabled and a base of 4 ECPUs. During a monthly close, the workload briefly demands more CPU than the base provides. Which statement describes what auto scaling does in this situation?

  1. It allows compute to burst up to three times the base ECPU count when the workload requires it, without changing the base. Correct answer.
  2. It queues statements until CPU demand falls back below the base, guaranteeing that the base is never exceeded.
  3. It adds a read-only standby in a second region so that reporting queries are redirected away from the primary.
  4. It permanently doubles the base ECPU count once the burst threshold is exceeded, and the new base persists until changed manually.

Explanation

Auto scaling lets an Autonomous Database use additional compute beyond its configured base ECPU count when demand rises, and the extra capacity is released when demand drops. The base value is what is billed and what remains configured; bursting is temporary and does not rewrite the base setting.