Questions With Reviewed 100%
Correct Detailed Answers
Guaranteed Pass!!
1. Which Oracle Package is used to load data to an ADB from object storage?
Options are :
DBMS_LOAD
DBMS_CLOUD
DBMS_MIGRATE
DBMS_RPC - ANSWER DBMS_CLOUD (Correct)
2. Which are the TWO prerequisites to migrate a physical database to an
autonomous database? (Choose all correct answers)
Options are :
Database must be a PDB.
All uses of CDB admin privileges must be removed.
Database must not be encrypted.
All indexes must be dropped. - ANSWER Database must be a PDB. (Correct)
All uses of CDB admin privileges must be removed. (Correct)
, 3. Which are the THREE pre-requisites to configure a private endpoint with
Autonomous Databases (ADBs)? (Choose all correct answers)
Options are :
There must be a Web Application Firewall (WAF) configured within the region.
There must be at least one Network Security Group (NSG) within your VCN. (*)
There must be a private subnet with DHCP option.
There must be a VCN within the region of the ADB.
There must be a Vault Key configured for the ADB. - ANSWER There must be
at least one Network Security Group (NSG) within your VCN. (*) (Correct)
There must be a private subnet with DHCP option. (Correct)
There must be a VCN within the region of the ADB. (Correct)
4. In which format is data stored in an Oracle Autonomous Data Warehouse
database?
Options are :
Row Format
Columnar Format
Fast Changing Dimension Format
Slow Changing Dimension Format - ANSWER Columnar Format (Correct)
5. Your company has deployed an Autonomous Database on a dedicated
infrastructure. Which THREE resources will be managed by your company?
(Choose all correct answers)
,Options are :
Schemas
DB User
Storage Servers
Hypervisors
DB servers
Encryption Keys - ANSWER Schemas (Correct)
DB User (Correct)
Encryption Keys (Correct)
6. Which feature is available in Autonomous Database Shared but not in
Autonomous Database Dedicated?
Options are :
Data Guard � Active Standby
Oracle Machine Learning (OML) Notebooks *
Java in Database
Transparent Application Continuity - ANSWER Oracle Machine Learning (OML)
Notebooks * (Correct)
7. What is the pre-requisite for taking a manual backup of an Oracle
Autonomous Database?
Options are :
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.
Your database must be stopped.
You cannot take manual backups of an Oracle Autonomous Database. - ANSWER
You must have an Object Storage bucket and your database must be
configured to connect to it. (Correct)
8. Who manages the compartment quotas for an Autonomous Database in a
dedicated infrastructure?
Options are :
System Administrator
Fleet Administrator
Database Administrator
Service Administrator - ANSWER Fleet Administrator (Correct)
9. Which TWO infrastructure support deployment of Oracle Autonomous
Database? (Choose all correct answers)
Options are :
Dedicated Exadata Infrastructure
Virtual Machines on Oracle Cloud Infrastructure
Shared Exadata Infrastructure
Oracle Bare Metal Servers - ANSWER Dedicated Exadata Infrastructure
(Correct)
Shared Exadata Infrastructure (Correct)