Autonomous Database Exam |
Verified Questions and Answers |
Updated Practice Test 2025/2026
1. Which statement is FALSE about loading data into
the Autonomous Database using the Data Load card
in Database Actions?
A. Data can be loaded from a local data source
B. Data can be loaded from a remote database using
Database Links (DBLinks)
C. Data can be uploaded from several cloud storage
sources including 53, Azure, Google Cloud and
Oracle Object Storage
D. You must first manually create your database
credentials using dms_cloud.create_credentia
before accessing your Oracle Object Storage Bucket
E. Data formats supported include: text, csv, json,
avro and parquet
2.Data Guard is enabled for your Autonomous
Database and the Lifecycle State field for the
primary database indicates that it is stopped.
Which statement is true?
A. The standby database is terminated.
B. Switchover is automatically initiated.
,C. Failover is automatically initiated.
D. The standby database is also stopped.
3. You need to create a new database via the Oracle
Cloud Infrastructure (OCI) CLI with the following
requirements:
* Autonomous Transaction Processing
* License Included
* Shared Infrastructure
Which parameter would you NOT use?
A. db-workload
B. is-dedicated
C. db-type
D. license-model
4. While creating an Autonomous Container
Database on dedicated infrastructure through the
Oracle Cloud Infrastructure (OCI) console, which
patch type is offered to be applied during
maintenance?
A. Release Update (RU)
B. Prior Release Update Revision (PRUR)
C. Prior Release Update (PRU)
,D. Quarterly Bundle Patch (QBP)
5. Which TWO statements are TRUE about using an
Autonomous Database with Private Endpoints
A. A Network Security Group is required within your
Virtual Cloud Network before you can provision a
Shared Autonomous Database to use Private
Endpoints
B. An Autonomous Database with private endpoints
can be accessed from the public internet by adding
your ip address to an Access Control List.
C. Private Endpoints can be configured when you
clone a Shared Autonomous Database that was
initially created with public endpoints.
D. You can configure Private Endpoints for an
Always Free Autonomous Database
6. While Autonomous Transaction Processing and
Autonomous Data Warehouse use the same Oracle
database, which statement is true about the
workloads?
A. Autonomous Transaction Processing memory
usage optimizes workloads for parallel joins and
aggregations.
, B. Autonomous Data Warehouse workloads are
optimized for mixed workloads.
C. Autonomous Transaction Processing workloads
are optimized for data warehouse, data mart, and
data lake.
D. Data that is bulk loaded, by default, uses the row
format in Autonomous Transaction Processing
where Autonomous Data Warehouse data format is
columnar.
7. Which two actions can be performed when an
Autonomous Database is stopped?
A. Change Administrator Password
B. Update License Type
C. Start
D. Update Network Access
8. Which two methods can you use to create users
and grant roles in Autonomous Database services?
(Choose two.)
A. through the Oracle Cloud Infrastructure service
console
B. through SQL/Developer s
Verified Questions and Answers |
Updated Practice Test 2025/2026
1. Which statement is FALSE about loading data into
the Autonomous Database using the Data Load card
in Database Actions?
A. Data can be loaded from a local data source
B. Data can be loaded from a remote database using
Database Links (DBLinks)
C. Data can be uploaded from several cloud storage
sources including 53, Azure, Google Cloud and
Oracle Object Storage
D. You must first manually create your database
credentials using dms_cloud.create_credentia
before accessing your Oracle Object Storage Bucket
E. Data formats supported include: text, csv, json,
avro and parquet
2.Data Guard is enabled for your Autonomous
Database and the Lifecycle State field for the
primary database indicates that it is stopped.
Which statement is true?
A. The standby database is terminated.
B. Switchover is automatically initiated.
,C. Failover is automatically initiated.
D. The standby database is also stopped.
3. You need to create a new database via the Oracle
Cloud Infrastructure (OCI) CLI with the following
requirements:
* Autonomous Transaction Processing
* License Included
* Shared Infrastructure
Which parameter would you NOT use?
A. db-workload
B. is-dedicated
C. db-type
D. license-model
4. While creating an Autonomous Container
Database on dedicated infrastructure through the
Oracle Cloud Infrastructure (OCI) console, which
patch type is offered to be applied during
maintenance?
A. Release Update (RU)
B. Prior Release Update Revision (PRUR)
C. Prior Release Update (PRU)
,D. Quarterly Bundle Patch (QBP)
5. Which TWO statements are TRUE about using an
Autonomous Database with Private Endpoints
A. A Network Security Group is required within your
Virtual Cloud Network before you can provision a
Shared Autonomous Database to use Private
Endpoints
B. An Autonomous Database with private endpoints
can be accessed from the public internet by adding
your ip address to an Access Control List.
C. Private Endpoints can be configured when you
clone a Shared Autonomous Database that was
initially created with public endpoints.
D. You can configure Private Endpoints for an
Always Free Autonomous Database
6. While Autonomous Transaction Processing and
Autonomous Data Warehouse use the same Oracle
database, which statement is true about the
workloads?
A. Autonomous Transaction Processing memory
usage optimizes workloads for parallel joins and
aggregations.
, B. Autonomous Data Warehouse workloads are
optimized for mixed workloads.
C. Autonomous Transaction Processing workloads
are optimized for data warehouse, data mart, and
data lake.
D. Data that is bulk loaded, by default, uses the row
format in Autonomous Transaction Processing
where Autonomous Data Warehouse data format is
columnar.
7. Which two actions can be performed when an
Autonomous Database is stopped?
A. Change Administrator Password
B. Update License Type
C. Start
D. Update Network Access
8. Which two methods can you use to create users
and grant roles in Autonomous Database services?
(Choose two.)
A. through the Oracle Cloud Infrastructure service
console
B. through SQL/Developer s
