While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure (OCI) console, which patch type is offered to be applied during maintenance? (Choose the best answer.)
Answer : C
When enabling auto-scaling, which three options do not change? (Choose three.)
Answer : ACE
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure? (Choose the best answer.)
Answer : E
Autonomous Databaseג€™s auto scaling feature allows your database to use up to three times the current base number of CPU cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use.
Which statement is FALSE regarding the auto scaling feature? (Choose the best answer.)
Answer : A
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console? (Choose the best answer.)
Answer : B
In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization? (Choose the best answer.)
Answer : B
Reference:
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adboverview.htm
Which three security features are available in Oracle Autonomous Database Shared Infrastructure? (Choose three.)
Answer : BDE
Reference:
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/security-features-adb1.html#GUID-89E3C22E-D4EB-472B-8287-41682C2B61B3
A new Python developer has joined your team and needs to access the Autonomous Database (ADB) data.
How does the developer connect to and interact with ADB from Python? (Choose the best answer.)
Answer : A
Reference:
https://developer.oracle.com/databases/database-for-python-developers-1.html
Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).
How can they achieve this? (Choose the best answer.)
Answer : C
Reference:
https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/change-maintenance-schedule-acd.html#GUID-CA028A37-5510-473E-B4D0-
A5D454B8DA6E -
Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production.
How should the customer unplug their database to migrate to Autonomous Database (ADB)? (Choose the best answer.)
Answer : C
Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure? (Choose the best answer.)
Answer : A
Which statement is correct about managing and monitoring of Autonomous Database? (Choose the best answer.)
Answer : D
Reference:
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbbackingup.htm
You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and your application is using the TPURGENT service.
The load on the database increases from three OCPUs to nine OCPUs.
What is the total number of concurrent statements that the TPURGENT service can support? (Choose the best answer.)
Answer : A
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported? (Choose two.)
Answer : AD
Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment? (Choose the best answer.)
Answer : C