ADB Certification Exam QUESTIONS
AND CORRECT ANSWERS
What happens if the Autonomous Data Guard is enabled, but the Lifecycle State of the
Primary Database shows "Stopped"?
A. The Standby Database is Stopped
B. The Standby Database is Terminated
C. The Primary Database is Terminated
D. A new Primary Database is Provisioned - CORRECT ANSWER A. The Standby
Database is Stopped
What feature of the Autonomous Database enables a user to 3x CPU/IO resources
immediately when needed by the workload?
A. Auto-Indexing
B. Auto-Patching
C. Auto-Scaling
D. Auto-Tuning - CORRECT ANSWER C. Auto-Scaling
An Autonomous Database (ADB) user with an instance wallet has left the company and
shared a Database User ID with other users when accessing ADB. Other than changing the
shared user password, what can the admin do to protect the instance?
A. Delete the user
B. Rotate the instance wallet and share the new wallet with the remaining users
C. Shutdown and restart the instance
D. Trust the user who left not to access the database - CORRECT ANSWER B. Rotate
the instance wallet and share the new wallet with the remaining users
Which stage of the indexing pipeline divides text into tokens?
, A. SECTIONER
B. FILTER
C. OTOKENIZER
D. LEXER - CORRECT ANSWER D. Lexer
Which two actions are available to perform when an Autonomous Database is stopped?
A. Update License Type
B. Update Network Access
C. Change Administrator Password
D. Start - CORRECT ANSWER A. Update License Type
D. Start
Which is the preferred maintenance schedule of the Exadata Infrastructure for Autonomous
Database Dedicated?
A. Week of the Quarter, Day of the Week, Start Hour
B. Month of the Year, Week of the Month, Day of the Week, Start Hour
C. Quarter of the Year, Month of the Quarter, Date of the Month, Start Hour
D. Month of the Quarter, Week of the Month, Day of the Week, Start Hour - CORRECT
ANSWER D. Month of the Quarter, Week of the Month, Day of the Week, Start Hour
Which two license types does the customer need to benefit from BYOL when leveraging on-
premise Enterprise Database licenses in Oracle Dedicated?
A. Exadata
B. Active Data Guard
C. RAC, but only when scaling beyond 16 OCPUs
D. Transparent Data Encryption
E. Multitenant - CORRECT ANSWER B. Active Data Guard
C. RAC License, but only scaling beyond 16 OCPUs
AND CORRECT ANSWERS
What happens if the Autonomous Data Guard is enabled, but the Lifecycle State of the
Primary Database shows "Stopped"?
A. The Standby Database is Stopped
B. The Standby Database is Terminated
C. The Primary Database is Terminated
D. A new Primary Database is Provisioned - CORRECT ANSWER A. The Standby
Database is Stopped
What feature of the Autonomous Database enables a user to 3x CPU/IO resources
immediately when needed by the workload?
A. Auto-Indexing
B. Auto-Patching
C. Auto-Scaling
D. Auto-Tuning - CORRECT ANSWER C. Auto-Scaling
An Autonomous Database (ADB) user with an instance wallet has left the company and
shared a Database User ID with other users when accessing ADB. Other than changing the
shared user password, what can the admin do to protect the instance?
A. Delete the user
B. Rotate the instance wallet and share the new wallet with the remaining users
C. Shutdown and restart the instance
D. Trust the user who left not to access the database - CORRECT ANSWER B. Rotate
the instance wallet and share the new wallet with the remaining users
Which stage of the indexing pipeline divides text into tokens?
, A. SECTIONER
B. FILTER
C. OTOKENIZER
D. LEXER - CORRECT ANSWER D. Lexer
Which two actions are available to perform when an Autonomous Database is stopped?
A. Update License Type
B. Update Network Access
C. Change Administrator Password
D. Start - CORRECT ANSWER A. Update License Type
D. Start
Which is the preferred maintenance schedule of the Exadata Infrastructure for Autonomous
Database Dedicated?
A. Week of the Quarter, Day of the Week, Start Hour
B. Month of the Year, Week of the Month, Day of the Week, Start Hour
C. Quarter of the Year, Month of the Quarter, Date of the Month, Start Hour
D. Month of the Quarter, Week of the Month, Day of the Week, Start Hour - CORRECT
ANSWER D. Month of the Quarter, Week of the Month, Day of the Week, Start Hour
Which two license types does the customer need to benefit from BYOL when leveraging on-
premise Enterprise Database licenses in Oracle Dedicated?
A. Exadata
B. Active Data Guard
C. RAC, but only when scaling beyond 16 OCPUs
D. Transparent Data Encryption
E. Multitenant - CORRECT ANSWER B. Active Data Guard
C. RAC License, but only scaling beyond 16 OCPUs
