**Q:** What predefined user is created when provisioning an
Autonomous Database (ADB)?
**Options:**
A. SYSTEM
B. ROOT
C. ADMIN
D. DBA
**✅ Answer:** C. ADMIN
**Explanation:** The ADMIN user is automatically created
during provisioning with administrative privileges.
### Question 2
**Q:** Which connection service is appropriate for a high
concurrency OLTP application with some reporting in parallel
mode?
**Options:**
A. LOW
B. HIGH
C. TP
D. TPURGENT
**✅ Answer:** D. TPURGENT
**Explanation:** TPURGENT is optimized for high
concurrency OLTP workloads, offering low latency with parallel
support.
### Question 3
**Q:** Which stage of the indexing pipeline divides text into
tokens?
**Options:**
A. FILTER
B. SECTIONER
C. TOKENIZER
D. LEXER
**✅ Answer:** C. TOKENIZER
**Explanation:** The tokenizer breaks text into searchable
tokens.
### Question 4
**Q:** Which option should you use to create a graph with
Graph Studio?
**Options:**
A. Files in Object Storage
B. Tables in an Autonomous Database instance
C. External JSON files
D. External CSV files
**✅ Answer:** B. Tables in an Autonomous Database instance
**Explanation:** Graph Studio works directly with existing
tables in ADB.
### Question 5
**Q:** Which is a feature of a graph query language?
**Options:**
A. Ability to specify patterns
B. Support for document indexing
C. Automatic sharding
D. Schema-free design
**✅ Answer:** A. Ability to specify patterns
**Explanation:** Graph query languages let you search for
complex data patterns.
### Question 6
**Q:** Which statement is FALSE about the Catalog tool?
**Options:**
A. You can view metadata definitions.
B. You can delete entities from the catalog.
C. You can filter catalog entities by criteria.
D. You can view entities from source databases.
**✅ Answer:** B. You can delete entities from the catalog.
**Explanation:** The Catalog tool is read-only.
### Question 7
**Q:** Which statement is FALSE about loading data using the
Data Load card?
**Options:**
A. Data can be loaded from a local data source.
B. Supported formats include text, csv, json, avro, and parquet.
C. Data can be uploaded from cloud storage providers.
D. Data can be loaded from a remote database using DBLinks.
E. You must create dbms_cloud.create_credential before
accessing Oracle Object Storage.
**✅ Answer:** D. Data can be loaded from a remote database
using DBLinks.
**Explanation:** DBLinks are not used in the Data Load card.
### Question 8
**Q:** Which statement is FALSE regarding database links?
**Options:**
A. You can connect to a remote DB from an Autonomous DB
using DBLink.
B. You can connect to Autonomous DB from a remote DB using
DBLink.
C. You can call PL/SQL procedures using DBLink.
D. You can create DBLink from one Autonomous DB to another.
**✅ Answer:** B. You can connect to Autonomous DB from a
remote DB using DBLink.
**Explanation:** Autonomous DB does not allow inbound
DBLinks.
### Question 9
**Q:** What happens to regional wallets after rotating instance
wallet?
**Options:**
A. They revert to pending.
B. They are also rotated.
C. They become invalid.
D. They continue to work.
**✅ Answer:** D. They continue to work.
**Explanation:** Regional wallets remain valid until expiry or
manual update.
### Question 10
**Q:** Which three statements are true about changing license
options?
**Options:**
A. You can update BYOL to License Included.
B. You cannot update License Included to BYOL.
C. You can upgrade Always Free to paid anytime.
D. You cannot update BYOL to License Included.
E. You can update License Included to BYOL.
**✅ Answer:** A, B, C
**Explanation:** BYOL ➔ LI possible; LI ➔ BYOL not
allowed.
### Question 11
**Q:** Which two statements are true about Data Insights?
**Options:**
A. It is an extra paid option.
B. Available on-premises.
C. You can search against base table or business model.
D. You can retrieve previous searches.
**✅ Answer:** C, D
**Explanation:** Data Insights is included and allows re-
execution.
### Question 12
**Q:** Can you permanently disable scheduled maintenance?
**Options:**
A. Set maintenance schedule to “None”.
B. Set schedule to “No Preference”.
C. You cannot permanently disable automatic maintenance.
D. Leave month/week/day empty.
**✅ Answer:** C. You cannot permanently disable automatic
maintenance.
**Explanation:** Maintenance is mandatory but can be
deferred.
### Question 13
**Q:** How do you set up a notification for shutdown?
**Options:**
A. BEFORE SHUTDOWN trigger.
B. OCI Event for “Autonomous Database STOP END”.
C. OCI Alarm for shutdown metric.
D. DBMS_SNMP package.
**✅ Answer:** B. OCI Event for “STOP END”.
**Explanation:** OCI Events are used for lifecycle
notifications.
### Question 14
**Q:** Which statement is FALSE about Auto Scaling?
**Options:**
A. Auto-scaling is enabled by default.
B. Auto-scaling can scale up to 3x OCPUs.
C. Auto-scaling can be enabled or disabled anytime.
D. Auto-scaling guarantees performance under all conditions.
**✅ Answer:** D. Auto-scaling guarantees performance under
all conditions.
**Explanation:** Performance is not always guaranteed.
### Question 15
**Q:** Which two are true about ECPU scaling?
**Options:**
A. Active transactions are terminated.
B. Scaling requires downtime.
C. Scaling happens while transactions are active.
D. Running queries are unaffected.
**✅ Answer:** C, D
**Explanation:** Scaling is online and transparent.
### Question 16
**Q:** Which parameter is invalid when creating DB using
OCI CLI?
**Options:**
A. –admin-password
B. –db-name
C. –cpu-core-count
D. –storage-type
**✅ Answer:** D. –storage-type
**Explanation:** Storage type isn’t a valid CLI parameter.
### Question 17
**Q:** Which two OCI resources are needed for manual
backup?
**Options:**
A. Object Storage Bucket
B. Service Gateway
C. Storage Gateway
D. Backup Job
**✅ Answer:** A, B
**Explanation:** Object Storage and Service Gateway are
required.
### Question 18
**Q:** What infrastructure does Autonomous DB run on?
**Options:**
A. Virtual Machines
B. Oracle Exadata
C. Bare Metal
D. Cloud Native VMs
**✅ Answer:** B. Oracle Exadata
**Explanation:** Autonomous DB always runs on Exadata.
### Question 19
**Q:** What to do after rotating regional wallet?
**Options:**
A. Download new wallet & reconnect.
B. Apply key to backups.
C. Disconnect & change passwords.
D. Nothing needed.
**✅ Answer:** A. Download new wallet & reconnect.
**Explanation:** Clients must download updated wallet.
### Question 20
**Q:** Which two actions can be performed when DB is
stopped?
**Options:**
A. Change Admin Password
B. Update License Type
C. Start DB
D. Run SQL Queries
**✅ Answer:** A, C
**Explanation:** Password change & start possible, SQL access
unavailable.
### Question 21
**Q:** Which three are true when Autonomous Database
Serverless is stopped?
**Options:**
A. CPU billing stops.
B. SQL Developer can’t connect.
C. Queries continue running.
D. Can be restarted later.
**✅ Answer:** A, B, D
**Explanation:** Billing stops, queries halt, restart is allowed.
### Question 22
**Q:** Which three OCI resources are required for private
endpoint?
**Options:**
A. Subnet
B. Route Table
C. Virtual Cloud Network (VCN)
D. FastConnect
E. Network Security Group (NSG)
**✅ Answer:** A, C, E
**Explanation:** Subnet, VCN, NSG required. Route Table
optional.
### Question 23
**Q:** What happens when moving Autonomous DB across
compartments?
**Options:**
A. Exadata & Container DB move too.
B. No permissions needed in target compartment.
C. Backups move with DB.
D. Backups remain in original compartment.
**✅ Answer:** D. Backups remain in original compartment.
**Explanation:** Only database moves; backups stay.
### Question 24
**Q:** Which statement is correct about maintenance
operations?
**Options:**
A. Release Updates (RU) and Release Update Revisions (RUR)
allowed.
B. Only Oracle selects update type.
C. You cannot defer patches.
D. Maintenance cannot be controlled.
**✅ Answer:** A. RU and RUR allowed.
**Explanation:** Oracle allows control over update type.
### Question 25
**Q:** Which backup retention is NOT supported on Dedicated
Infra?
**Options:**
A. 7 days
B. 15 days
C. 60 days
D. 120 days
**✅ Answer:** A. 7 days
**Explanation:** 7 days not supported.
### Question 26
**Q:** Which two objects are imported using Data Pump?
**Options:**
A. Users
B. Schemas
C. Data
D. Roles
**✅ Answer:** B, C
**Explanation:** Data Pump imports schemas & data.
### Question 27
**Q:** Which are the two deployment models?
**Options:**
A. Serverless
B. Bare Metal
C. Dedicated Exadata Infrastructure
D. Cloud Native VM
**✅ Answer:** A, C
**Explanation:** Only Serverless and Dedicated Exadata.
### Question 28
**Q:** What is the minimum PITR time when cloning from
backup?
**Options:**
A. 1 hour
B. 24 hours
C. 15 minutes
D. 10 hours
**✅ Answer:** A. 1 hour
**Explanation:** PITR supported every hour.
### Question 29
**Q:** Which process generates lat/long from address?
**Options:**
A. GeoEncoder
B. GeoCoder
C. Locator
D. MapView
**✅ Answer:** B. GeoCoder
**Explanation:** Geocoder maps addresses to coordinates.
### Question 30
**Q:** Which three events are supported in OCI Events?
**Options:**
A. Terminate End
B. Update IORM Begin
C. Maintenance Begin
D. Performance Hub Alert
**✅ Answer:** A, B, C
**Explanation:** These lifecycle events are available.
### Question 31
**Q:** Which three are true for OCI alarms?
**Options:**
A. Use single interval for all alarms.
B. Tune alarms routinely.
C. Create multiple alarm metrics.
D. Select proper interval per metric.
E. Create one alarm per metric.
**✅ Answer:** B, C, D
**Explanation:** Tuning and multiple alarms recommended.
