Oracle Autonomous Database (ADB): A Complete Guide to Features, Pricing & Benefits

Page 1 of 87


ORACLE ADB (AUTONOMOUS DATABASE)

CERTIFICATION EXAMS (LATEST UPDATES

STUDY BUNDLE PACKAGE WITH SOLUTIONS)

QUESTIONS AND ANSWERS | GRADE A | 100%

CORRECT (VERIFIED ANSWERS)

Which two methods can use to create users and grant roles in

Autonomous Database?




- using DBMS_CLOUD_ADMIN package

- through Oracle Cloud Infrastructure Service Console

- through SQL/Developers

-Through SQL*PLus .....ANSWER.....through SQL/Developers

through SQL*Plus

,Page 2 of 87


When running lots of high concurrent queries in Autonomous

Database, you should use which predefined service connection?




- DBNAME_MEDIUM

-DBNAME_HIGH

-DBNAME_CONCURRENT

-DBNAME_LOW

.....ANSWER.....DBNAME_LOW

Where can a user's public ssh key be added on the Oracle

Cloud Infrastructure Console in order to execute API calls?




-SSH keys are not required in OCI

-SSH keys cannot be added from console. They have to be

added using Rest APis only

,Page 3 of 87


-On the ADB console

-Navigate to Identity, select Users panel on the console and

select "Add Public Key"

.....ANSWER.....Navigate to Identity, select Users panel on the

console and select "Add Public Key"

Which three Oracle Cloud Infrastructure (OCI) resources do you

need to configure before provisioning your Autonomous

database with Private Endpoint?

-security list

-route table

-subnet

-VCN

-Network Security Group

.....ANSWER.....- Subnet

, Page 4 of 87


- VCN

- Network Security Group

Which three event types are supported for Autonomous

Database? (Choose three)




- Update IORM Begin

-Maintenance Begin

-Terminate End

-Change Autoscaling Configuration Compartment

-Change Compartment Begin .....ANSWER.....- Terminate End

- Maintenance Begin

- Change Compartment Begin

When in the SQL Monitoring tab the Performance Hub you see a

clock icon in the status column, What does this mean?