CCNA Database Questions

Multi-Selecthard

Which THREE statements are true regarding Exadata Cloud Service architecture and capabilities? (Choose three.)

Select 3 answers

A.It combines Oracle Database software with Exadata database servers and storage servers in OCI.

B.Storage is managed using Oracle Automatic Storage Management (ASM) across high-performance smart flash and disk storage.

C.It allows you to create multiple VM clusters on a single Exadata infrastructure rack.

D.It does not support Oracle Real Application Clusters (RAC).

E.It only supports single-instance databases with no option for high availability.

AnswersA, B, C

Exadata Cloud Service runs Oracle software on dedicated Exadata database and storage server hardware.

Why this answer

Exadata Cloud Service combines Exadata hardware with Oracle Cloud automation, supporting VM clusters, Oracle RAC, and built-in storage servers.

Practice this question →

MCQeasy

Which feature of Autonomous Database allows you to create a point-in-time read-only or read-write copy of your database instantly without duplicating all the underlying physical data blocks?

A.Database Cloning

B.Database backup and restore

C.Manual RMAN duplicate command

D.Data Pump Export and Import

AnswerA

Database clones are created rapidly using storage virtualization technology.

Why this answer

Autonomous Database cloning allows you to create quick metadata-based clones (full or metadata clones) without duplicating all storage blocks initially.

Practice this question →

Multi-Selectmedium

Which TWO deployment options are available when provisioning an Oracle Autonomous Database? (Choose two.)

Select 2 answers

A.Shared Exadata Infrastructure

B.Local on-premises hypervisor virtual machines

C.Standard OCI Block Volume multi-attach storage clusters

D.Dedicated Exadata Infrastructure

E.Bare metal single-tenant instances without Exadata infrastructure

AnswersA, D

Shared infrastructure is a multi-tenant option managed entirely by Oracle.

Why this answer

Autonomous Database can be provisioned on either Shared Exadata Infrastructure or Dedicated Exadata Infrastructure.

Practice this question →

MCQhard

You are configuring a Data Guard association for an Autonomous Database on Dedicated Infrastructure. How is the Data Guard standby database provisioned and managed?

A.You enable Data Guard through the OCI Console, and OCI automatically provisions and manages the standby database.

B.You must manually configure Oracle Net listener files and run 'DGMGRL' commands from the OS command line.

C.You must back up the database to Object Storage and restore it manually as a standby in the target region.

D.Data Guard is not supported on Autonomous Database Dedicated; you must use GoldenGate instead.

AnswerA

OCI automates Autonomous Data Guard provisioning and lifecycle management.

Why this answer

On Dedicated Exadata Infrastructure, Autonomous Data Guard is enabled via the OCI Console or API by selecting the peer region, and OCI automates the provisioning and synchronization of the standby.

Practice this question →

MCQhard

You are configuring a Data Guard association for an Oracle Base Database System. You want to minimize performance impact on the primary database while ensuring zero data loss in the event of a failure. Which Data Guard protection mode should you configure?

A.Maximum Performance

B.Maximum Availability

C.Maximum Protection

D.Maximum Throughput

AnswerB

Maximum Availability provides zero data loss with automatic fallback to asynchronous mode if the standby fails.

Why this answer

Maximum Availability protection mode guarantees zero data loss (synchronous redo transport) while ensuring that if the standby is unavailable, the primary continues processing transactions asynchronously.

Practice this question →

MCQeasy

When provisioning an Exadata Database Service on Dedicated Infrastructure, what is the fundamental hardware unit that you provision first before creating database deployments?

A.Exadata Infrastructure (Rack)

B.Individual DB System node

C.Autonomous Data Warehouse instance

D.Autonomous Container Database

AnswerA

You provision the Exadata Infrastructure resource first, representing the physical hardware rack, before deploying VM clusters and databases.

Why this answer

To use Exadata Database Service on Dedicated Infrastructure, you must first provision an Exadata Cloud Infrastructure resource (the rack/hardware), and then create VM clusters and databases on it.

Practice this question →

Multi-Selectmedium

Which TWO actions can be performed on an Oracle Autonomous Transaction Processing database using the OCI Console? (Choose two.)

Select 2 answers

A.Scale up or down the number of OCPUs and storage capacity.

B.Manually configure custom standby redo log files using SQL*Plus.

C.Directly access the database server via SSH using root privileges.

D.Download the client credentials wallet (wallet.zip).

E.Modify the underlying Linux operating system kernel parameters.

AnswersA, D

You can modify OCPUs and storage dynamically through the OCI console.

Why this answer

Through the OCI Console, administrators can manage database users, scale CPU and storage resources, restart the database, and configure backups.

Practice this question →

Multi-Selecthard

Which THREE factors should you evaluate when determining whether to use an Oracle Base Database System versus Exadata Cloud Service?

Select 3 answers

A.Requirement for MySQL compatibility in the Oracle database kernel

B.Need for Exadata-specific features such as Smart Scan and Hybrid Columnar Compression

C.Whether the operating system must be Microsoft Windows or Linux

D.Workload performance, I/O throughput, and scalability requirements

E.Budget and cost constraints, as Exadata infrastructure has a higher entry cost than single VM base systems

AnswersB, D, E

Exadata features are required if leveraging Smart Scan and HCC.

Why this answer

Decision factors include workload performance/scale requirements, Advanced Exadata features like Smart Scan, and budget/cost considerations.

Practice this question →

MCQmedium

You need to back up an Oracle Base Database System to an external target or move database files manually using RMAN. Which OCI storage service is typically used as a staging area for manual RMAN backups?

A.OCI File Storage Service (FSS) NFS mount

B.OCI Object Storage

C.OCI Block Volume service attached via iSCSI

D.Local NVMe scratch disks

AnswerB

Object Storage is the standard cloud target for RMAN backup sets and database exports.

Why this answer

OCI Object Storage is used for storing RMAN backup sets when performing manual backups or database migrations.

Practice this question →

MCQmedium

