Oracle ADB (Autonomous Database)
Certification Exam Review (Latest
Update ) Questions and
Answers | Grade A | 100% Correct
Question:
Which method will NOT permit you to change the database apsrn user's
password of an Oracle Autonomous Database on Shared Infrastructure?
Answer:
OS command line from the database server
Question:
Which two options are available to restore an Oracle Autonomous Database?
(Choose all correct answers)
Answer:
Specify the point in time (timestamp) to restore
Select the backup from which restore needs to be done
,Question:
What are two differentiators of Oracle Autonomous Database on Dedicated
Infrastructure? (Choose all correct answers)
Answer:
Users have more control over the maintenance schedule
Offers greater control and Isolation starting at the Exadata cloud
infrastructure level
Question:
Your customer has upgraded their on-premises 11.2 Database to 12.2. Dui
database was migrated to a pluggable database and is now in production.
How should the customer unplug their database to migrate to Autonomous
Database (ADB)?
Answer:
Pluggable databases cannot be migrated to ADB using plug, unplug, or clone.
Question:
Which set of options can be specified when defining the preferred
maintenance schedule of the Exadata infrastructure for Autonomous
Database Dedicated?
Answer:
Month of the Quarter, Week of the Month, Day of the week, Start Hour
, Question:
How do you change the tablespace quota for user mtheo on Autonomous
Database on Shared Infrastructure?
Answer:
Execute
nams_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA(username =>
MTHEO;, tablespace quota -
UNLIMITED
Question:
Which two statements are true about Data Insights? (Choose all correct
answers)
Answer:
You can retrieve previously executed Data Insights searches
You can search for Data Insights against a base table or business model
Question:
Which native data type is used to store spatial information?
Answer:
spo_Geometry
Certification Exam Review (Latest
Update ) Questions and
Answers | Grade A | 100% Correct
Question:
Which method will NOT permit you to change the database apsrn user's
password of an Oracle Autonomous Database on Shared Infrastructure?
Answer:
OS command line from the database server
Question:
Which two options are available to restore an Oracle Autonomous Database?
(Choose all correct answers)
Answer:
Specify the point in time (timestamp) to restore
Select the backup from which restore needs to be done
,Question:
What are two differentiators of Oracle Autonomous Database on Dedicated
Infrastructure? (Choose all correct answers)
Answer:
Users have more control over the maintenance schedule
Offers greater control and Isolation starting at the Exadata cloud
infrastructure level
Question:
Your customer has upgraded their on-premises 11.2 Database to 12.2. Dui
database was migrated to a pluggable database and is now in production.
How should the customer unplug their database to migrate to Autonomous
Database (ADB)?
Answer:
Pluggable databases cannot be migrated to ADB using plug, unplug, or clone.
Question:
Which set of options can be specified when defining the preferred
maintenance schedule of the Exadata infrastructure for Autonomous
Database Dedicated?
Answer:
Month of the Quarter, Week of the Month, Day of the week, Start Hour
, Question:
How do you change the tablespace quota for user mtheo on Autonomous
Database on Shared Infrastructure?
Answer:
Execute
nams_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA(username =>
MTHEO;, tablespace quota -
UNLIMITED
Question:
Which two statements are true about Data Insights? (Choose all correct
answers)
Answer:
You can retrieve previously executed Data Insights searches
You can search for Data Insights against a base table or business model
Question:
Which native data type is used to store spatial information?
Answer:
spo_Geometry
