Oracle Autonomous Database Cloud Professional Exam Study
Guide with Complete Solutions.
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. correct answers - APEX URLs will not
work for REPORTADB.
- 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. correct answers - REST stands for
Representational State Transfer
- 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. correct answers - The standby database is terminated.
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.
- Access to Database Actions is available for all users of Autonomous Database. correct answers
- Oracle APEX can be accessed only from the Developer menu in the Service Console.
, - SQL Developer Web is available exclusively on the Autonomous Database.
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. correct answers - It is used for Online Transaction
Processing (OLTP) and mixed workloads.
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. correct answers - The
Automatic Backups are moved to C02, as well.
- 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. correct answers - It allows to store JSON data
in the database.
- 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. correct answers - It can be
associated with multiple schemas in the same database.
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.
Guide with Complete Solutions.
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. correct answers - APEX URLs will not
work for REPORTADB.
- 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. correct answers - REST stands for
Representational State Transfer
- 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. correct answers - The standby database is terminated.
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.
- Access to Database Actions is available for all users of Autonomous Database. correct answers
- Oracle APEX can be accessed only from the Developer menu in the Service Console.
, - SQL Developer Web is available exclusively on the Autonomous Database.
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. correct answers - It is used for Online Transaction
Processing (OLTP) and mixed workloads.
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. correct answers - The
Automatic Backups are moved to C02, as well.
- 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. correct answers - It allows to store JSON data
in the database.
- 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. correct answers - It can be
associated with multiple schemas in the same database.
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.
