Databases practice questions

Autonomous Spark Analytics Engine (ASAE)

Why wrong: Incorrect. ASAE is not an official Autonomous Database workload type.

Autonomous Hadoop Distributed File System (AHDFS)

Why wrong: Incorrect. AHDFS does not exist as an Autonomous Database workload.

The number of local user SSH keys required for root password resets

Why wrong: Incorrect. SSH keys are for access control, not resource sizing.

OCI Identity and Access Management policy statement limits

Why wrong: Incorrect. IAM policy limits are unrelated to Exadata hardware sizing.

The public IP bandwidth quotas allocated to OCI API endpoints

Why wrong: Incorrect. API quotas do not dictate database compute/storage sizing.

Disable Automatic Workload Repository (AWR) collection on the source database

Why wrong: Incorrect. AWR collection is irrelevant to Data Pump migration compatibility.

Convert the source database into an Oracle Multitenant Container Database with a single pluggable database

Why wrong: Incorrect. While Autonomous Database uses PDB architecture under the hood, the migration source does not strictly need to be converted to a local multitenant container beforehand if Data Pump is used.

Manually drop all custom triggers and indexes to prevent import failures

Why wrong: Incorrect. Custom indexes and triggers are supported and should not be dropped manually.

Manual RMAN backup replication via OCI Object Storage every 15 minutes

Why wrong: Incorrect. Backup-based replication results in an RPO of 15 minutes and does not meet the strict RPO/RTO requirements.

Oracle Data Guard configured in Maximum Performance mode with asynchronous transport

Why wrong: Incorrect. Maximum Performance mode allows asynchronous transport, which can introduce a non-zero RPO during network latency spikes.

Oracle GoldenGate real-time replication with asynchronous extract configurations

Why wrong: Incorrect. GoldenGate asynchronous extract cannot guarantee an RPO of zero under all catastrophic failure scenarios compared to physical standby in Maximum Protection.

Direct database clone via SQL*Developer migration wizard

Why wrong: Incorrect. SQL*Developer migration is unsuitable for a 50 TB enterprise database workload.

Oracle GoldenGate initial load using SQL direct paths

Why wrong: Incorrect. GoldenGate is designed for replication, not bulk initial transport of entire storage formats with endian conversion.

Standard Oracle Data Pump export and import over direct database links

Why wrong: Incorrect. Data Pump handles endian conversion logically, but for a 50 TB database, Data Pump is extremely slow compared to binary transportable tablespaces.

OCI Compute Instance Scheduler

Why wrong: Incorrect. Compute Instance Scheduler is designed for virtual machine power states, not database internals.

Oracle Cloud Infrastructure GoldenGate deployment console

Why wrong: Incorrect. GoldenGate is used for data replication, not database fleet patching or backup orchestration.

OCI Identity and Access Management (IAM) policies

Why wrong: Incorrect. IAM handles security access control, not database patching or backups.

An Autonomous Database on Shared Infrastructure instance

Why wrong: Incorrect. Shared infrastructure is a separate deployment model and not required for dedicated infrastructure setup.

A standard Oracle Base Database system

Why wrong: Incorrect. Base Database systems are unrelated to Autonomous Database on Dedicated Infrastructure.

A Virtual Cloud Network with a default database subnet only

Why wrong: Incorrect. While networking is required, the primary foundational OCI resource specific to dedicated infrastructure is the Autonomous Exadata Infrastructure.

Generate a Kerberos ticket granting service token via the IAM security console

Why wrong: Incorrect. Kerberos is an alternative authentication mechanism, not the default mTLS wallet retrieval method.

Retrieve the master encryption key directly from OCI Vault using an API key

Why wrong: Incorrect. OCI Vault manages encryption keys, not database client connection wallets.

Configure a public SSL certificate issued by Let's Encrypt in the database parameter settings

Why wrong: Incorrect. Autonomous Database handles its internal server certificates via the managed wallet structure.

Automatic conversion of all JSON documents into relational third-normal-form tables upon ingestion

Why wrong: Incorrect. JSON documents are stored natively in OSON format without forcing relational normalization.

Mandatory requirement to define fixed database schemas via JSON Schema validators before inserting data

Why wrong: Incorrect. Schema-less design is a core tenet of Autonomous JSON Database.

Exclusion of automated backups to reduce operational overhead

Why wrong: Incorrect. Automated backups are fully enabled and mandatory on all Autonomous Database variants.

Exactly three times the base OCPU count provisioned for the database instance

Why wrong: Incorrect. The 3x limit applies primarily to Autonomous Database on Shared Infrastructure, not Dedicated Infrastructure.

An unlimited amount limited only by OCI regional capacity limits

Why wrong: Incorrect. Auto-scaling is bounded by the specific Exadata rack or quarter-rack sizing provisioned.

Fixed at a maximum of 128 OCPUs regardless of hardware size

Why wrong: Incorrect. Limits depend on the shape of the Exadata infrastructure.

It requires the customer to manage physical rack power, cooling, and hardware replacement

Why wrong: Incorrect. Oracle manages the physical hardware in both OCI data centers and Cloud@Customer environments.

It exclusively supports non-relational database formats unlike Cloud@Customer

Why wrong: Incorrect. Both support standard Oracle Database workloads.

It eliminates the need for Virtual Cloud Networks (VCNs)

Why wrong: Incorrect. VCN networking is required for both.

Setting the database character set to AL32UTF8 to handle multi-region strings

Why wrong: Incorrect. Character sets govern string encoding, not sequence generation or primary key collision avoidance.

Using Oracle Autonomous Health Framework to automatically resolve distributed deadlocks

Why wrong: Incorrect. Health framework diagnoses issues; it does not configure multi-region sequence intervals.

Enabling Autonomous Data Guard in Snapshot Standby mode in all regions simultaneously

Why wrong: Incorrect. Data Guard does not support multi-master active-active writes across regions concurrently.

OCI Object Storage lifecycle policies exclusively

Why wrong: Incorrect. Object storage is used for staging dumps, but the core migration engine relies on RMAN/Data Guard.

Third-party ETL pipelines and CSV flat file generation

Why wrong: Incorrect. ZDM automates native database engines, not third-party ETL tools.

MySQL Enterprise Backup and InnoDB replication

Why wrong: Incorrect. MySQL tools are irrelevant to migrating Oracle Databases.

OCI Block Volume performance tiers (Higher VPU settings)

Why wrong: Incorrect. Exadata uses internal high-performance flash and disk storage cells managed via IORM, not standard OCI block volume VPUs.

Autonomous Database concurrency limits in the OCI console

Why wrong: Incorrect. Concurrency limits apply to Autonomous Database statement execution, not Exadata storage cell level I/O throttling.

OCI Compute Auto-scaling configurations on the domU guest VMs

Why wrong: Incorrect. Compute auto-scaling manages CPU/RAM, not underlying Exadata cell storage I/O prioritization.

Autonomous JSON Database (AJD)

Why wrong: Incorrect. AJD is optimized for document-store and collection workloads.

Autonomous Transaction Processing (ATP)

Why wrong: Incorrect. ATP is optimized for OLTP and mixed workloads, not heavy data warehousing.

Autonomous Apex Application Development (APEX)

Why wrong: Incorrect. APEX is tailored for low-code application development environments.

Deploy an internet gateway with IPSec VPN tunnels terminating at the backup bucket

Why wrong: Incorrect. Internet gateways expose traffic to the public internet; VPNs are for on-premises connectivity.

Expose a NAT Gateway with strict IP whitelisting

Why wrong: Incorrect. NAT gateways route traffic to the public internet, which violates zero-public-exposure mandates.

Attach a secondary public IP address to the database VM guest nodes

Why wrong: Incorrect. Public IPs introduce unnecessary public internet exposure for database backup streams.

The standby database automatically accepts write operations and replicates them back to the primary

Why wrong: Incorrect. Data Guard is unidirectional for writes (primary to standby).

The standby database accepts read-write transactions concurrently with the primary database

Why wrong: Incorrect. Active-active write configurations are not supported by Data Guard.

The standby database is completely inaccessible until a manual switchover or failover occurs

Why wrong: Incorrect. Unlike traditional physical standbys that might require manual role transitions, Autonomous Data Guard standby is accessible for reads.

Network File System (NFS) shared mounts from a third-party NAS filer

Why wrong: Incorrect. NFS is not the primary storage architecture for high-performance Oracle Base Database systems on OCI.

Raw Device Mapping (RDM) shared via Fibre Channel SAN

Why wrong: Incorrect. OCI does not expose traditional Fibre Channel SAN storage via RDM to database VMs.

Local NVMe drives directly attached to the hypervisor without redundancy

Why wrong: Incorrect. Base databases use network-attached OCI Block Storage with ASM, not raw local NVMe without protection.

OCI Web Application Firewall (WAF) attached directly to the database listener port

Why wrong: Incorrect. WAF protects HTTP/HTTPS traffic, not direct SQL/TNS database traffic.

OCI Identity and Access Management dynamic groups

Why wrong: Incorrect. IAM dynamic groups handle resource principal authorizations, not network layer IP filtering.

Database Vault realm restrictions

Why wrong: Incorrect. Oracle Database Vault secures internal database data against privileged users, not network ingress IPs.

Periodic RMAN duplication scripts executed via cron jobs every hour

Why wrong: Incorrect. Cron-based RMAN duplication is not an active HA pattern and results in high RPO.

Active-Active Oracle RAC cluster spanning multiple Availability Domains over long-distance synchronous interconnects

Why wrong: Incorrect. Oracle RAC requires ultra-low latency interconnects (< 5-10ms) and is restricted to a single Availability Domain or local rack, not stretched across ADs.

Shared OCI Block Volumes mounted simultaneously by database nodes in different ADs

Why wrong: Incorrect. OCI Block Volumes cannot be attached across multiple Availability Domains simultaneously.