A financial services firm has deployed a new VM DB System using the Base Database Service for a critical application. The security team reports that although the database is functional, it is accessible from an unauthorized subnet within the VCN. The system was provisioned with the intention of being isolated. Which configuration is the most likely cause of this unintended network exposure?
Q2
A data analytics company uses a BaseDB VM DB System for long-term data archival and infrequent analysis. The database is 10 TB, and full backups are configured to run weekly to OCI Object Storage. The company is under pressure to reduce operational costs without violating a 7-year data retention policy. Which strategy provides the most significant cost savings for storing these backups?
Q3Multiple answers
A systems integrator is designing a cross-region disaster recovery (DR) solution for a customer's critical OLTP application running on a BaseDB VM DB System. The requirements are a Recovery Point Objective (RPO) near zero and a Recovery Time Objective (RTO) of less than 15 minutes. Which TWO components are essential to build this solution? (Select TWO)
Q4
A global investment bank is migrating its on-premises Oracle Database to OCI. They require a solution that offers maximum control over the database software and underlying operating system for applying custom security hardening scripts, while also leveraging Oracle Real Application Clusters (RAC) for high availability. The solution must comply with strict data sovereignty regulations, requiring all data and management to reside within a specific country. The IT team has evaluated OCI database offerings and is focusing on the Base Database Service. They must ensure that patching for the OS, Grid Infrastructure, and Database is managed by their internal DBA team to align with their quarterly change management cycles. Performance is critical, requiring low-latency storage. Which Base Database Service configuration should the architect recommend to meet all these requirements?
Q5
A startup is launching its first application on OCI and needs to provision a cost-effective Oracle Database. They have already purchased Oracle Database Enterprise Edition licenses through a perpetual license agreement and want to leverage this existing investment. Which licensing model should they select when provisioning their Base Database Service VM DB System?
Q6
True or False: When using a Base Database Service VM DB System, the customer is responsible for patching the guest operating system, the Grid Infrastructure, and the Oracle Database software.
Q7
A development team needs a full copy of a 2 TB production database running on a BaseDB VM DB System for performance testing a new application feature. The goal is to create the copy as quickly as possible with minimal impact on the source production database. Which method should be used?
Q8
An architect is designing a BaseDB VM DB System for a write-intensive OLTP application that requires the highest possible IOPS and lowest latency. Cost is a secondary concern to performance. Which storage configuration should be selected during provisioning?
Q9
A DBA is tasked with configuring a custom backup retention policy for a BaseDB VM DB System. The requirement is to retain daily incremental backups for 14 days and the first full backup of each month for one year. How can this be achieved using the OCI Console?
Q10
An e-commerce platform running on Exadata Cloud Service experiences significant performance degradation during peak holiday sales. A DBA observes high 'cell physical IO bytes saved by smart scan' but also a high 'cell physical IO interconnect bytes returned by smart scan' metric. The application team confirms that queries are running slower than expected. What is the most likely cause of this performance issue? ```mermaid graph TD App[Application] --> |SQL Query| DB[Database Node] DB --> |Predicate Info| Cells[Storage Cells] subgraph Storage Cells A[Cell 1: Smart Scan] -->|Filtered Data| B(Interconnect) C[Cell 2: Smart Scan] -->|Filtered Data| B D[Cell 3: Smart Scan] -->|Filtered Data| B end B --> |Large Result Set| DB DB --> |Slow Response| App ```