Your development team needs to access an Autonomous Transaction Processing (ATP) database instance securely over the internet. What artifact must be downloaded and distributed to clients to establish a secure, encrypted connection?

A.A Client Credentials Wallet (wallet.zip) file

B.An Identity and Access Management (IAM) API signing key

C.An SSH Private Key (.ppk) file

D.A Transparent Data Encryption (TDE) master key file

AnswerA

The credentials wallet zip file is mandatory for secure connectivity to Autonomous Database via mTLS.

Why this answer

Clients connecting to an Autonomous Database require a Mutual TLS (mTLS) wallet, which contains the required SSL certificates and connection descriptors.

Practice this question →

Multi-Selecteasy

Which TWO of the following are valid deployment models for Oracle Autonomous Database in OCI?

Select 2 answers

A.Autonomous Database on Local Block Storage

B.Autonomous Database on Local On-Premises Linux Server

C.Autonomous Database on Shared Infrastructure

D.Autonomous Database on Standalone Bare Metal VM

E.Autonomous Database on Dedicated Exadata Infrastructure

AnswersC, E

Shared Infrastructure is a serverless, multi-tenant cloud deployment model.

Why this answer

Autonomous Database is available on Shared Exadata Infrastructure and Dedicated Exadata Infrastructure.

Practice this question →

MCQmedium

You are configuring security for an Oracle Base Database Service instance in a private subnet. Which OCI networking construct should you configure to allow the database to download software patches from Oracle Object Storage without traversing the public internet?

A.Internet Gateway

B.Local Peering Gateway

C.Service Gateway

D.NAT Gateway

AnswerC

A Service Gateway enables private access to Oracle services like Object Storage without exposing traffic to the internet.

Why this answer

Service Gateways allow resources in a private subnet to access Oracle services such as Object Storage privately within OCI without public internet access.

Practice this question →

MCQhard

You have an Oracle Exadata Database Service on Dedicated Infrastructure. You need to scale the storage server grid independently of the compute servers to accommodate a massive data ingestion project. How should you accomplish this?

A.Add additional storage servers (storage cells) to the Exadata infrastructure resource.

B.Migrate the database to a Bare Metal DB system with larger local NVMe drives.

C.Scale up the Exadata VM cluster shape by adding more OCPUs.

D.Attach OCI Block Storage volumes directly to the Exadata database nodes via iSCSI.

AnswerA

Exadata Dedicated allows independent scaling by adding storage servers to the infrastructure.

Why this answer

Exadata Database Service on Dedicated Infrastructure allows you to add storage servers (storage cells) independently of compute servers through the OCI console or APIs.

Practice this question →

MCQhard

You are configuring an Exadata Cloud Service (ExaCS) instance and need to ensure maximum isolation and security for your database infrastructure. Which architectural layer provides tenant isolation at the hypervisor level in ExaCS?

A.Virtual Cloud Network (VCN) security lists and network security groups

B.Storage Server Cell software zones

C.Exadata Database Vault compartment boundaries

D.Oracle VM or KVM guest virtualization (domU)

AnswerD

Virtualization using OVM or KVM isolates database server guests at the hypervisor level.

Why this answer

In Exadata Cloud Service, Oracle manages the underlying hardware, and tenant isolation is achieved using Oracle VM (OVM) or KVM-based virtualization to isolate dom0 and guest domU virtual machines.

Practice this question →

MCQhard

An architect needs to perform a point-in-time recovery (PITR) on an Oracle Base Database Service DB system using the OCI Console. What is a prerequisite constraint when selecting a recovery timestamp?

A.Point-in-time recovery is only supported via SQL*Plus and cannot be initiated from the OCI Console.

B.The target timestamp must be aligned precisely with the exact minute of the last incremental backup.

C.The database must first be converted to an Autonomous Database before PITR can be executed.

D.The timestamp must be within the retention window of the automated backups and archive log backups.

AnswerD

PITR requires valid backup and archive log chains; you cannot recover to a point in time outside the retention window.

Why this answer

The target recovery time for PITR must fall within the retention period of the automated backups or within the available archive logs retained on disk or Object Storage.

Practice this question →

MCQeasy

An enterprise workload requires a fully managed Oracle Autonomous Data Warehouse with dedicated infrastructure to guarantee isolation from other tenants. Which deployment architecture should you select when provisioning this database?

A.Autonomous Data Warehouse on Dedicated Exadata Infrastructure

B.Autonomous Data Warehouse on Shared Exadata Infrastructure

C.Exadata Cloud@Customer without Autonomous operations

D.Oracle Base Database Service on Dedicated Exadata

AnswerA

Dedicated infrastructure provides resource isolation and is specifically designed for workloads with strict security and performance requirements.

Why this answer

Autonomous Database on Dedicated Exadata Infrastructure provides a dedicated database environment that gives you an isolated Exadata infrastructure exclusively for your organization.

Practice this question →

MCQmedium

You are migrating an on-premises Oracle database to an OCI Autonomous Database using Oracle Data Pump. Which wallet-related file must be downloaded and used by the client utility to establish a secure connection to the Autonomous Database?

A.Database Connection Wallet (Credentials zip file)

B.OS-level password shadow file

C.Public SSH Key pair

D.Keystore and ciphers configuration file

AnswerA

The database connection wallet containing SSL certificates and connection descriptors is mandatory for connecting to Autonomous Database.

Why this answer

Autonomous Database requires mutual TLS (mTLS) or TLS connections, which necessitate downloading the credentials zip file (wallet) containing the keystore, truststore, and tnsnames.ora.

Practice this question →

MCQeasy

Which type of Oracle Cloud Infrastructure Database service provides full access to Oracle Database features and root access to the underlying database operating system, while OCI manages the physical hardware and hypervisor?

A.Autonomous JSON Database

B.Base Database

C.Autonomous Database

D.NoSQL Database

AnswerB

Base Database Systems give administrators full control over database settings and operating system root access.

Why this answer

Base Database Systems (DB Systems) provide full SYS/SYSTEM database privileges as well as root access to the VM or Bare Metal server OS.

Practice this question →

