Oracle Autonomous Database Cloud Professional Exam Study Guide Questions with Correct Answers

Oracle Autonomous Database Cloud Professional Exam Study Guide
Questions with Correct Answers


Question 1:
REPORTADB is a refreshable clone of PRODADB. Which TWO statements are TRUE? REPORTADB
can be changed to READ WRITE without disconnecting it from PRODADB. APEX URLs will not
work for REPORTADB.
If you do not perform a refresh within seven days, then REPORTADB will be no longer
refreshable. It is possible to create cascading refreshable clones.
Answer:
- APEX URLs will not work for REPORTADB.



Question 2:
If you do not perform a refresh within seven days, then REPORTADB will be no longer
refreshable. Which statements are TRUE about REST APIs and RESTful services? REST stands for
Representational State Transfer.
REST APIs also use the HTTP communication protocol but mainly use JSON for communication.
RESTful services are complex when compared to traditional XML SOAP communications.
REST APIs only use JSON for communication.
Answer:
- REST stands for Representational State Transfer



Question 3:
REST APIs also use the HTTP communication protocol but mainly use JSON for communication.
What happens with the standby database when disabling Autonomous Data Guard? The
standby database is terminated.
The standby database is started read/write.
The standby database is transformed in a refreshable clone. The standby database is started
read-only.
Answer:
- The standby database is terminated.



Question 4:
Which two statements are TRUE about accessing Autonomous Database Tools? (Choose all
correct answers)
Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database.
Oracle APEX can be accessed only from the Developer menu in the Service Console.

,SQL Developer Web is available exclusively on the Autonomous Database.
Database Actions is accessible from a server running on the same Virtual Cloud Network (VCN)
when the Autonomous Database is configured with Private Endpoint Networking.
Answer:
- Oracle APEX can be accessed only from the Developer menu in the Service Console. SQL
Developer Web is available exclusively on the Autonomous Database.



Question 5:
Which two statements are TRUE about accessing Autonomous Database Tools? (Choose all
correct answers)
Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database.
Oracle APEX can be accessed only from the Developer menu in the Service Console.
SQL Developer Web is available exclusively on the Autonomous Database.
Database Actions is accessible from a server running on the same Virtual Cloud Network (VCN)
when the Autonomous Database is configured with Private Endpoint Networking.
Answer:
- Oracle APEX can be accessed only from the Developer menu in the Service Console. SQL
Developer Web is available exclusively on the Autonomous Database.
Access to Database Actions is available for all users of Autonomous Database.Access to
Database Actions is available for all users of Autonomous Database.
Access to Database Actions is available for all users of Autonomous Database.
Access to Database Actions is available for all users of Autonomous Database.



Question 6:
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 7:
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.
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.



Question 8:
Any policy defined on C02 will be immediately applied to the database. 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.



Question 9:
It supports NoSQL-Style document-centric applications. 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 10:
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.



Question 11:
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: