Page 1 of 180
Autonomous Database Exam ACTUAL EXAM ALL
QUESTIONS AND CORRECT ANSWERS LATEST
UPDATE THIS YEAR
Which FOUR levels of access can be defined in policies?
Read
Write
Inspect
Create
Use
Manage
Read
Inspect
Use
Manage
Who manages the compartment quotas for an Autonomous Database in a dedicated
infrastructure?
1
, Page 2 of 180
Fleet Administrator
Database Administrator
Service Administrator
System Administrator
Fleet Administrator
Which Oracle Package is used to load data to an ADB from object storage?
DBMS_MIGRATE
DBMS_CLOUD
DBMS_RPC
DBMS_LOAD
DBMS_CLOUD
Which TWO statements are true about OCI Command Line Interface?
runs only on Linux operating systems
is easy to use but involves complex installation and configuration
is easy to use and lightweight to install
does not use REST APIs
calls OCI REST APIs
2
, Page 3 of 180
is easy to use and lightweight to install
calls OCI REST APIs
Which THREE predefined database service names are available in an Autonomous Data
Warehouse?
tp
high
medium
tpurgent
low
high
medium
low
Which THREE statements are TRUE about private endpoints?
You can configure an existing Autonomous Database (ADB) to use a private endpoint.
You need to set up transit routing in your VCN and use a service gateway to connect.
You can change the network access of an autonomous database in a shared Exadata
infrastructure from private endpoint to public endpoint.
You can configure a private endpoint while cloning your ADB.
3
, Page 4 of 180
You can configure an existing Autonomous Database (ADB) to use a private endpoint.
You can change the network access of an autonomous database in a shared Exadata
infrastructure from private endpoint to public endpoint.
You can configure a private endpoint while cloning your ADB.
Which TWO statements are TRUE about Auto Scaling?
Enabling auto scaling also increases the concurrency and parallelism settings for the
predefined services.
Scaling up automatically expands CPU but not IO resources.
It can be enabled when provisioning an ADB instance or anytime using the Oracle Cloud
Infrastructure console.
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 Oracle Cloud
Infrastructure console.
If you are provisioning an always-free database, auto scaling is not available.
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','REPORT ONLY');
4
Autonomous Database Exam ACTUAL EXAM ALL
QUESTIONS AND CORRECT ANSWERS LATEST
UPDATE THIS YEAR
Which FOUR levels of access can be defined in policies?
Read
Write
Inspect
Create
Use
Manage
Read
Inspect
Use
Manage
Who manages the compartment quotas for an Autonomous Database in a dedicated
infrastructure?
1
, Page 2 of 180
Fleet Administrator
Database Administrator
Service Administrator
System Administrator
Fleet Administrator
Which Oracle Package is used to load data to an ADB from object storage?
DBMS_MIGRATE
DBMS_CLOUD
DBMS_RPC
DBMS_LOAD
DBMS_CLOUD
Which TWO statements are true about OCI Command Line Interface?
runs only on Linux operating systems
is easy to use but involves complex installation and configuration
is easy to use and lightweight to install
does not use REST APIs
calls OCI REST APIs
2
, Page 3 of 180
is easy to use and lightweight to install
calls OCI REST APIs
Which THREE predefined database service names are available in an Autonomous Data
Warehouse?
tp
high
medium
tpurgent
low
high
medium
low
Which THREE statements are TRUE about private endpoints?
You can configure an existing Autonomous Database (ADB) to use a private endpoint.
You need to set up transit routing in your VCN and use a service gateway to connect.
You can change the network access of an autonomous database in a shared Exadata
infrastructure from private endpoint to public endpoint.
You can configure a private endpoint while cloning your ADB.
3
, Page 4 of 180
You can configure an existing Autonomous Database (ADB) to use a private endpoint.
You can change the network access of an autonomous database in a shared Exadata
infrastructure from private endpoint to public endpoint.
You can configure a private endpoint while cloning your ADB.
Which TWO statements are TRUE about Auto Scaling?
Enabling auto scaling also increases the concurrency and parallelism settings for the
predefined services.
Scaling up automatically expands CPU but not IO resources.
It can be enabled when provisioning an ADB instance or anytime using the Oracle Cloud
Infrastructure console.
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 Oracle Cloud
Infrastructure console.
If you are provisioning an always-free database, auto scaling is not available.
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','REPORT ONLY');
4