Multi-Selectmedium

When configuring automated backups for an Oracle Base Database System on OCI, which THREE options or parameters can you configure or customize? (Choose three.)

Select 3 answers

A.Backup window (the 2-hour daily timeframe when automated backups start)

B.Custom RMAN compression scripts written in shell script format executed via cron.

C.Backup retention period (e.g., 7 to 60 days)

D.Backup destination (OCI Object Storage bucket)

E.Manual physical block-level checksum encryption algorithms via direct OS kernel edits.

AnswersA, C, D

You can specify the preferred backup window start time for automated backups.

Why this answer

When setting up automated backups for Base DB Systems, you can define the backup destination, backup retention period, and the daily backup window start time.

Practice this question →

MCQmedium

You need to restore an Oracle Base Database System to a specific point in time using incremental backups and archived redo logs. Which tool should you use at the OS level if you are managing the recovery manually?

A.Data Pump (impdp)

B.Oracle Recovery Manager (RMAN)

C.OCI Block Storage Volume Snapshots

D.SQL*Loader

AnswerB

RMAN is the native physical backup and point-in-time recovery utility for Oracle databases.

Why this answer

Oracle Recovery Manager (RMAN) is the standard Oracle tool used for backup, restoration, and recovery of database files including datafiles, control files, and archived redo logs.

Practice this question →

MCQeasy

What is the primary benefit of using Oracle Autonomous Database's autoscaling feature for CPU and storage?

A.It automatically pauses billing when the database is idle for more than one hour.

B.It automatically converts your database from Transaction Processing to Data Warehouse workloads.

C.It automatically migrates the database to a different cloud region during high load.

D.It automatically increases OCPU or storage capacity when workload spikes, and scales down when demand drops.

AnswerD

Autoscaling dynamically adjusts compute or storage resources based on real-time needs.

Why this answer

Autoscaling allows the database to automatically allocate additional CPU or storage resources when workload demands increase, without manual intervention.

Practice this question →

MCQeasy

Which Autonomous Database deployment model runs on dedicated Exadata infrastructure residing in a customer's OCI tenancy, providing maximum isolation?

A.Exadata Cloud at Customer (ExaCC)

B.Autonomous Database on Shared Infrastructure

C.Oracle Base Database System

D.Autonomous Database on Dedicated Exadata Infrastructure

AnswerD

Dedicated infrastructure provides isolated Exadata resources exclusively for a single tenant.

Why this answer

Autonomous Database on Dedicated Exadata Infrastructure (Autonomous Dedicated) provides a completely dedicated database environment within a dedicated Exadata rack.

Practice this question →

MCQeasy

Which type of Oracle database deployment provides full administrative privileges (SYS and SYSTEM access) at the operating system and database level in OCI?

A.Autonomous JSON Database

B.Oracle Autonomous Database

C.Oracle Database Serverless Cloud Service

D.Oracle Base Database System (Virtual Machine or Bare Metal)

AnswerD

Base DB systems give customers full root OS access and database administrator rights.

Why this answer

Base Database Systems (VM and BM) provide full root access to the OS via SSH and full DBA privileges on the database.

Practice this question →

MCQmedium

You are provisioning an Exadata Database Service on Dedicated Infrastructure and need to choose a shape that supports high performance workloads. Which option represents a valid Exadata shape family available in OCI?

A.Exadata.X9M.8

B.BM.GPU.DenseIO2.8

C.Exadata.X9M.Quarter3

D.VM.Standard2.4

AnswerA

Exadata X9M shapes follow a format such as Exadata.X9M.8 for database servers and storage servers.

Why this answer

Exadata Database Service utilizes specific hardware shapes such as X9M and X10M, categorized by quarter, half, or full racks.

Practice this question →

MCQeasy

Your development team needs to perform automated regression testing against a production copy of an Autonomous Transaction Processing (ATP) database. Which feature allows you to create a point-in-time, space-efficient copy of the production database instantly?

A.Autonomous Database Clone (Thin Clone)

B.Cross-Region Object Storage Export

C.Autonomous Database Data Guard

D.Oracle RMAN Duplicate Database

AnswerA

Cloning creates an instant, space-efficient copy of the database.

Why this answer

Autonomous Database Clones allow you to create either a full clone or a metadata-only thin clone instantly for development and testing purposes.

Practice this question →

MCQhard

You are planning disaster recovery for an Exadata Database Service on Dedicated Infrastructure. You need to configure Oracle Active Data Guard with real-time apply. What unique capability does Active Data Guard provide over standard Data Guard?wirtschaft

A.It replicates data at the block level across heterogeneous database engines (e.g., PostgreSQL to Oracle).

B.It allows read-only queries to run on the physical standby database while real-time redo apply is active.

C.It automatically shards the primary database tables across multiple standby regions.

D.It allows read-write operations on the standby database while synchronizing with the primary.

AnswerB

Active Data Guard enables read-only workloads on the standby database.

Why this answer

Active Data Guard allows the physical standby database to be open for read-only queries while simultaneously applying redo received from the primary database in real time.

Practice this question →

MCQhard

An administrator wishes to enable Autonomous Data Guard for an Autonomous Database on Dedicated Exadata Infrastructure. What is the primary benefit of enabling this feature?

A.It automatically provisions a standby database and handles failover and switchover operations to ensure high availability.

B.It allows read-write operations simultaneously on both primary and standby databases across regions.

C.It automatically shards tables across two different cloud regions to speed up write operations.

D.It reduces cloud storage billing by compressing redundant backup blocks on the standby instance.

AnswerA

Autonomous Data Guard automates standby provisioning and failover workflows for maximum availability.

Why this answer

Autonomous Data Guard provides high availability by automatically maintaining a standby database in a different availability domain or region with zero data loss protection.

Practice this question →

Multi-Selecthard

Which THREE features are supported by Oracle Base Database Service on virtual machines? (Choose three.)

Select 3 answers

A.Automated daily and weekly backups to OCI Object Storage

B.Automatic zero-downtime shard migration across tenants

