Courseiva

CCNA Databases Questions

50 questions · Databases · All types, answers revealed

Practice these questionsDomain overviewAll questions
1
MCQeasy

What is the primary architectural advantage of using Exadata Database Service on Dedicated Infrastructure compared to Exadata Database Service on Cloud@Customer?

A.It requires the customer to manage physical rack power, cooling, and hardware replacement
B.It exclusively supports non-relational database formats unlike Cloud@Customer
C.It eliminates the need for Virtual Cloud Networks (VCNs)
D.The physical Exadata hardware resides and operates entirely within an OCI data center managed by Oracle
AnswerD

Correct. Dedicated Infrastructure is hosted in OCI cloud regions, while Cloud@Customer is hosted on-premises.

Why this answer

Exadata Database Service on Dedicated Infrastructure runs entirely within OCI datacenters, whereas Cloud@Customer runs physically inside the customer's on-premises datacenter.

Practice this question →
2
MCQhard

An organization running an Oracle Exadata Database Service requires compliance auditing where all database administrative actions and sensitive data queries must be logged, tamper-proof, and retained in an isolated repository. Which combination of OCI and Oracle Database features provides this capability?

A.OCI Object Storage unversioned buckets with public read permissions
B.Oracle Data Safe combined with Database Unified Audit policies
C.Oracle Data Pump export logs stored in local temporary directories
D.Standard Linux syslog daemon writing to local disk partitions
AnswerB

Correct. Data Safe provides assessment, user management, and audit collection, while Unified Audit logs all database activities.

Why this answer

Oracle Audit Vault and Database Firewall (AVDF) or OCI Audit combined with Oracle Data Safe and Database Unified Audit provides robust, tamper-proof auditing and compliance reporting.

Practice this question →
3
MCQeasy

When provisioning an Oracle Base Database system on OCI, which storage management architecture is utilized by default for storing database files (datafiles, redo logs, control files)?

A.Network File System (NFS) shared mounts from a third-party NAS filer
B.Raw Device Mapping (RDM) shared via Fibre Channel SAN
C.Oracle Automatic Storage Management (ASM) configured across OCI Block Volumes
D.Local NVMe drives directly attached to the hypervisor without redundancy
AnswerC

Correct. OCI Base Databases use ASM to stripe and mirror data across high-performance OCI Block Volumes.

Why this answer

OCI Base Database systems use Oracle ASM (Automatic Storage Management) across OCI Block Volumes to manage database storage.

Practice this question →
4
MCQmedium

You are configuring an Autonomous Database instance and need to restrict incoming database traffic so that only specific corporate subnet CIDR blocks can access the database service endpoints. Which feature should you configure?

A.OCI Web Application Firewall (WAF) attached directly to the database listener port
B.OCI Identity and Access Management dynamic groups
C.Database Vault realm restrictions
D.Autonomous Database Access Control Lists (ACLs) specifying allowed IP CIDR blocks
AnswerD

Correct. ACLs restrict inbound connectivity to specified IP addresses or VCN endpoints.

Why this answer

Access Control Lists (ACLs) on Autonomous Database allow administrators to restrict network access using IP addresses or VCN OCIDs.

Practice this question →
5
Multi-Selecthard

You are designing a cross-region disaster recovery strategy for an Oracle Exadata Database Service on Dedicated Infrastructure deployment. Which TWO steps or configurations are required to establish an Active Data Guard standby database in a remote OCI region?

Select 2 answers
A.Mount a shared block storage volume across both OCI regions using Network File System (NFS).
B.Enable automatic backups on the standby database using the same retention period as the primary.
C.Configure Standby Redo Logs (SRLs) on both the primary and standby databases sized identically to the online redo logs.
D.Configure Oracle GoldenGate bidirectional replication as the underlying transport mechanism.
E.Establish network connectivity between the primary and standby VCNs using a Dynamic Routing Gateway (DRG) and local or remote VCN peering.
AnswersC, E

Standby redo logs are mandatory for real-time apply and data protection modes in Data Guard.

Why this answer

Establishing Active Data Guard across regions requires proper network peering (such as Remote VCN Peering or DRG) and configuring the databases with appropriate Data Guard association parameters and standby redo logs.

Practice this question →
6
MCQmedium

You are configuring disaster recovery for an Oracle Base Database system using Oracle Data Guard with Data Guard Broker. You need to perform a role transition where the primary database becomes the standby and the standby becomes the primary with zero data loss. Which Data Guard Broker command should you execute?

A.ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
B.CONVERT DATABASE TO PHYSICAL STANDBY;
C.SWITCHOVER TO <standby_database_name>;
D.FAILOVER TO <standby_database_name>;
AnswerC

Correct. The SWITCHOVER command performs a role reversal without data loss.

Why this answer

To perform a planned switchover with zero data loss using Data Guard Broker, the SWITCHOVER command is executed.

Practice this question →
7
Multi-Selectmedium

Which TWO actions are required when migrating an on-premises Oracle database to an Oracle Autonomous Database (Serverless) using Oracle Data Pump? (Choose two.)

