1
ADB
Oracle ADB Certification Review |
Exam | Questions & Answers | Grade
A| 100% Correct | (NEW 2025/
2026)
Which THREE predefined database service names are available in an Autonomous Data
Warehouse?
- tp
- high
- medium
- low
- tpurgent - ANS ✓- high
- medium
- low
In which TWO situations can Data Pump be used to migrate to an Autonomous
Database?
- cross endian platforms
- source database 10g and later
- when source is a flat file
- when moving a relatively small amount of data - ANS ✓- cross endian platforms
- source Database 10g and later
ADB
, 2
ADB
When you are increasing the number of OCPUs in your Autonomous Database, what
does its status show?
UPSCALE IN PROGRESS
RESIZING IN PROGRESS
SCALING IN PROGRESS
UPLIFT IN PROGRESS - ANS ✓SCALING IN PROGRESS
Which TWO Oracle Cloud Infrastructure console tools can be used to monitor the
performance of an autonomous database service instance?
- SQL Developer
- Performance Hub
- OCI Metrics
- APEX - ANS ✓- Performance Hub
- OCI Metrics
Which TWO infrastructure support deployment of Oracle Autonomous Database?
- Dedicated Exadata Infrastructure
- Oracle Bare Metal Servers
- Shared Exadata Infrastructure
- Virtual Machines on OCI - ANS ✓- Dedicated Exadata
- Shared Exadata
Which TWO statements are TRUE about Auto Scaling?
- Enabling auto scaling also increases the concurrency and parallelism settings for the
predefined services.
- If you are provisioning an always-free database, auto scaling is not available.
ADB
, 3
ADB
- It can be enabled when provisioning an ADB instance or anytime using the Oracle
Cloud Infrastructure console.
- Scaling up automatically expands CPU but not IO resources. - ANS ✓- If you are
provisioning an always-free database, auto scaling is not available.
- It can be enabled when provisioning an ADB instance or anytime using the OCI console.
Which is the recommended data loading tool to migrate data from third-party
databases?
- Oracle Data Pump
- SQL Developer Data Import Wizard
- SQL Developer Migration Workbench
- SQL Loader - ANS ✓SQL Developer Migration Workbench
Which TWO statements are TRUE about an Oracle Autonomous Transaction Processing
database?
- It stores data in Row Format
- It is best suited for Analytics workload
- memory configuration, data formats, indexes, and access structures are automatically
optimized to optimize response time
- Use data summaries such as storage indexes on the Exadata storage cells to quickly
answer the data that is needed in the query - ANS ✓- It stores data in Row Format
- memory configuration, data formats, indexes, and access structures are automatically
optimized to optimize response time
You want to enable automatic indexing in a database, but any new auto indexes should
be created as invisible indexes, so that they cannot be used in SQL statements. Which
command will you use?
- EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','INVISIBLE');
- EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','OFF');
ADB
ADB
Oracle ADB Certification Review |
Exam | Questions & Answers | Grade
A| 100% Correct | (NEW 2025/
2026)
Which THREE predefined database service names are available in an Autonomous Data
Warehouse?
- tp
- high
- medium
- low
- tpurgent - ANS ✓- high
- medium
- low
In which TWO situations can Data Pump be used to migrate to an Autonomous
Database?
- cross endian platforms
- source database 10g and later
- when source is a flat file
- when moving a relatively small amount of data - ANS ✓- cross endian platforms
- source Database 10g and later
ADB
, 2
ADB
When you are increasing the number of OCPUs in your Autonomous Database, what
does its status show?
UPSCALE IN PROGRESS
RESIZING IN PROGRESS
SCALING IN PROGRESS
UPLIFT IN PROGRESS - ANS ✓SCALING IN PROGRESS
Which TWO Oracle Cloud Infrastructure console tools can be used to monitor the
performance of an autonomous database service instance?
- SQL Developer
- Performance Hub
- OCI Metrics
- APEX - ANS ✓- Performance Hub
- OCI Metrics
Which TWO infrastructure support deployment of Oracle Autonomous Database?
- Dedicated Exadata Infrastructure
- Oracle Bare Metal Servers
- Shared Exadata Infrastructure
- Virtual Machines on OCI - ANS ✓- Dedicated Exadata
- Shared Exadata
Which TWO statements are TRUE about Auto Scaling?
- Enabling auto scaling also increases the concurrency and parallelism settings for the
predefined services.
- If you are provisioning an always-free database, auto scaling is not available.
ADB
, 3
ADB
- It can be enabled when provisioning an ADB instance or anytime using the Oracle
Cloud Infrastructure console.
- Scaling up automatically expands CPU but not IO resources. - ANS ✓- If you are
provisioning an always-free database, auto scaling is not available.
- It can be enabled when provisioning an ADB instance or anytime using the OCI console.
Which is the recommended data loading tool to migrate data from third-party
databases?
- Oracle Data Pump
- SQL Developer Data Import Wizard
- SQL Developer Migration Workbench
- SQL Loader - ANS ✓SQL Developer Migration Workbench
Which TWO statements are TRUE about an Oracle Autonomous Transaction Processing
database?
- It stores data in Row Format
- It is best suited for Analytics workload
- memory configuration, data formats, indexes, and access structures are automatically
optimized to optimize response time
- Use data summaries such as storage indexes on the Exadata storage cells to quickly
answer the data that is needed in the query - ANS ✓- It stores data in Row Format
- memory configuration, data formats, indexes, and access structures are automatically
optimized to optimize response time
You want to enable automatic indexing in a database, but any new auto indexes should
be created as invisible indexes, so that they cannot be used in SQL statements. Which
command will you use?
- EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','INVISIBLE');
- EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','OFF');
ADB