C.Complete root access to the underlying compute instances

D.Oracle Data Guard configuration for high availability

E.Automatic scaling of physical server hardware racks

AnswersA, C, D

Automated backups are a core feature of Base Database Service.

Why this answer

Base Database Service on VMs supports Data Guard, automated backups, database edition changes (e.g., Enterprise to High Performance), and custom DB systems.

Practice this question →

MCQhard

You need to migrate a 10 TB Oracle Database from an on-premises data center to OCI Base Database Service with minimal downtime. Which migration tool leverages Oracle Data Guard to achieve near-zero downtime?

A.SQL Developer database copy wizard

B.Oracle Data Pump export and import

C.OCI Object Storage manual file copy using multipart uploads

D.Oracle Zero Downtime Migration (ZDM) with physical migration method

AnswerD

ZDM utilizes Oracle Data Guard under the hood to replicate data to the cloud with minimal cutover downtime.

Why this answer

Oracle Zero Downtime Migration (ZDM) automates database migrations using Data Guard for physical migrations with minimal downtime.

Practice this question →

Multi-Selecthard

Which TWO characteristics distinguish Exadata Cloud Service (ExaCS) from standard Oracle Base Database Systems?

Select 2 answers

A.Requirement to run exclusively on Windows Server operating systems

B.Exclusive reliance on standard OCI Block Volume iSCSI storage

C.Support for Hybrid Columnar Compression (HCC)

D.Inclusion of intelligent storage servers supporting Smart Scan capability

E.Inability to use Oracle Real Application Clusters (RAC)

AnswersC, D

HCC is an Exadata-specific storage feature.

Why this answer

ExaCS features specialized Exadata storage servers with Smart Scan and supports Hybrid Columnar Compression, unlike standard Base DB systems.

Practice this question →

MCQeasy

You need to deploy a traditional Oracle Database on OCI where you have complete administrative root access to the underlying operating system and database server. Which Oracle Database service should you choose?

A.OCI NoSQL Database

B.Exadata Cloud Service with Autonomous Container Databases

C.Oracle Base Database Service

D.Oracle Autonomous Database

AnswerC

Base Database Service provides full control over the database and operating system.

Why this answer

Oracle Base Database Service allows you full administrative control, including SYSDBA access and root access to the underlying virtual machine compute instances.

Practice this question →

MCQmedium

When provisioning an Oracle Base Database Service DB system, which storage management software is used underneath to provide high performance and reliable storage volumes?

A.Oracle Automatic Storage Management (ASM)

B.ZFS Storage Appliance software

C.EXT4 journaling file system

D.Linux Logical Volume Manager (LVM)

AnswerA

Oracle ASM is the built-in volume manager and file system for Oracle databases on OCI DB systems.

Why this answer

Oracle Base Database Service utilizes Oracle Automatic Storage Management (ASM) for managing database storage volumes.

Practice this question →

MCQmedium

You are scaling up an Oracle Base Database System (VM) to add more storage to your existing database data disk group (+DATA). What is the correct procedure in the OCI Console?

A.Terminate the DB system, create a larger block volume, and attach it as root.

B.Create a clone of the database to a new shape with higher storage limits.

C.Edit the DB system storage size in the OCI Console to allocate more storage.

D.Log into the OS via SSH, format a new iSCSI disk, and manually add it to the ASM disk group using SQL*Plus.

AnswerC

Editing the storage size in the console triggers automatic backend resizing and ASM expansion.

Why this answer

For Base DB systems, you can increase the storage size directly in the OCI Console, and ASM automatically recognizes and resizes the disk groups.

Practice this question →

MCQeasy

An application requires an Oracle Autonomous Database that supports complex analytical queries, reporting, and high-throughput data warehousing workloads. Which workload type should you select during provisioning?

A.JSON Database

B.APEX

C.Data Warehouse

D.Transaction Processing

AnswerC

Data Warehouse is the correct workload type for complex analytics and reporting.

Why this answer

Autonomous Data Warehouse (ADW) is optimized for data warehousing, complex analytical queries, and reporting workloads, whereas ATP is optimized for OLTP workloads.

Practice this question →

MCQmedium

You are managing an Oracle Base Database System and need to configure automated backups. By default, where does OCI store these automated backups?

A.A customer-managed File Storage Service (FSS) mount target

B.An Oracle-managed Object Storage bucket

C.The local root file system (/u01) of the database VM

D.A locally attached block volume separate from the database data disk

AnswerB

Oracle-managed Object Storage is the default repository for automated DB backups.

Why this answer

OCI stores automated backups of database systems in an Oracle-managed Object Storage bucket specific to your tenancy.

Practice this question →

MCQmedium

You are configuring a Data Guard association between a primary Oracle Base Database Service DB system and a standby DB system in a different availability domain. The primary database encounters a catastrophic failure. Which action must you perform to promote the standby database to primary using the OCI Console?

A.Perform a Switchover operation from the standby database details page.

B.Delete the Data Guard association and create a new primary database from a backup.

C.Perform a Failover operation from the standby database details page.

D.Run RMAN restore commands directly on the standby host operating system.

AnswerC

A failover operation is used during an unplanned outage of the primary database to transition the standby to the primary role.

Why this answer

In OCI Base Database Service, you perform a 'Switchover' for planned maintenance or a 'Failover' for unplanned primary outages.

Practice this question →

Multi-Selecthard

Which THREE security features are enabled by default or configurable on an Oracle Autonomous Database? (Choose three.)

Select 3 answers

A.Network Access Control Lists (ACLs) and private endpoints to restrict IP connectivity

B.Mandatory automated security patching and vulnerability updates applied by Oracle

C.Transparent Data Encryption (TDE) enabled by default for all user data

D.Manual customer management of operating system root access permissions

E.Disabling all network security controls to allow unrestricted global access

AnswersA, B, C

ACLs and private endpoints are supported to control network traffic.

Why this answer

Autonomous Database features Transparent Data Encryption (TDE), automated security patching, and network access controls like access control lists (ACLs) and private endpoints.

Practice this question →