Select 2 answers
A.Run the DBMS_CLOUD.PREPARE_FOR_AUTONOMOUS procedure on the source database to ensure compatibility
B.Download and configure the database connection wallet on the host executing the Data Pump utility
C.Disable Transparent Data Encryption (TDE) on the source database before export
D.Manually format all source datafiles into Oracle ASM disk groups prior to export
E.Configure a direct NFS mount between the source server and the Autonomous Database storage tier
AnswersA, B

Correct. This procedure checks and flags incompatible objects or configurations.

Why this answer

Migrating via Data Pump to Autonomous Database requires using a secure connection wallet and running pre-migration compatibility scripts.

Practice this question →
8
Multi-Selecthard

When designing a multi-database architecture with Oracle GoldenGate for high availability and load distribution, which THREE architectural considerations are critical for success? (Choose three.)

Select 3 answers
A.Routing all write transactions through a single read-only replica without replication
B.Implementing Conflict Detection and Resolution (CDR) rules for active-active multi-master topologies
C.Configuring unique primary key generation strategies (e.g., sequence offsets) to prevent key collisions
D.Managing DDL replication synchronization to ensure schema modifications match across nodes
E.Disabling all checkpointing to maximize real-time packet loss tolerance
AnswersB, C, D

Correct. CDR prevents data corruption during simultaneous writes in active-active setups.

Why this answer

GoldenGate architectures require conflict resolution, careful handling of DDL changes, and proper handling of sequences.

Practice this question →
9
MCQhard

An architect is configuring disaster recovery for an Autonomous Database (Serverless) instance using Autonomous Data Guard. The primary database resides in the US East (Ashburn) region, and the standby is in US West (Phoenix). What is the behavior of the standby database regarding read operations?

A.The standby database automatically accepts write operations and replicates them back to the primary
B.The standby database can be accessed in read-only mode for reporting and queries
C.The standby database accepts read-write transactions concurrently with the primary database
D.The standby database is completely inaccessible until a manual switchover or failover occurs
AnswerB

Correct. Autonomous Data Guard supports read-only access on the standby database.

Why this answer

Autonomous Data Guard standby databases can be opened in read-only mode to offload reporting queries from the primary database.

Practice this question →
10
Multi-Selectmedium

Which TWO methods can be used to securely connect an application running in an OCI compute instance to an Autonomous Database instance with private endpoint access enabled? (Choose two.)

Select 2 answers
A.Exposing the database via an Internet Gateway and public IP address mapping
B.Establishing an SSH tunnel through the OCI Vault key management service
C.Routing application traffic through OCI Object Storage public pre-authenticated requests
D.Using mTLS authentication with the downloaded database connection wallet
E.Using TLS authentication without a wallet (TLS) via the database private IP and service name
AnswersD, E

Correct. mTLS with a wallet is supported for private endpoints.

Why this answer

Private endpoint Autonomous Databases can be accessed via private IP addresses using mTLS with a wallet or TLS without a wallet.

Practice this question →
11
MCQmedium

You are designing a high availability disaster recovery architecture for an Oracle Base Database Service system deployed on a 2-node Virtual Machine DB System. You need to configure automated backups. Which storage destination is automatically used by OCI to store these automated backups?

A.A separate standby Oracle ASM disk group on Block Volume storage.
B.Local NVMe scratch disk attached to the primary database node.
C.OCI Object Storage bucket managed by the database service.
D.An independent File Storage Service (FSS) mount target shared across availability domains.
AnswerC

Automated backups are securely stored in Oracle-managed OCI Object Storage buckets.

Why this answer

OCI Database service automatically uses OCI Object Storage as the backend destination for all automated database backups.

Practice this question →
12
Multi-Selecthard

You are optimizing the cost and performance of an Exadata Database Service on Dedicated Infrastructure environment hosting multiple large databases. Which THREE practices should you implement to achieve optimal resource utilization and cost efficiency?

Select 3 answers
A.Consolidate multiple non-CDB databases into a single Multitenant Container Database (CDB) with multiple PDBs.
B.Configure Exadata Smart Flash Cache policies appropriately for OLTP versus DSS workloads.
C.Migrate all table data to standard Block Volume storage to bypass Exadata storage servers.
D.Disable automatic backups entirely to save OCI Object Storage costs.
E.Dynamically scale OCPU counts on the Exadata infrastructure based on peak and off-peak workload schedules.
AnswersA, B, E

Consolidation reduces overhead and maximizes resource sharing across workloads.

Why this answer

To optimize Exadata Dedicated environments, you can leverage OCPUs scaling, database consolidation into multitenant container databases, and storage server flash cache optimizations.

Practice this question →
13
Multi-Selecthard

Which THREE strategies are recommended when planning a large-scale database migration (exceeding 100 TB) from on-premises to Exadata Database Service on Dedicated Infrastructure with minimal downtime? (Choose three.)

