Oracle ADB Updated 2024/2025 Actual Questions and answers with complete solutions
5 views 0 purchase
Course
Oracle ADB
Institution
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 hig...
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?
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
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)
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller ACADEMICMATERIALS. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.