MCQmedium

You are configuring backups for an Oracle Base Database System on OCI. You want to store automated full backups and incremental backups to OCI Object Storage. What is the default retention period you can select for automated backups when using the console?

A.Configurable retention periods such as 7, 15, 30, 45, or 60 days

B.Up to 7 days only

C.Real-time streaming backups with no retention limits

D.Exactly 365 days fixed

AnswerA

OCI allows you to choose automated backup retention periods ranging from 7 up to 60 days.

Why this answer

OCI automated database backups support configurable retention periods, commonly 7, 15, 30, 45, or up to 60 days.

Practice this question →

MCQeasy

Which database edition is required when provisioning an Oracle Base Database System if you want to use advanced features like Oracle Multitenant (up to 3 PDBs without extra cost), Data Guard, and In-Memory?

A.Personal Edition

B.Standard Edition 2 (SE2)

C.Enterprise Edition (EE)

D.Express Edition (XE)

AnswerC

Enterprise Edition provides the necessary framework for advanced database features.

Why this answer

Enterprise Edition (EE) or Enterprise Edition High Performance / Extreme Performance is required for advanced Oracle database features.

Practice this question →

Multi-Selecthard

Which TWO actions can be performed on an OCI Autonomous Database to manage or alter its compute and storage configurations after initial provisioning? (Choose two.)

Select 2 answers

A.Manually configure Oracle Grid Infrastructure clusterware parameters on the underlying cluster nodes.

B.Scale up or down the number of OCPUs without downtime.

C.Manually repartition tablespaces using raw OS mount points attached to the DB node.

D.Modify the operating system kernel parameters using root user privileges.

E.Increase the storage capacity (in TB) online without interrupting database operations.

AnswersB, E

You can scale OCPUs up or down dynamically while the database remains online.

Why this answer

Autonomous Database allows dynamic scaling of CPU OCPUs and storage capacity on-the-fly without requiring database restarts or downtime.

Practice this question →

MCQmedium

You are managing an Autonomous Database instance on shared infrastructure and need to restrict database access so that only clients connecting from a specific Corporate CIDR block (e.g., 192.168.10.0/24) can connect. How should you implement this?

A.Modify the SQL*Net configuration file (sqlnet.ora) stored in the database home.

B.Deploy an OCI Web Application Firewall (WAF) policy in front of the database port.

C.Attach a VCN Security List directly to the Autonomous Database service endpoint IP.

D.Configure an Access Control List (ACL) specifying the allowed IP CIDR block in the OCI Console.

AnswerD

ACLs limit incoming network traffic to specified IP addresses or VCNs.

Why this answer

Autonomous Database allows you to configure Access Control Lists (ACLs) using IP notations or Virtual Cloud Networks to restrict network access.

Practice this question →

Multi-Selecthard

Which THREE actions occur during a Data Guard switchover operation for an Oracle Base Database System?

Select 3 answers

A.The standby database is promoted to the primary role.

B.The database files are permanently deleted from the original primary server.

C.The Virtual Cloud Network (VCN) peering connection is automatically deleted.

D.The primary database transitions to a standby role.

E.Zero data loss is guaranteed because all uncommitted redo is transmitted and applied.

AnswersA, D, E

The standby takes over read-write operations.

Why this answer

During a switchover, roles are swapped gracefully without data loss, the primary becomes a standby, and the standby becomes the primary.

Practice this question →

MCQmedium

You are managing an Oracle Base Database System and need to patch the database home and operating system. Which utility is provided by Oracle in OCI to automate and orchestrate database patching safely?

A.Autonomous Patching Daemon (autopatchd)

B.Oracle Enterprise Manager Cloud Control Cloud Agent only

C.YUM Package Manager

D.OCI Database Management Service and Console Patching workflow

AnswerD

OCI provides automated workflows in the console to apply patches to DB homes and OS components.

Why this answer

OCI provides built-in database management tools, specifically the OCI Console workflow and DBaaS CLI (dbaascli), to apply database and grid infrastructure patches.

Practice this question →

Multi-Selectmedium

Which THREE tools or methods can be used to load data into an Oracle Autonomous Database?

Select 3 answers

A.DBMS_CLOUD PL/SQL package (loading files from OCI Object Storage)

B.Direct raw disk block editing via FTP

C.Database Actions (SQL Developer Web data loading interface)

D.Oracle Data Pump (impdp)

E.Direct OS command line piping via 'cat' and SSH

AnswersA, C, D

DBMS_CLOUD provides procedures to load data directly from Object Storage.

Why this answer

Data can be loaded into Autonomous Database using Oracle Data Pump, Database Actions (SQL Developer Web), and DBMS_CLOUD PL/SQL package from Object Storage.

Practice this question →

MCQeasy

Which feature of Oracle Autonomous Database automatically inspects and tunes SQL statements, creates indexes, and optimizes execution plans without human intervention?

A.Oracle Enterprise Manager Tuning Pack

B.Database Resource Manager

C.Automatic Storage Management (ASM)

D.Automatic Indexing and SQL Tuning Advisor

AnswerD

Autonomous database features self-driving indexing and query optimization.

Why this answer

Autonomous Database includes built-in automated SQL tuning and indexing capabilities as part of its self-tuning architecture.

Practice this question →

Multi-Selecthard

When configuring database backups in Oracle Base Database Service, which THREE components or options can be managed or customized? (Choose three.)

Select 3 answers

A.Automated backup retention period between 7 and 60 days

B.Automatic deletion of backup files immediately after database shutdown

C.The time window during which daily automated backups start

D.Manual full or incremental backups stored in Oracle Object Storage

E.Direct replication of backup files to local customer tape drives

AnswersA, C, D

Backup retention can be configured anywhere from 7 to 60 days.

Why this answer

In Base Database Service, administrators can configure backup destinations (Object Storage), automated backup retention windows, and manual backup schedules.

Practice this question →

Multi-Selecteasy

Which THREE features are automatically managed by Oracle Autonomous Database without requiring manual DBA intervention?

Select 3 answers