Select 3 answers
A.Leveraging Transportable Tablespaces (TTS) combined with RMAN cross-platform conversion
B.Utilizing Oracle Zero Downtime Migration (ZDM) physical migration workflows
C.Copying database files across the public internet using standard FTP without encryption
D.Exporting the entire 100 TB database into a single plaintext SQL script using SQL*Developer
E.Configuring Oracle Data Guard or GoldenGate for ongoing delta synchronization prior to cutover
AnswersA, B, E

Correct. TTS is ideal for bulk transport of large data volumes.

Why this answer

Large-scale database migrations exceeding 100 TB benefit from transportable tablespaces, physical standby creation via RMAN, and Zero Downtime Migration (ZDM).

Practice this question →
14
MCQhard

You are configuring scaling parameters for an Autonomous Database on Dedicated Infrastructure. You need to enable automatic scaling of CPU cores to handle unpredictable traffic bursts while maintaining strict cost controls. What is the maximum CPU core auto-scaling limit for an Autonomous Container Database on Dedicated Infrastructure?

A.Exactly three times the base OCPU count provisioned for the database instance
B.An unlimited amount limited only by OCI regional capacity limits
C.Up to the total number of unallocated CPU cores available in the underlying Exadata Infrastructure instance
D.Fixed at a maximum of 128 OCPUs regardless of hardware size
AnswerC

Correct. Auto-scaling on dedicated infrastructure utilizes spare CPU capacity provisioned within the Exadata VM cluster bounds.

Why this answer

On Dedicated Infrastructure, auto-scaling for Autonomous Databases can scale up to the total number of unallocated CPU cores available in the underlying Exadata Autonomous Exadata Infrastructure instance.

Practice this question →
15
MCQmedium

You are planning to migrate an Oracle Database to OCI using Zero Downtime Migration (ZDM). Which underlying Oracle migration technology does ZDM orchestrate behind the scenes for large databases requiring physical migration?

A.OCI Object Storage lifecycle policies exclusively
B.Oracle RMAN and Oracle Data Guard
C.Third-party ETL pipelines and CSV flat file generation
D.MySQL Enterprise Backup and InnoDB replication
AnswerB

Correct. For physical migrations, ZDM automates RMAN backup/restore and Data Guard setup for near-zero downtime transitions.

Why this answer

OCI Zero Downtime Migration (ZDM) orchestrates native Oracle migration tools such as RMAN, Data Guard, and Data Pump depending on the workflow chosen (physical vs logical).

Practice this question →
16
MCQmedium

You are designing an automated backup strategy for an Exadata Database Service on Dedicated Infrastructure. You want to ensure that incremental backups are taken daily and full backups weekly, with long-term retention stored in OCI Object Storage. Where are these backup schedules configured?

A.In the OCI Console under the database system backup configuration settings or via API/CLI
B.By modifying the crontab configuration file as root on the dom0 hypervisor node
C.By editing the initialization parameter file (spfile) using SQL*Plus
D.Via Oracle Enterprise Manager Cloud Control deployed exclusively on-premises
AnswerA

Correct. OCI provides native backup management interfaces to define full and incremental backup frequencies and retention periods.

Why this answer

Backup policies and schedules for Exadata Database Service are configured directly through the OCI Console, CLI, or API under the database system backup settings.

Practice this question →
17
MCQeasy

Which Autonomous Database workload type is specifically optimized for running complex analytical queries, machine learning, and data warehousing workloads?

A.Autonomous Data Warehouse (ADW)
B.Autonomous JSON Database (AJD)
C.Autonomous Transaction Processing (ATP)
D.Autonomous Apex Application Development (APEX)
AnswerA

Correct. ADW is tailored for data warehousing and high-throughput analytical workloads.

Why this answer

Autonomous Data Warehouse (ADW) is optimized for analytical queries, reporting, and data warehousing.

Practice this question →
18
MCQeasy

Which OCI database service provides fully managed Oracle Database instances running on dedicated virtual machines with root access and granular control over operating system parameters?

A.Oracle Exadata Database Service on Dedicated Infrastructure
B.OCI NoSQL Database service
C.Oracle Autonomous Database Serverless
D.Oracle Base Database service
AnswerD

Correct. Base Database provides virtual machine or bare metal instances with full root/sudo OS access.

Why this answer

Oracle Base Database service provides virtual machine database systems with full root access and OS-level control.

Practice this question →
19
MCQeasy

Which OCI tool should a cloud architect recommend for automating the lifecycle management, patching, and backing up of a fleet of Oracle Base Database systems across multiple compartments?

A.OCI Compute Instance Scheduler
B.Oracle Cloud Infrastructure GoldenGate deployment console
C.OCI Identity and Access Management (IAM) policies
D.OCI Database Management service
AnswerD

Correct. Database Management provides fleet-wide observability, monitoring, and lifecycle administration for Oracle databases.

Why this answer

OCI Database Management service provides comprehensive monitoring, fleet management, and operational insights for Oracle databases across OCI.

Practice this question →
20
MCQmedium

You are migrating an Oracle Database to an Exadata Database Service on Dedicated Infrastructure. You need to ensure that database backups are stored securely with zero public internet exposure. What is the recommended networking architecture for backup transmission?

