Oracle ADB Updated 2024/2025 Actual Questions and answers with complete solutions

Oracle ADB
According to Oracle documentation, What is a best practice when planning and instituting Access
Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User
Groups?



- create at least 2 of each reosurce

- only 1 subnet and 1 compartment allowed, multiple groups highly advised

- Only 1 of each is allowed to be allocated per environment

- Create a sep VCN that contains only public subnets - Create at least 2 of each resource




During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database
Administrator need to select to determine where the Autonomous Database is created on the Dedicated
infrastructure?



-the compartment of the dedicated infrastructure as each compartment only runs one dedicated
environment

- the listener endpoint where the autonomous database should register on

- the client credentials wallet which is used to connect to the autonomous database

- the container database in which the Autonomous instance should run - the container database
in which the Autonomous instance should run



For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?



- allow group adb-admins to manage autonomous-database in tenancy where target.workloadType=
"DW"

- allow group ADB-admins to manage autonomous-database in tenancy

- allow group ADB-admins to manage autonomous-database-family in tenancy

,- allow group adb-admins to manage autonomous database in tenancy where target.workloadType=
'OTLP' - - Allow group ADB-Admin to manage autonomous-database-family in tenancy



For someone that is not a service administrator to use SQL Developer Web, what package would you
need to use to give them access?



ORDS_ADMIN.ENABLE_SCHEMA

ORDS_ADMIN.GRANT_SCHEMA

SQLDEV_ADMIN.GRANT_SCHEMA

ORDS_PRIV.ENABLE_SCHEMA - ORDS_ADMIN.ENABLE_SCHEMA



How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud
Infrastructure console?



- it cannot be done

- connecting to the cloud infrastructure command console via SSH wallet

- using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls

- using dbca on the database server - Using the Oracle Cloud Infrastructure Command Line
interface tool or REST API calls



How do you change the tablespace quota for a user ADBUSER on Autonomous Database on Shared
Infrastructure - Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username =>
ADBUSER ,tablespace_quota => UNLIMITED)



In Graph Studio which you can use to create a graph?



- a graph license key

- tables in an adb instance

- no SQL configuration

- graph analytics algorithms

, - graph created by a special tool downloaded from oracle.com - Tables in an Autonomous
Database instance



In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control
OCPU utilization?



- Oracle Machine Learning notebook

- Compartment quotas

- SQL developer web console

- Resource manager settings - Compartment quotas



Oracle Autonomous Databases on Dedicated Infrastructure is composed of which Oracle Cloud
resources?



- virtual cloud network, compartments, policies, and autonomous exadata infrastructure

- fleet administrator, database adminstrator, database user, and autonomous exadata infrastructure

- Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and
Autonomous Database

- oracle machine learning zeppelin notebook, autonomous exadata infrastructure, fleet administrator,
and database administrator - Autonomous Exadata infrastructure, Autonomous Backup,
Autonomous Container Database, and Autonomous Database



To whom, and in which order, are dedicated Exadata Infrastructure resources provisioned?



-Fleet Administrator. Autonomous Exadata Infrastructure >> Autonomous Container DB >> Database
Administrator >> Autonomous DB

- fleet administrator. autonomous exadata infrastructure >> database administrator >> autonomous
container DB >> autonomous db - Fleet Administrator. Autonomous Exadata Infrastructure >>
Autonomous Container DB >> Database Administrator >> Autonomous DB



What are 3 methods to load data into the autonomous database? (Choose three)