A.Business requirement definition and data modeling

B.Performance tuning and indexing

C.Automated backups

D.Database patching and upgrades

E.Custom corporate application code development

AnswersB, C, D

Autonomous tuning and indexing optimize query performance automatically.

Why this answer

Autonomous Database automates patching, backups, and performance tuning.

Practice this question →

MCQeasy

When provisioning an Autonomous Database, what parameter determines the initial compute and storage capacity allocated to the database, which can be scaled independently later?

A.Block volume IOPS and Throughput MB/s

B.Number of database threads and PGA memory limits

C.RAM size in Gigabytes and CPU core clock speed

D.OCPU count and Storage size in Terabytes

AnswerD

Autonomous Database capacity is defined by OCPUs and storage TBs.

Why this answer

Autonomous Database compute is measured in OCPUs (Oracle CPUs), and storage is measured in terabytes (TB).

Practice this question →

MCQhard

You have configured an Oracle Data Guard association between a primary Autonomous Database and a standby Autonomous Database. What happens to the standby database if the primary database experiences an unplanned regional outage?

A.The standby database remains permanently read-only and cannot accept write transactions.

B.The standby database automatically destroys itself and reprovisions in the primary region.

C.You can perform a failover operation in the OCI Console to promote the standby database to primary.

D.Data Guard automatically switches back to the primary database via split-brain prevention algorithms.

AnswerC

Manual or automated failover promotes the standby database to accept read-write traffic.

Why this answer

In Autonomous Database Data Guard, if the primary goes down, you can manually initiate a role transition (switchover/failover) or rely on automatic failover depending on the configuration, promoting the standby to primary.

Practice this question →

MCQhard

You manage an Autonomous Database instance and want to configure Auto-Scaling for storage. What is the behavior of storage auto-scaling when enabled?

A.It scales down storage during low usage windows to reduce monthly cloud billing.

B.It automatically deletes old backups to free up block storage when thresholds are reached.

C.It automatically adds OCPUs whenever storage utilization exceeds 80 percent.

D.It automatically expands storage space as needed without user intervention, up to three times the base storage size.

AnswerD

Storage auto-scaling dynamically increases storage up to 3x the specified space without requiring manual resizing.

Why this answer

When storage auto-scaling is enabled, Autonomous Database automatically increases storage space as your data grows, up to 3 times the initial allocated size.

Practice this question →

Multi-Selecthard

Which THREE features are provided natively by Exadata Cloud Service to deliver high performance and high availability for Oracle databases? (Choose three.)

Select 3 answers

A.Automatic translation of PL/SQL code into native AWS Redshift SQL syntax.

B.Oracle Real Application Clusters (RAC) support for database high availability.

C.Exadata Smart Scan to offload SQL query processing to storage servers.

D.RDMA over Converged Ethernet (RoCE) network fabric for ultra-low latency internal cluster interconnects.

E.Client-managed hypervisor patching via direct SSH access to Dom0 dom0 hypervisor nodes.

AnswersB, C, D

Exadata natively supports multi-node RAC configurations for continuous database availability.

Why this answer

Exadata Cloud Service leverages Smart Scan (offloading SQL processing to storage cells), Exadata RDMA over Converged Ethernet (RoCE) for ultra-low latency cluster communication, and built-in database high availability through RAC.

Practice this question →

MCQeasy

When connecting securely to an Autonomous Database instance, what file must be downloaded from the OCI Console and provided to your database client applications?

A.An SSH private key (.pem)

B.Client Credentials Wallet (wallet.zip)

C.Oracle Wallet Manager Master Encryption Key

D.tnsnames.ora configuration text file only

AnswerB

The client credentials wallet contains the certificates and connection details needed for secure mTLS connection.

Why this answer

Autonomous Database requires mutual TLS (mTLS) authentication by default, which is established using credentials packaged in a Wallet zip file.

Practice this question →

MCQhard

You are designing a high availability architecture for a mission-critical Oracle Exadata Database Service. You need to ensure zero data loss and minimal downtime during planned hardware maintenance. Which Oracle feature should you leverage?

A.Rolling infrastructure maintenance combined with Real Application Clusters (RAC) and Data Guard

B.Manual database export using Data Pump during the maintenance window

C.OCI Load Balancer health checks with DNS failover

D.Cold backups taken right before maintenance window execution

AnswerA

RAC provides node-level high availability, Data Guard provides DR, and rolling maintenance allows zero-downtime patching.

Why this answer

Exadata infrastructure maintenance is coordinated with Oracle Data Guard switchover or RAC rolling maintenance to ensure continuous application availability.

Practice this question →

Multi-Selectmedium

Which TWO methods can be used to connect securely to an Autonomous Database instance? (Choose two.)

Select 2 answers

A.TLS authentication without a wallet when using private endpoints configured with a keystore

B.Mutual TLS (mTLS) authentication using a downloaded credentials wallet file

C.Unencrypted plain text TCP/IP sockets on port 1521

D.Direct unauthenticated HTTP REST calls without authorization headers

E.Direct SSH tunneling through port 22 without database credentials

AnswersA, B

Wallet-less TLS connections are supported when configured on private endpoints.

Why this answer

Connections to Autonomous Database can be made using Mutual TLS (mTLS) with a credentials wallet, or through TLS without a wallet if private endpoint or TLS authentication is configured.

Practice this question →

Multi-Selectmedium

Which TWO methods can be used to connect to an Autonomous Database securely from an on-premises application server?

Select 2 answers

A.Using a downloaded client credentials wallet (mTLS connection)

B.Direct SSH tunneling through the database control plane

C.Unencrypted Telnet connection over port 1521

D.Anonymous FTP file transfer into the database home

E.Using TLS authentication with a private endpoint and hostname without a wallet

AnswersA, E

Wallet-based mTLS is the standard secure connection method.

Why this answer

Autonomous Database supports mutual TLS (mTLS) via downloaded wallets and TLS connections using private endpoints or database names.

Practice this question →

MCQmedium