A.Deploy an internet gateway with IPSec VPN tunnels terminating at the backup bucket
B.Configure a Service Gateway in your VCN to access OCI Object Storage privately
C.Expose a NAT Gateway with strict IP whitelisting
D.Attach a secondary public IP address to the database VM guest nodes
AnswerB

Correct. A Service Gateway allows private routing from the VCN to OCI Object Storage without public IP addresses.

Why this answer

OCI services like Database backups communicate via Service Gateways or Private Endpoints to prevent traversing the public internet.

Practice this question →
21
MCQmedium

You are designing a high-availability architecture for an Oracle Base Database system across two Availability Domains (ADs) within a single OCI region. Which multi-database HA pattern ensures automatic failover with minimal data loss?

A.Oracle Data Guard configured between primary and standby database instances across ADs
B.Periodic RMAN duplication scripts executed via cron jobs every hour
C.Active-Active Oracle RAC cluster spanning multiple Availability Domains over long-distance synchronous interconnects
D.Shared OCI Block Volumes mounted simultaneously by database nodes in different ADs
AnswerA

Correct. Data Guard across ADs ensures high availability and disaster recovery within a region.

Why this answer

Oracle Data Guard configured between two VMs across different Availability Domains provides high availability and automatic failover.

Practice this question →
22
MCQhard

You are configuring Oracle Data Guard between an Exadata Database Service on Dedicated Infrastructure primary database and a remote standby database in another OCI region. To ensure maximum performance with zero data loss risk under normal operations, which Data Guard protection mode and transport setting should you configure?

A.Maximum Protection mode with SYNC and AFFIRM transport.
B.Maximum Availability mode with SYNC transport and NOAFFIRM.
C.Maximum Availability mode with ASYNC transport and ARCHivelog compression.
D.Maximum Performance mode with ASYNC transport.
AnswerA

Maximum Protection mode with SYNC and AFFIRM ensures redo is written to the standby disk before the primary transaction commits, guaranteeing zero data loss.

Why this answer

Maximum Protection mode guarantees zero data loss (Zero Data Loss architecture) by ensuring transactions do not commit until the redo data is written to the standby redo log files on at least one synchronized standby database.

Practice this question →
23
Multi-Selecteasy

Which TWO backup destinations are natively supported when configuring automated backups for Oracle Base Database systems on OCI? (Choose two.)

Select 2 answers
A.OCI Object Storage Archive tier (for long-term retention policies)
B.Local unformatted swap partitions on the database host
C.OCI Object Storage (Standard tier buckets)
D.Public GitHub code repositories
E.Local USB flash drives plugged into the database VM guest node
AnswersA, C

Correct. Archive storage is supported for long-term backup retention.

Why this answer

Base Database systems support backups directly to OCI Object Storage (Standard bucket) or OCI Object Storage Classic / Archive storage tiers.

Practice this question →
24
MCQhard

An enterprise is implementing a multi-database architecture utilizing Oracle GoldenGate microservices on OCI Compute instances to replicate data between an operational Exadata database and an analytical Autonomous Data Warehouse. Which network security construct must be configured to allow communication between the GoldenGate deployment and the Autonomous Database instance?

A.Configure VCN security lists or Network Security Groups (NSGs) allowing outbound TCP port 1522 and inbound mTLS traffic, and supply the ADB wallet
B.Expose an API Gateway with public IP routing directly to the database undo tablespace
C.Configure a Local Peering Gateway with remote VCN route tables pointing to port 22
D.Attach an Internet Gateway directly to the Autonomous Database private IP address
AnswerA

Correct. Port 1522 is standard for Autonomous Database TCPS/mTLS connections, requiring appropriate NSG rules and the client wallet.

Why this answer

Autonomous Database requires mTLS connections and specific egress/ingress rules; when using GoldenGate to connect to Autonomous Database, the GoldenGate subnet must allow outbound traffic and connect using the appropriate wallet and port 1522.

Practice this question →
25
MCQhard

An enterprise application running on Exadata Database Service on Dedicated Infrastructure experiences severe I/O contention due to a noisy neighbor batch reporting job. Which Exadata storage feature should you configure to isolate and guarantee I/O resources for critical online transaction processing (OLTP) workloads?

A.Exadata I/O Resource Management (IORM) with database-level resource plans
B.OCI Block Volume performance tiers (Higher VPU settings)
C.Autonomous Database concurrency limits in the OCI console
D.OCI Compute Auto-scaling configurations on the domU guest VMs
AnswerA

Correct. IORM manages and prioritizes I/O requests across multiple databases sharing the same Exadata storage cells.

Why this answer

Exadata Storage Server Resource Management (IORM) allows administrators to allocate I/O resource shares and limit bandwidth consumption for specific database workloads or consumer groups.

Practice this question →
26
Multi-Selecthard

Which THREE features are unique or heavily enhanced capabilities of Oracle Exadata Database Service on Dedicated Infrastructure compared to standard OCI Base Database systems? (Choose three.)

