Page 1 of 170
Autonomous Database Exam COMPLETE NEWEST
QUESTIONS AND VERIFIED SOLUTIONS LATEST
UPDATE THIS YEAR
Which statements are true about Autonomous Transaction Processing? (Choose two)
Data is stored in row format.
Missing indexes are detected and created.
Data is stored in columnar format.
Complex SQL queries are optimized.
Data is stored in row format.
Missing indexes are detected and created.
Which statements are true about using Oracle Cloud Infrastructure? (Choose three)
It provides high availability and scalability.
It supports only Bare Metal DB Systems.
It supports only Virtual Machine and Bare Metal DB Systems.
It enables you to run everything from small VMs to large bare metal clusters.
It provides complete lifecycle automation.
It supports only Exadata systems
1
, Page 2 of 170
It provides high availability and scalability.
It enables you to run everything from small VMs to large bare metal clusters.
It provides complete lifecycle automation.
In which format is data stored in an Oracle Autonomous Data Warehouse database?
Columnar Format
Fast Changing Dimension Format
Slow Changing Dimension Format
Row Format
Columnar Format
What is the pre-requisite for taking a manual backup of an Oracle Autonomous Database?
You cannot take manual backups of an Oracle Autonomous Database.
You must have an Object Storage bucket and your database must be configured to connect to
it.
Your database must be stopped.
Your database must be deployed on Oracle Exadata Cloud@Customer X8M.
You must have an Object Storage bucket and your database must be configured to connect to
it.
2
, Page 3 of 170
Which command can you use to create an Autonomous Database?
POST /20160918/createDatabases
POST /20160918/autonomousDatabases
POST /20160918/createADB
POST /20160918/createautonomousDatabases
DWROLE
Which THREE can be used in ADB for authentication to object storage? Which THREE are used
by IAM service to authenticate a principal ?
SSH
API signing key
Username and Password
Resource Principal
Wallet Credentials
API signing key
Username and Password
Resource Principal
Which TWO statements are true about API Signing Key?
An RSA key pair in PEM format must have a minimum of 1024 bits.
3
, Page 4 of 170
It is an RSA key pair in PEM format.
It must be generated with a passphrase.
It is required when using OCI API in conjunction with SDK/CLI.
It is an RSA key pair in PEM format.
It is required when using OCI API in conjunction with SDK/CLI.
Which operations are included in automated data center operations?
Provisioning a database
Patching a database
Online backups of a database
Automatically handling failures and errors
All of the above
All of the above
Which two actions can be performed from the OCI Console for an Oracle Autonomous
Database?
Scale up/down Memory
Increase Network Bandwidth
4
Autonomous Database Exam COMPLETE NEWEST
QUESTIONS AND VERIFIED SOLUTIONS LATEST
UPDATE THIS YEAR
Which statements are true about Autonomous Transaction Processing? (Choose two)
Data is stored in row format.
Missing indexes are detected and created.
Data is stored in columnar format.
Complex SQL queries are optimized.
Data is stored in row format.
Missing indexes are detected and created.
Which statements are true about using Oracle Cloud Infrastructure? (Choose three)
It provides high availability and scalability.
It supports only Bare Metal DB Systems.
It supports only Virtual Machine and Bare Metal DB Systems.
It enables you to run everything from small VMs to large bare metal clusters.
It provides complete lifecycle automation.
It supports only Exadata systems
1
, Page 2 of 170
It provides high availability and scalability.
It enables you to run everything from small VMs to large bare metal clusters.
It provides complete lifecycle automation.
In which format is data stored in an Oracle Autonomous Data Warehouse database?
Columnar Format
Fast Changing Dimension Format
Slow Changing Dimension Format
Row Format
Columnar Format
What is the pre-requisite for taking a manual backup of an Oracle Autonomous Database?
You cannot take manual backups of an Oracle Autonomous Database.
You must have an Object Storage bucket and your database must be configured to connect to
it.
Your database must be stopped.
Your database must be deployed on Oracle Exadata Cloud@Customer X8M.
You must have an Object Storage bucket and your database must be configured to connect to
it.
2
, Page 3 of 170
Which command can you use to create an Autonomous Database?
POST /20160918/createDatabases
POST /20160918/autonomousDatabases
POST /20160918/createADB
POST /20160918/createautonomousDatabases
DWROLE
Which THREE can be used in ADB for authentication to object storage? Which THREE are used
by IAM service to authenticate a principal ?
SSH
API signing key
Username and Password
Resource Principal
Wallet Credentials
API signing key
Username and Password
Resource Principal
Which TWO statements are true about API Signing Key?
An RSA key pair in PEM format must have a minimum of 1024 bits.
3
, Page 4 of 170
It is an RSA key pair in PEM format.
It must be generated with a passphrase.
It is required when using OCI API in conjunction with SDK/CLI.
It is an RSA key pair in PEM format.
It is required when using OCI API in conjunction with SDK/CLI.
Which operations are included in automated data center operations?
Provisioning a database
Patching a database
Online backups of a database
Automatically handling failures and errors
All of the above
All of the above
Which two actions can be performed from the OCI Console for an Oracle Autonomous
Database?
Scale up/down Memory
Increase Network Bandwidth
4
