ADB Exam Questions and Correct
Answers
Which two methods can you use to create database users and grant roles in Autonomous Database
services? (Choose all correct answers)
-SQL Developer
-The pams_cnoup_apmrn package
-SQL*Plus
-The Oracle Cloud Infrastructure service console - Answer--SQL Developer
-SQL*Plus
Which method will NOT permit you to change the database apsrn user's password of an Oracle
Autonomous Database on Shared Infrastructure?
-OS command line from the database server
-SQL Developer
-OCI CLI
-Admin page of the Cloud Service Console - Answer--OS command line from the database server
,Which two options are available to retore an Oracle Autonomous Database?
-Specify the archived custom image
-Use recovery manager (rman) to connect to the autonomous database and back it up
-select the snapshot of the backup
-specify the point in time (timestamp) to restore
-select the backup from which restore needs to be done - Answer--specify the archived custom image
-specify the point in time (timestamp) to retore
What are two differentiators of Oracle Autonomous Database on Dedicated Infrastructure?
-Users have OS access to the database machine
-users can customize the OS stack and add additional packages
-users have more control over the maintenance schedule
-users have system privileges in the database
-to offers greater control and isolation starting at the exadata cloud infrastructure level - Answer--users
have OS access to the database machine
-to offers greater control and isolation starting at the exadata cloud infrastructure level
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)?
-RO Unplug into an XML file so database files and XML file can be uploaded to object storage
-Create a database link from the source database to the ADB environment and clone the PDB
-Unplug into a PDB archive, which can be uploaded to object storage
, -Pluggable databases cannot be migrated to ADB using plug, unplug, or clone. - Answer--Pluggable
databases cannot be migrated to ADB using plug, unplug, or clone
How do you change the tablespace quota for user mrizo on autonomous database on shared
infrastructure?
-Execute alter database for user MTHEO tablespace DATA quota = 10G
-execute alter user MTHEO quota unlimited on tablespace DATA
-execute nams_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username> "MTHEO, tablespace quota>
UNLIMITED)
-execute alter tablespace DATA set quote = 10G - Answer--execute
nams_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username> "MTHEO, tablespace quota>
UNLIMITED)
Which set of options can be specified when defining the preferred maintenance schedule of the Exadata
infrastructure for Autonomous Database Dedicated?
-quarter of the year, month of the quarter, date of the month, stat hours
-month of the quarter, week of the month, day of the week, start hour
-month of the year, week of the month, day of the week, start hour
-week of the quarter, day of the week, start hour - Answer--month of the quarter, week of the month,
day of the week, start hour
Which two statements are true about Data Insights? (Choose all correct answers)
-Data Insights is available with on-premises deployments of Oracle Database
-You can retrieve previously executed Data Insights searches
-Data Insights is an additional priced option.
Answers
Which two methods can you use to create database users and grant roles in Autonomous Database
services? (Choose all correct answers)
-SQL Developer
-The pams_cnoup_apmrn package
-SQL*Plus
-The Oracle Cloud Infrastructure service console - Answer--SQL Developer
-SQL*Plus
Which method will NOT permit you to change the database apsrn user's password of an Oracle
Autonomous Database on Shared Infrastructure?
-OS command line from the database server
-SQL Developer
-OCI CLI
-Admin page of the Cloud Service Console - Answer--OS command line from the database server
,Which two options are available to retore an Oracle Autonomous Database?
-Specify the archived custom image
-Use recovery manager (rman) to connect to the autonomous database and back it up
-select the snapshot of the backup
-specify the point in time (timestamp) to restore
-select the backup from which restore needs to be done - Answer--specify the archived custom image
-specify the point in time (timestamp) to retore
What are two differentiators of Oracle Autonomous Database on Dedicated Infrastructure?
-Users have OS access to the database machine
-users can customize the OS stack and add additional packages
-users have more control over the maintenance schedule
-users have system privileges in the database
-to offers greater control and isolation starting at the exadata cloud infrastructure level - Answer--users
have OS access to the database machine
-to offers greater control and isolation starting at the exadata cloud infrastructure level
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)?
-RO Unplug into an XML file so database files and XML file can be uploaded to object storage
-Create a database link from the source database to the ADB environment and clone the PDB
-Unplug into a PDB archive, which can be uploaded to object storage
, -Pluggable databases cannot be migrated to ADB using plug, unplug, or clone. - Answer--Pluggable
databases cannot be migrated to ADB using plug, unplug, or clone
How do you change the tablespace quota for user mrizo on autonomous database on shared
infrastructure?
-Execute alter database for user MTHEO tablespace DATA quota = 10G
-execute alter user MTHEO quota unlimited on tablespace DATA
-execute nams_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username> "MTHEO, tablespace quota>
UNLIMITED)
-execute alter tablespace DATA set quote = 10G - Answer--execute
nams_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username> "MTHEO, tablespace quota>
UNLIMITED)
Which set of options can be specified when defining the preferred maintenance schedule of the Exadata
infrastructure for Autonomous Database Dedicated?
-quarter of the year, month of the quarter, date of the month, stat hours
-month of the quarter, week of the month, day of the week, start hour
-month of the year, week of the month, day of the week, start hour
-week of the quarter, day of the week, start hour - Answer--month of the quarter, week of the month,
day of the week, start hour
Which two statements are true about Data Insights? (Choose all correct answers)
-Data Insights is available with on-premises deployments of Oracle Database
-You can retrieve previously executed Data Insights searches
-Data Insights is an additional priced option.