Select 3 answers
A.Native support for attaching external Microsoft Azure Blob Storage containers as ASM disk groups
B.Automatic index creation managed entirely by the local Linux kernel swap daemon
C.Exadata Storage Server Resource Management (IORM) for fine-grained I/O prioritization
D.Exadata Smart Flash Cache and Persistent Memory (PMEM) integration for ultra-low latency I/O
E.Exadata Smart Scan offloading database query processing to storage servers
AnswersC, D, E

Correct. IORM manages and prioritizes storage I/O across databases sharing Exadata cells.

Why this answer

Exadata Database Service offers unique architectural features such as Smart Scan, persistent memory flash cache, and IORM.

Practice this question →
27
Multi-Selectmedium

When planning a migration of Oracle databases to Oracle Autonomous Database (Serverless), which THREE migration methods or tools are natively supported or recommended by Oracle?

Select 3 answers
A.Oracle SQL Developer migration workbench / Data Loading features.
B.Oracle Zero Downtime Migration (ZDM) service.
C.Directly attaching on-premises ASM disk groups via iSCSI to the Autonomous container.
D.Oracle Data Pump (import/export).
E.Direct physical RMAN full database restore to Autonomous storage.
AnswersA, B, D

SQL Developer supports data loading and schema migration to Autonomous Database.

Why this answer

Autonomous Database Serverless supports specific migration paths including Oracle Zero Downtime Migration, Data Pump, and SQL Developer migration assistants.

Practice this question →
28
Multi-Selecteasy

Which TWO tools or interfaces can administrators use to manage Oracle Autonomous Database instances in OCI? (Choose two.)

Select 2 answers
A.Local floppy disk drive image uploads
B.Windows Remote Desktop Connection (RDP) to the Autonomous database hypervisor
C.Direct physical serial console cable attached to Exadata rack blades
D.OCI Command Line Interface (CLI) and REST APIs
E.Oracle Cloud Infrastructure (OCI) Console
AnswersD, E

Correct. CLI and APIs enable programmatic management.

Why this answer

Autonomous Database can be managed via the OCI Console and the OCI CLI/API.

Practice this question →
29
MCQhard

You are planning to migrate a large, mission-critical Oracle Database (12.1.0.2) on-premises to Exadata Database Service on Dedicated Infrastructure in OCI. The migration requires minimal downtime and must handle cross-endian platform conversion since the source is IBM AIX. Which migration tool and strategy combination is most appropriate?

A.Oracle Zero Downtime Migration (ZDM) with physical online migration workflow.
B.Oracle GoldenGate for real-time replication with initial load via datapump.
C.Oracle Data Pump transportable tablespaces with RMAN cross-platform incremental backup.
D.Standard RMAN backup and restore directly from an on-premises NFS mount to OCI Object Storage.
AnswerC

RMAN cross-platform incremental backup handles the endian conversion of datafiles efficiently, while Data Pump transports metadata, ensuring minimal downtime.

Why this answer

For cross-endian migrations of large databases with minimal downtime, Oracle Data Pump transportable tablespaces combined with Cross-Platform Incremental Backup using RMAN is the recommended and most efficient approach.

Practice this question →
30
MCQeasy

What is the primary benefit of using OCI Autonomous Database Serverless compared to Provisioned (Dedicated) infrastructure regarding database administration?

A.Oracle fully automates all patching, tuning, scaling, and provisioning with zero infrastructure management required
B.Customers must manually configure Exadata cell software versions
C.Serverless databases do not support automated backups
D.Customers are required to manually apply quarterly database security patches
AnswerA

Correct. Serverless abstracts all underlying infrastructure management, leaving database administration entirely automated.

Why this answer

Autonomous Database Serverless fully automates infrastructure provisioning, tuning, patching, and scaling without requiring manual management of VMs or Exadata hardware.

Practice this question →
31
Multi-Selectmedium

Which TWO network security features can be applied to an Oracle Base Database system on OCI to protect database traffic and restrict access? (Choose two.)

Select 2 answers
A.Oracle Database Firewall and Audit Vault (AVDF) integration
B.Disabling all VCN route tables to block internal routing
C.OCI Web Application Firewall (WAF) applied directly to SQL port 1521
D.Virtual Cloud Network (VCN) Security Lists and Network Security Groups (NSGs)
E.Exposing database ports directly to the public Internet with default security lists
AnswersA, D

Correct. AVDF inspects and blocks unauthorized SQL traffic.

Why this answer

Base Database systems can be protected using Virtual Cloud Network (VCN) Security Lists / Network Security Groups (NSGs) and database-level firewalls.

Practice this question →
32
Multi-Selecteasy

Which TWO editions of Oracle Database are available when deploying an Oracle Base Database system on OCI? (Choose two.)

Select 2 answers
A.Oracle Database Micro Edition (ME)
B.Oracle Database Enterprise Edition (EE)
C.Oracle Database Web Edition (WE)
D.Oracle Database Standard Edition 2 (SE2)
E.Oracle Database Personal Edition (PE)
AnswersB, D

Correct. EE is a supported base database edition.

Why this answer

Standard Edition 2 and Enterprise Edition are core editions available for Oracle Base Database systems.

