Autonomous Database Specialist Exam Questions with Correct Answers
Question 1:
Which TWO tasks are performed by a Fleet Administrator?
Answer:
Provision Autonomous Exadata Infrastructure. Provision Autonomous Container Databases.
Question 2:
Which THREE statements are true about Oracle Data Pump
Answer:
It can perform remapping operations on schemas and data files It can export specified views as
tables
It can overwrite an existing dump file during an export operation
Question 3:
Which TWO statements are true about OCI Command Line Interface?
Answer:
Calls OCI REST APIs Is Easy to use and Lightweight to Install
Question 4:
You want to enable automatic indexing in a database, but any new auto indexes should be
created as invisible indexes, so that they cannot be used in SQL statements. Which command
will you use?
Answer:
EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','REPORT ONLY');
Question 5:
Which are the THREE pre-requisites to configure a private endpoint with Autonomous
Databases (ADBs)?
Answer:
There must be a private subnet with DHCP option. There must be a VCN within the region of
the ADB.
There must be at least one Network Security Group (NSG) within your VCN.
, Question 6:
Which can be used to ensure that your Autonomous Database is accessible only from a given
set of IPs?
Answer:
Access Control List
Question 7:
Which THREE developer tools come out of the box with Autonomous Database?
Answer:
SQL Developer WebOracle REST Data Services APEX
Question 8:
Which THREE developer tools come out of the box with Autonomous Database?
Answer:
SQL Developer Web
Question 9:
If you do not perform a refresh within seven days, then REPORTADB will be no longer
refreshable. Which TWO Data Guard Replication Modes are available in Autonomous Database
Dedicated? Max Performance Max Availability
Which Oracle Package is used to load data to an ADB from object storage?
Answer:
DBMS_CLOUD
Question 10:
When you are increasing the number of OCPUs in your Autonomous Database, what does its
status show?
Answer:
SCALING IN PROGRESS
Question 11:
In which format is data stored in an Oracle Autonomous Data Warehouse database? Columnar
Format
Which command can you use to create an Autonomous Database?
Question 1:
Which TWO tasks are performed by a Fleet Administrator?
Answer:
Provision Autonomous Exadata Infrastructure. Provision Autonomous Container Databases.
Question 2:
Which THREE statements are true about Oracle Data Pump
Answer:
It can perform remapping operations on schemas and data files It can export specified views as
tables
It can overwrite an existing dump file during an export operation
Question 3:
Which TWO statements are true about OCI Command Line Interface?
Answer:
Calls OCI REST APIs Is Easy to use and Lightweight to Install
Question 4:
You want to enable automatic indexing in a database, but any new auto indexes should be
created as invisible indexes, so that they cannot be used in SQL statements. Which command
will you use?
Answer:
EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','REPORT ONLY');
Question 5:
Which are the THREE pre-requisites to configure a private endpoint with Autonomous
Databases (ADBs)?
Answer:
There must be a private subnet with DHCP option. There must be a VCN within the region of
the ADB.
There must be at least one Network Security Group (NSG) within your VCN.
, Question 6:
Which can be used to ensure that your Autonomous Database is accessible only from a given
set of IPs?
Answer:
Access Control List
Question 7:
Which THREE developer tools come out of the box with Autonomous Database?
Answer:
SQL Developer WebOracle REST Data Services APEX
Question 8:
Which THREE developer tools come out of the box with Autonomous Database?
Answer:
SQL Developer Web
Question 9:
If you do not perform a refresh within seven days, then REPORTADB will be no longer
refreshable. Which TWO Data Guard Replication Modes are available in Autonomous Database
Dedicated? Max Performance Max Availability
Which Oracle Package is used to load data to an ADB from object storage?
Answer:
DBMS_CLOUD
Question 10:
When you are increasing the number of OCPUs in your Autonomous Database, what does its
status show?
Answer:
SCALING IN PROGRESS
Question 11:
In which format is data stored in an Oracle Autonomous Data Warehouse database? Columnar
Format
Which command can you use to create an Autonomous Database?
