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?
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?
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?
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?
Which feature of Oracle Autonomous Database automatically inspects and tunes SQL statements, creates indexes, and optimizes execution plans without human intervention?
You are configuring a Data Guard association for an Autonomous Database on Dedicated Infrastructure. How is the Data Guard standby database provisioned and managed?
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?
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 DBA needs to configure automatic backups for an Oracle Base Database Service instance. Which retention period range is natively supported for automated backups?
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?
When provisioning an Exadata Database Service on Dedicated Infrastructure, what is the fundamental hardware unit that you provision first before creating database deployments?
When configuring automated backups for an Oracle Base Database System on OCI, which THREE options or parameters can you configure or customize? (Choose three.)
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?
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?
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?
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?
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?
When connecting securely to an Autonomous Database instance, what file must be downloaded from the OCI Console and provided to your database client applications?
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?
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?
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?
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?
Which type of Oracle database deployment provides full administrative privileges (SYS and SYSTEM access) at the operating system and database level in OCI?
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?
When provisioning an Autonomous Database, what parameter determines the initial compute and storage capacity allocated to the database, which can be scaled independently later?
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
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?
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?
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?
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?
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?
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?
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?
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?
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?
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?
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?
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?
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?
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?
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?
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?
When provisioning an Oracle Base Database Service DB system, which storage management software is used underneath to provide high performance and reliable storage volumes?
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?
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?
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?
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?
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?
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.)
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?
Which THREE features are provided natively by Exadata Cloud Service to deliver high performance and high availability for Oracle databases? (Choose three.)
You are managing an Oracle Base Database Service DB system on OCI. The DB system hosts a production database, and you must configure Oracle Data Guard so the standby database can take over automatically with no data loss. The primary and standby must be in different availability domains of the same region, and you want to minimize manual intervention during a switchover. Which TWO configuration choices should you make? (Choose two.)
You are configuring an Oracle Autonomous Database on dedicated Exadata infrastructure. The database must be isolated at the network level so that application clients reach it only through a private endpoint inside a VCN, with no public internet exposure at all. Which configuration should you choose when provisioning the Autonomous Database?