Practice this question →
33
MCQeasy

Your development team needs to scale up CPU cores for an Autonomous JSON Database instance dynamically without restarting the application or causing downtime. Which feature should you use?

A.Auto-scaling with Oracle Data Guard switchover.
B.OCI Compute Instance resizing via instance pool configuration.
C.Manual cold restart of the container database.
D.Autonomous Database Elastic Resource Scaling.
AnswerD

Elastic Resource Scaling enables online scaling of CPU and storage resources immediately without downtime.

Why this answer

Autonomous Database supports Elastic Resource Scaling, allowing users to scale CPU and storage independently and online without any database downtime.

Practice this question →
34
MCQhard

An organization is designing a disaster recovery strategy using Exadata Database Service on Dedicated Infrastructure. They require an Recovery Time Objective (RTO) of less than 30 seconds and a Recovery Point Objective (RPO) of zero for an enterprise database handling mission-critical workloads. Which Data Guard configuration should be implemented?

A.Oracle Active Data Guard configured in Maximum Protection mode with synchronous transport
B.Manual RMAN backup replication via OCI Object Storage every 15 minutes
C.Oracle Data Guard configured in Maximum Performance mode with asynchronous transport
D.Oracle GoldenGate real-time replication with asynchronous extract configurations
AnswerA

Correct. Maximum Protection mode ensures zero data loss (RPO = 0) by syncing redo to the standby before committing transactions on the primary.

Why this answer

To achieve an RPO of zero and ultra-low RTO for mission-critical Exadata workloads, Oracle Data Guard should be configured in Maximum Protection mode with synchronousredo transport across Availability Domains or regions.

Practice this question →
35
MCQmedium

An architect is designing an Oracle Autonomous JSON Database instance to store flexible document workloads. Which feature is automatically enabled on Autonomous JSON Database that distinguishes it from general-purpose Autonomous Transaction Processing instances regarding storage management?

A.Automatic conversion of all JSON documents into relational third-normal-form tables upon ingestion
B.Mandatory requirement to define fixed database schemas via JSON Schema validators before inserting data
C.Storage and indexing are specifically optimized for JSON collections with restrictions on non-JSON relational tables
D.Exclusion of automated backups to reduce operational overhead
AnswerC

Correct. Autonomous JSON Database is optimized exclusively for JSON data models, offering lower cost per terabyte for document stores with specific usage boundaries.

Why this answer

Autonomous JSON Database provides optimized storage and indexing specifically for JSON collections, allowing schema-less storage while maintaining relational capabilities, but restricts the creation of non-JSON relational tables.

Practice this question →
36
MCQmedium

An enterprise application running on Oracle Autonomous Transaction Processing (ATP) requires dedicated infrastructure isolation for compliance reasons. You need to provision an Autonomous Database on Dedicated Exadata Infrastructure. Which architectural step is mandatory before you can provision the database instance?

A.Contact Oracle Support to manually allocate physical rack boundaries in your tenancy region.
B.Create an Autonomous Exadata Infrastructure resource in your compartment and virtual cloud network.
C.Create a Pluggable Database (PDB) manually via SQL*Plus on an existing multitenant container database.
D.Provision a standard Exadata Cloud Service cluster using the Database management service console.
AnswerB

An Autonomous Exadata Infrastructure resource must be created first to define the Exadata rack allocation within your VCN and subnet before creating Autonomous Container Databases and Autonomous Databases.

Why this answer

Before provisioning an Autonomous Database on Dedicated Exadata Infrastructure, you must first create an Autonomous Exadata Infrastructure resource within a specific availability domain or fault domains, which reserves the underlying compute and storage resources.

Practice this question →
37
Multi-Selecthard

When designing a high-availability and disaster recovery architecture for an enterprise Oracle Database on OCI, which THREE components or patterns are crucial for achieving optimal recovery and uptime? (Choose three.)

Select 3 answers
A.Automated and policy-driven backups to OCI Object Storage with cross-region replication
B.Relying solely on local ephemeral NVMe drive snapshots for disaster recovery
C.Oracle Data Guard standby database in a remote region for disaster recovery
D.Stretching a single-node database VM across distinct cloud regions using unencrypted NFS mounts
E.Oracle Real Application Clusters (RAC) across fault domains or availability domains for local HA
AnswersA, C, E

Correct. OCI backups to Object Storage with replication ensure long-term retrievability.

Why this answer

Enterprise HA/DR patterns for Oracle databases on OCI involve Data Guard, Real Application Clusters (RAC), and automated backup strategies.

Practice this question →
38
MCQeasy

You need to migrate a 50 TB Oracle Database from on-premises to Exadata Database Service on Dedicated Infrastructure with minimal downtime. The source database is operating on AIX and uses big-endian architecture, while OCI Exadata runs on little-endian Linux. Which migration method handles cross-platform endian conversion most efficiently?

A.Direct database clone via SQL*Developer migration wizard
B.Oracle GoldenGate initial load using SQL direct paths
C.RMAN Transportable Tablespaces with cross-platform data file conversion
D.Standard Oracle Data Pump export and import over direct database links
AnswerC

