ADB Exam with verified detailed solutions

ADB Exam with verified detailed solutions|!| |!| |!| |!| |!|




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 - correct 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 - correct 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 - correct
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|




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 - correct 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. - correct 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 - correct 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 - correct 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