An administrator needs to scale up CPU cores for an existing Oracle Autonomous Transaction Processing database without causing application downtime. Which feature of Autonomous Database allows this?

A.Database migration via Oracle Zero Downtime Migration tool

B.Manual resizing through operating system configuration files

C.Autonomous Database Elastic Resource Scaling

D.Database cloning

AnswerC

Elastic resource scaling enables automatic or manual scaling of compute and storage online with zero downtime.

Why this answer

Autonomous Database supports online scaling of both CPU OCPUs and storage capacity without interrupting running workloads.

Practice this question →

MCQmedium

An application running on OCI requires an Autonomous Transaction Processing (ATP) database with the ability to automatically scale compute resources up and down based on workload demand, without manual intervention. Which feature should you enable during or after database provisioning?

A.Dynamic Scaling Policy

B.Compute Autoscaling Groups

C.Auto Scaling

D.Elastic Resource Pools

AnswerC

Auto Scaling automatically allows the system to use additional CPU and storage resources when workload increases.

Why this answer

Auto Scaling allows the database to use up to three times the base CPU and memory resources when demand requires it, billing only for the resources actually consumed.

Practice this question →

MCQhard

You are deploying an Exadata Cloud Service instance and need to configure separate Virtual Machine clusters on the same Exadata rack. Which architectural feature enables this separation?

A.OCI Compartment boundaries

B.Exadata VM Clusters

C.Oracle Multitenant container databases with PDB isolation

D.Dynamic Routing Gateways (DRG)

AnswerB

Exadata VM clusters allow you to partition a single Exadata infrastructure rack into multiple isolated virtual machine environments.

Why this answer

Exadata Cloud Service allows multiple independent Grid Infrastructure homes and database homes by deploying multiple VM clusters on a single Exadata infrastructure rack.

Practice this question →

MCQhard

You are setting up Oracle Data Guard between a primary Base Database System in the us-ashburn-1 region and a standby database in the us-phoenix-1 region. Which networking configuration is mandatory to enable redo transport across regions?

A.A Public Load Balancer fronting the standby database listener

B.Configuring a Dynamic Routing Gateway (DRG) and Remote VCN Peering between the regions

C.Enabling NAT gateways in both regions to route private database redo packets

D.Installing an IPSec VPN appliance directly on the database node operating systems

AnswerB

Remote VCN peering via DRGs is necessary for secure, private cross-region IP connectivity.

Why this answer

Cross-region Data Guard requires Remote VCN Peering or DRG attachments with appropriate security list rules allowing traffic on listener ports (e.g., port 1521) between the primary and standby subnets.

Practice this question →

MCQhard

You are configuring Data Guard between two Exadata Cloud Service instances across different OCI regions. Which network component is mandatory to facilitate redo transport securely across regional boundaries?

A.OCI API Gateway

B.An Internet Gateway with public IP addresses

C.Remote VCN Peering

D.Local VCN Peering gateway

AnswerC

Remote VCN Peering connects VCNs across different regions, allowing secure IP communication for Data Guard redo transport.

Why this answer

Cross-region Data Guard communication requires secure network connectivity, typically achieved using Remote VCN Peering or an Oracle Cloud Infrastructure FastConnect / VPN connection between virtual cloud networks.

Practice this question →

MCQhard

You are planning a Disaster Recovery strategy for an Oracle Base Database System using Oracle Data Guard on OCI. You need the standby database to be open in read-only mode for reporting queries while simultaneously applying redo data from the primary database. Which Data Guard mode should you configure?

A.Snapshot Standby

B.Active Data Guard

C.Logical Standby in read-write mode

D.Traditional Physical Standby (Mount mode)

AnswerB

Active Data Guard allows the physical standby database to be open in read-only mode for queries and reporting while receiving redo apply.

Why this answer

Active Data Guard enables physical standby databases to be open for read-only queries while performing real-time apply of redo from the primary database.

Practice this question →

Multi-Selecteasy

Which TWO storage options are available when provisioning an Oracle Base Database System?

Select 2 answers

A.Google Cloud Persistent Disk

B.Local floppy disk drives

C.Amazon S3 object storage buckets

D.OCI Block Volume storage managed via Automatic Storage Management (ASM)

E.Local NVMe storage (available on specific Bare Metal shapes)

AnswersD, E

Base DB systems use OCI block volumes organized into ASM disk groups.

Why this answer

Base Database Systems in OCI support Grid Infrastructure with ASM on OCI Block Volume storage, and Bare Metal systems also feature local NVMe drives.

Practice this question →

Multi-Selectmedium

Which TWO tasks can an administrator perform when managing database homes in Oracle Base Database Service? (Choose two.)

Select 2 answers

A.Apply Database Updates (Database Software Patches) to the DB home.

B.Modify the underlying physical CPU hardware model of the hypervisor.

C.Delete the DB home while keeping all associated databases running unaffected.

D.Convert the database home into an Autonomous Container Database.

E.Create multiple databases within the same database home if they share the same software version.

AnswersA, E

Patching is managed at the DB home level in Base Database Service.

Why this answer

Database homes in Base Database Service allow administrators to apply quarterly database patches (RU/RUR) and create multiple databases using the same software version.

Practice this question →

MCQmedium

You are planning to restore an Oracle Base Database Service DB system from an object storage backup. Which backup types are supported by OCI for creating a new DB system?

A.OCI Block Volume snapshots

B.Only incremental manual backups

C.Only Data Pump export dump files

D.Automated backups or manual full backups

AnswerD

You can launch a new DB system using either automated backups or manual full backups created via the console or RMAN.

Why this answer

OCI Base Database Service allows you to restore a database from either automated backups or manual full backups stored in Object Storage.

Practice this question →

Multi-Selecthard

Which TWO mechanisms are used by OCI Database backup services to ensure data consistency and integrity during backups of Oracle Base Database Systems?

Select 2 answers

A.Third-party FTP mirroring of the /etc/passwd file

B.Oracle Recovery Manager (RMAN) backup validation and incremental backup integration

C.OCI Block Volume crash-consistent and point-in-time snapshot mechanisms