Correct. RMAN CONVERT DATAFILE handles endian format conversion natively during transportable tablespace migrations.

Why this answer

Transportable Tablespaces with RMAN CONVERT DATAFILE provide the most efficient method for cross-platform migrations when endianness differs between source and target architectures.

Practice this question →
39
MCQeasy

You are provisioning an Autonomous Data Warehouse (ADW) instance and want to configure network access so that only specific corporate IP addresses can connect to the database. Which feature should you enable?

A.Autonomous Database Access Control Lists (ACLs).
B.Virtual Cloud Network (VCN) Security Lists only.
C.OCI Web Application Firewall (WAF) rule sets.
D.OCI Identity and Access Management (IAM) dynamic groups.
AnswerA

ACLs restrict public IP access to specific allowed ranges on public Autonomous Database endpoints.

Why this answer

Access Control Lists (ACLs) allow you to restrict access to your Autonomous Database by specifying allowed IP addresses or CIDR blocks.

Practice this question →
40
MCQhard

You are configuring transparent data encryption (TDE) for an Oracle Database on Exadata Database Service using OCI Vault for master encryption key management. What happens if the database loses connectivity to the OCI Vault key management service?

A.The database instantly crashes and forces an immediate failover to the standby database
B.The database automatically falls back to self-managed wallet storage without alerting administrators
C.The database continues to run using keys cached in memory for a period, but cannot be restarted until connectivity to OCI Vault is restored
D.All encrypted data files are automatically wiped to prevent security breaches
AnswerC

Correct. Cached keys allow active operations to continue temporarily, but database restart or key rotation fails without vault access.

Why this answer

If TDE master keys are stored in OCI Vault (external key management), the database can continue operating temporarily using cached keys in memory, but cannot restart or decrypt new sessions if key access remains blocked indefinitely.

Practice this question →
41
MCQmedium

Your development team wants to connect securely to an Autonomous Database (Serverless) instance using mutual TLS (mTLS) authentication. Where must the client application obtain the required credentials to establish this secure connection?

A.Download the database connection wallet zip file from the OCI Console or CLI and extract it on the client host
B.Generate a Kerberos ticket granting service token via the IAM security console
C.Retrieve the master encryption key directly from OCI Vault using an API key
D.Configure a public SSL certificate issued by Let's Encrypt in the database parameter settings
AnswerA

Correct. The mTLS wallet contains the necessary keystores, truststores, and tnsnames.ora configuration files.

Why this answer

Clients connecting via mTLS to an Autonomous Database must download the wallet file (credentials zip) generated from the OCI Console or CLI.

Practice this question →
42
MCQeasy

What is the primary purpose of OCI Database Actions (SQL Developer Web) when working with an Oracle Autonomous Database?

A.To configure physical Exadata storage cell disks and flash cache parameters
B.To monitor physical VCN packet drops and firewall logs
C.To manage OCI IAM user groups and federation settings across enterprise identity providers
D.To provide a web-based development and management interface for executing SQL, querying data, and managing database users
AnswerD

Correct. Database Actions is built directly into Autonomous Database for web-based SQL development and management.

Why this answer

OCI Database Actions provides a web-based interface for running SQL queries, developing PL/SQL, managing users, and loading data into Autonomous Database.

Practice this question →
43
MCQhard

You are designing a multi-database architecture where applications require read-scaling across different geographic regions with minimal replication lag. You decide to deploy Autonomous Data Warehouse (ADW) instances across three regions connected via GoldenGate. Which feature of Autonomous Database can be leveraged alongside GoldenGate to prevent sequence cache duplication conflicts across regions?

A.Setting the database character set to AL32UTF8 to handle multi-region strings
B.Configuring autonomous database global sequences with specific increment and offset parameters
C.Using Oracle Autonomous Health Framework to automatically resolve distributed deadlocks
D.Enabling Autonomous Data Guard in Snapshot Standby mode in all regions simultaneously
AnswerB

Correct. Using SEQUENCE ... INCREMENT BY <num_regions> START WITH <offset> avoids primary key conflicts across distributed multi-master or replicated nodes.

Why this answer

When deploying multi-region distributed writes or replication architectures, utilizing Oracle Database features such as sequence caching with ORDER and NOORDER or scaling ranges prevents primary key collisions across nodes.

Practice this question →
44
MCQeasy

When creating an Oracle Base Database system, which database edition options are available for licensing on OCI?

A.Oracle Database Express Edition (XE) exclusively
B.Standard Edition 2, Enterprise Edition, Enterprise Edition High Performance, and Enterprise Edition Extreme Performance
C.Microsoft SQL Server Enterprise Edition
D.MySQL Enterprise Edition and PostgreSQL Community Edition only
AnswerB

Correct. These are the standard supported Oracle Database editions available when provisioning Base Database systems on OCI.

Why this answer

Oracle Base Database systems support Standard Edition 2, Enterprise Edition, Enterprise Edition High Performance, and Enterprise Edition Extreme Performance.

Practice this question →
45
MCQmedium

