Page 1 of 106
Oracle Autonomous Database Cloud Specialist EXAM
COMPLETE NEWEST QUESTIONS AND VERIFIED
SOLUTIONS LATEST UPDATE THIS YEAR
QUESTION: Which statement is TRUE about Autonomous Transaction Processing?
- It is used for analytic workloads.
- It is used with data marts and machine learning.
- Data is stored in columnar format.
- It is used for OLTP and mixed workloads. - ANSWER-- It is used for Online Transaction
Processing (OLTP) and mixed workloads.
QUESTION: You have moved an Autonomous Database from compartment C01 to C02. Which
of TWO are TRUE?
- An Autonomous Data Guard for the database is created in C01 post successful migration to
C02.
1
, Page 2 of 106
- You need to shut down the database in C01 before you can move it to C02.
- The Automatic Backups are moved to C02, as well.
- Any policy defined on C02 will be immediately applied to the database. - ANSWER-- The
Automatic Backups are moved to C02, as well.
- Any policy defined on C02 will be immediately applied to the database.
QUESTION: Which statements are TRUE about Oracle Autonomous JSON Database?
- It does not support autoscaling.
- It allows to store JSON data in the database.
- It supports NoSQL-Style document-centric applications.
- It supports MySQL-style database applications. - ANSWER-- It allows to store JSON data in the
database.
- It supports NoSQL-Style document-centric applications.
2
, Page 3 of 106
QUESTION: Which is true about a workspace in Oracle APEX?
- It is not associated with any schemas.
- It can be associated with multiple schemas from different databases.
- It can be associated only with one schema.
- It can be associated with multiple schemas in the same database. - ANSWER-- It can be
associated with multiple schemas in the same database.
QUESTION: Which statement is TRUE about Spatial studio?
- It does not need additional resources.
- It comes with an Autonomous Database at an additional cost.
- It is a self-service application to create interactive maps.
- It is a fully managed service available in OCI. - ANSWER-- It is a self-service application to
create interactive maps.
3
, Page 4 of 106
QUESTION: Which TWO statements are TRUE about Access Control Lists (ACLs) configured for
Autonomous Databases?
- Access Control Lists can be configured for autonomous databases only at the time of
provisioning.
- A database restore overwrites the existing ACLs.
- ACLs can be configured for individual IP address, CIDR block ranges, and VCNs.
- All services that are subsets of an ADB, such as SQL Developer Web, APEX, and OML
notebooks, are also blocked by ACLs - ANSWER-- ACLs can be configured for individual IP
address, Classless Inter-Domain Routing (CIDR) block ranges, and Virtual Cloud Networks
(VCNs).
- All services that are subsets of an ADB, such as SQL Developer Web, APEX, and OML
notebooks, are also blocked by ACLs
QUESTION: Which can be used to ensure that your Autonomous Database is accessible only
from a given set of IPs?
4
Oracle Autonomous Database Cloud Specialist EXAM
COMPLETE NEWEST QUESTIONS AND VERIFIED
SOLUTIONS LATEST UPDATE THIS YEAR
QUESTION: Which statement is TRUE about Autonomous Transaction Processing?
- It is used for analytic workloads.
- It is used with data marts and machine learning.
- Data is stored in columnar format.
- It is used for OLTP and mixed workloads. - ANSWER-- It is used for Online Transaction
Processing (OLTP) and mixed workloads.
QUESTION: You have moved an Autonomous Database from compartment C01 to C02. Which
of TWO are TRUE?
- An Autonomous Data Guard for the database is created in C01 post successful migration to
C02.
1
, Page 2 of 106
- You need to shut down the database in C01 before you can move it to C02.
- The Automatic Backups are moved to C02, as well.
- Any policy defined on C02 will be immediately applied to the database. - ANSWER-- The
Automatic Backups are moved to C02, as well.
- Any policy defined on C02 will be immediately applied to the database.
QUESTION: Which statements are TRUE about Oracle Autonomous JSON Database?
- It does not support autoscaling.
- It allows to store JSON data in the database.
- It supports NoSQL-Style document-centric applications.
- It supports MySQL-style database applications. - ANSWER-- It allows to store JSON data in the
database.
- It supports NoSQL-Style document-centric applications.
2
, Page 3 of 106
QUESTION: Which is true about a workspace in Oracle APEX?
- It is not associated with any schemas.
- It can be associated with multiple schemas from different databases.
- It can be associated only with one schema.
- It can be associated with multiple schemas in the same database. - ANSWER-- It can be
associated with multiple schemas in the same database.
QUESTION: Which statement is TRUE about Spatial studio?
- It does not need additional resources.
- It comes with an Autonomous Database at an additional cost.
- It is a self-service application to create interactive maps.
- It is a fully managed service available in OCI. - ANSWER-- It is a self-service application to
create interactive maps.
3
, Page 4 of 106
QUESTION: Which TWO statements are TRUE about Access Control Lists (ACLs) configured for
Autonomous Databases?
- Access Control Lists can be configured for autonomous databases only at the time of
provisioning.
- A database restore overwrites the existing ACLs.
- ACLs can be configured for individual IP address, CIDR block ranges, and VCNs.
- All services that are subsets of an ADB, such as SQL Developer Web, APEX, and OML
notebooks, are also blocked by ACLs - ANSWER-- ACLs can be configured for individual IP
address, Classless Inter-Domain Routing (CIDR) block ranges, and Virtual Cloud Networks
(VCNs).
- All services that are subsets of an ADB, such as SQL Developer Web, APEX, and OML
notebooks, are also blocked by ACLs
QUESTION: Which can be used to ensure that your Autonomous Database is accessible only
from a given set of IPs?
4