D.Manual SQL*Plus file copy commands while the database is in read-write mode

E.Automatic conversion of all database files to CSV format prior to backup

AnswersB, C

RMAN ensures database-level logical and physical block consistency.

Why this answer

Database backups use Oracle RMAN for physical block-level consistency and OCI Block Volume snapshots for disk-level consistency.

Practice this question →

MCQhard

You are troubleshooting a slow-running query on an Exadata Cloud Service database. You suspect that smart scan is not being utilized by the storage cells. Which Exadata feature enables offloading SQL processing operations like filtering and projections directly to the storage servers?

A.Oracle Database In-Memory Column Store

B.Exadata Smart Scan (Storage Offload)

C.Hybrid Columnar Compression (HCC)

D.Automatic Storage Management (ASM) Mirroring

AnswerB

Smart Scan offloads query filtering and processing to the Exadata storage servers.

Why this answer

Exadata Smart Scan (Storage Index and Offload processing) offloads database query processing tasks from the database compute nodes to the Exadata storage cells.

Practice this question →

Multi-Selecteasy

Which TWO editions of Oracle Database are generally available for provisioning when creating an Oracle Base Database System in OCI?

Select 2 answers

A.Standard Edition 2 (SE2)

B.Enterprise Edition (EE)

C.Oracle Database Lite Edition

D.Oracle Database Express Edition (XE) Cloud Managed

E.Community Edition SQL Server

AnswersA, B

SE2 is a supported database edition for Base DB systems.

Why this answer

OCI Base Database Systems support Standard Edition 2 and Enterprise Edition.

Practice this question →

MCQhard

You are managing an Oracle Base Database System (DB System) on OCI and need to minimize downtime during a planned operating system patching cycle. Which action should you perform to achieve this for a 2-node RAC DB System?

A.Apply the patch simultaneously to both nodes to ensure the cluster remains synchronized.

B.Take a full manual backup, terminate the DB System, and reprovision with the new patched image.

C.Perform a rolling patch on one node at a time using the OCI console or CLI.

D.Convert the 2-node RAC to a Single Instance database, patch it, and convert it back.

AnswerC

Rolling patches allow you to patch one database home or node at a time, keeping the other node operational and ensuring zero downtime.

Why this answer

For a 2-node RAC DB System, patching is performed in a rolling fashion node by node to maintain high availability and minimize downtime.

Practice this question →

Multi-Selectmedium

Which THREE operations can be performed on an Oracle Base Database System from the OCI Console?

Select 3 answers

A.Modify the operating system kernel source code

B.Scale storage size

C.Directly modify Oracle internal data dictionary tables

D.Create manual backups

E.Apply database and grid infrastructure patches

AnswersB, D, E

You can scale storage directly from the OCI Console.

Why this answer

From the OCI Console, you can scale storage, patch database homes, and create manual backups.

Practice this question →

Multi-Selectmedium

Which THREE network components must be correctly configured in a VCN to allow an application instance in a private subnet to connect to an Autonomous Database with a private endpoint?

Select 3 answers

A.Security lists or network security groups allowing traffic on port 1522

B.DNS configuration to resolve the private IP address of the database endpoint

C.An Internet Gateway attached to the private subnet

D.A Public Load Balancer fronting the private IP address

E.A subnet designated for the Autonomous Database private endpoint

AnswersA, B, E

Autonomous Database uses port 1522 for mTLS / TLS connections.

Why this answer

Private endpoints require a subnet in the VCN, appropriate security rules, and DNS resolution/service gateways or VCN peering if accessing across VCNs.

Practice this question →

MCQmedium

You are managing an Oracle Base Database System and need to configure automated backups to retain backups for a custom period (e.g., 60 days). Where can you configure this retention period?

A.By modifying retention rules on Object Storage lifecycle policies

B.In the DB system backup configuration settings within the OCI Console

C.Backup retention is fixed at 30 days and cannot be modified.

D.By editing the 'init.ora' parameter file using SQL*Plus

AnswerB

Backup retention policies (such as 7 to 60 days) are configured in the DB system backup settings.

Why this answer

In OCI Base Database Systems, you can configure automated backup retention and backup windows during creation or by editing the backup configuration in the OCI Console.

Practice this question →

MCQmedium

You are managing an Oracle Base Database System and need to secure data at rest by using your own encryption keys rather than Oracle-managed keys. Which OCI service must you integrate with the database?

A.Oracle Cloud Guard

B.OCI Vault (Key Management Service)

C.Identity and Access Management (IAM) Policies

D.OCI Object Storage Server-Side Encryption

AnswerB

OCI Vault allows customers to create and manage master encryption keys for database TDE.

Why this answer

Customer-managed encryption keys for Oracle databases in OCI are managed using OCI Vault (Key Management Service).

Practice this question →

MCQeasy

A DBA needs to configure automatic backups for an Oracle Base Database Service instance. Which retention period range is natively supported for automated backups?

A.30 days to 365 days

B.1 day to 14 days

C.7 days to 60 days

D.1 hour to 24 hours

AnswerC

OCI supports automated backup retention from 7 to 60 days for Base Database systems.

Why this answer

Oracle Base Database Service supports automated backup retention periods ranging from 7 days to 60 days.

Practice this question →

MCQmedium

You are managing an Oracle Base Database System (Virtual Machine) and need to scale up the compute shape to a higher number of OCPUs to handle an upcoming month-end processing spike. Which action should you perform?

A.Terminate the current DB system and provision a new one with the larger shape, then restore from a manual backup.

B.Stop the database instance via SQL*Plus and run the 'alter system modify shape' command.

C.Edit the DB system configuration in the OCI Console and update the OCPU count or shape directly.

D.Attach an additional block storage volume with higher performance tiers to absorb the extra compute load.

AnswerC

Editing the DB system shape or OCPU count directly is the supported method for vertical scaling.

Why this answer

For Oracle Base Database Systems, you can scale up the compute shape by modifying the OCPU core count or shape directly from the OCI Console without losing data.

Practice this question →