You need to migrate an on-premises Oracle Database to OCI Exadata Database Service using Oracle GoldenGate for zero-downtime migration with bi-directional replication. Which critical design consideration must be addressed regarding table design on both databases?

A.Primary keys must be omitted to allow duplicate row insertion across databases
B.Tables must have primary keys or unique identifiers, and Conflict Detection and Resolution (CDR) must be configured
C.Tables must not contain any indexes, triggers, or constraints
D.All tables must be converted to temporary unlogged tables
AnswerB

Correct. Bi-directional replication requires unique row identifiers and CDR to resolve update conflicts.

Why this answer

In bi-directional GoldenGate replication, tables must have a primary key or unique identifier, and conflict detection and resolution (CDR) strategies must be implemented to handle concurrent updates.

Practice this question →
46
MCQhard

An architect is designing an Oracle Exadata Database Service on Dedicated Infrastructure deployment with multiple VM clusters on a single Exadata rack. Which architectural feature allows secure isolation of CPU, memory, and database workloads between these distinct VM clusters?

A.OCI Block Volume volume group replicas synchronized via block replication
B.Software-defined VLAN tagging enforced by the OCI Virtual Cloud Network (VCN) hypervisor only
C.Autonomous Database container database resource pools sharing a single OS kernel
D.Hard partitioning using Oracle VM (dom0/domU) hypervisor virtualization on the database servers
AnswerD

Correct. Dom0/domU virtualization isolates CPU and memory resources across separate VM clusters on the same Exadata rack.

Why this answer

Exadata VM clusters utilize Oracle Virtual Machine (dom0/domU) virtualization architecture to completely isolate resources between different clusters on the same physical rack.

Practice this question →
47
MCQmedium

You are migrating an on-premises Oracle Database (version 19c) to Oracle Autonomous Database (Serverless) using Oracle Data Pump. Which action is mandatory to ensure compatibility before generating the Data Pump export dump file?

A.Disable Automatic Workload Repository (AWR) collection on the source database
B.Convert the source database into an Oracle Multitenant Container Database with a single pluggable database
C.Run the DBMS_CLOUD.PREPARE_FOR_AUTONOMOUS PL/SQL package on the source database
D.Manually drop all custom triggers and indexes to prevent import failures
AnswerC

Correct. This package performs necessary pre-checks and transformations to ensure compatibility with Autonomous Database.

Why this answer

When migrating to Autonomous Database using Data Pump, you must run the DBMS_CLOUD.PREPARE_FOR_AUTONOMOUS procedure or use the Autonomous Database Migration tool to check and convert incompatible tablespaces, segments, and objects.

Practice this question →
48
MCQeasy

An enterprise requires deploying an Oracle Autonomous Database on Dedicated Infrastructure to meet stringent data isolation and security mandates. Which foundational resource must be provisioned first before creating the Autonomous Container Database?

A.An Autonomous Database on Shared Infrastructure instance
B.A standard Oracle Base Database system
C.A Virtual Cloud Network with a default database subnet only
D.An Autonomous Exadata Infrastructure resource
AnswerD

Correct. The Autonomous Exadata Infrastructure must be created first as the foundational appliance layer.

Why this answer

Before you can provision an Autonomous Container Database (ACD) on Dedicated Infrastructure, you must provision an Autonomous Exadata Infrastructure resource which allocates the underlying physical Exadata compute and storage resources.

Practice this question →
49
MCQmedium

Your organization runs a multi-tenant Oracle Base Database Service and you need to monitor the storage utilization of individual Pluggable Databases (PDBs) within a Container Database (CDB). Which OCI native service and metric should you review?

A.OCI Logging Analytics with custom log parsers for alert.log.
B.OCI Database Management service PDB storage metrics.
C.Compute Instance metrics via OCI Monitoring service agent.
D.Autonomous Health Framework (AHF) health check reports.
AnswerB

Database Management provides native visibility into individual PDB metrics including tablespace and storage usage.

Why this answer

Oracle Database Management service provides comprehensive monitoring capabilities for CDBs and PDBs, including detailed storage utilization metrics.

Practice this question →
50
MCQhard

An enterprise application uses an Oracle Autonomous Transaction Processing database and encounters intermittent application-level timeouts during peak concurrency spikes. Upon investigating, you notice that queued statements are waiting due to resource limits. Which Autonomous Database feature should you adjust to manage concurrency and statement queuing behavior?

A.The physical memory size of the OCI Compute host instance running the application
B.Linux kernel swappiness parameters on the database host
C.OCI Virtual Cloud Network security list packet drop thresholds
D.Consumer groups and resource management rules via DBMS_RESOURCE_MANAGER or resource profile settings
AnswerD

Correct. Adjusting resource consumer groups and parallelism controls how queries are queued and executed under high concurrency.

Why this answer

Autonomous Database allows managing resource management rules and consumer groups, including setting parameters via DBMS_RESOURCE_MANAGER or adjusting CPU/concurrency profiles.

Practice this question →

Ready to test yourself?

Try a timed practice session using only Databases questions.

Start 20-question session