20+ practice questions focused on Database — one of the most tested topics on the Oracle Cloud Infrastructure 2026 Architect Associate (1Z0-1072-26) (1Z0-1072-26) exam. Each question includes a detailed explanation so you learn why the right answer is correct.
Start Database PracticeYou 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?
Explanation: 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.
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?
Explanation: Oracle Cloud Infrastructure (OCI) provides built-in workflows in the OCI Console and the command-line utility `dbaascli` to manage, patch, and upgrade database homes and operating systems on Oracle Base Database Systems.
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?
Explanation: Maximum Availability mode provides the highest level of data protection that is possible without compromising the availability of the primary database. It uses synchronous redo transport (SYNC) to ensure zero data loss, but if the standby becomes unavailable, the primary will continue to process transactions (unlike Maximum Protection, which would shut down).
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?
Explanation: OCI Object Storage is the standard staging area for manual RMAN backups of Oracle Base Database Systems because it provides scalable, durable, and cost-effective object storage accessible via the internet or private endpoints. RMAN can back up directly to Object Storage using the Oracle Database Cloud Backup Module, which integrates with the S3-compatible API. This allows DBAs to move backup files off the database system and later restore or transfer them as needed, without provisioning block or file storage.
Which feature of Oracle Autonomous Database automatically inspects and tunes SQL statements, creates indexes, and optimizes execution plans without human intervention?
Explanation: Oracle Autonomous Database features self-tuning capabilities that include automatic indexing, which automatically creates, rebuilds, and drops indexes based on workload, alongside automatic SQL tuning to optimize execution plans.
+15 more Database questions available
Practice all Database questions1. Baseline your knowledge
Start with 10 questions to gauge your current understanding of Database. This tells you whether you need a concept refresher or just practice.
2. Review every explanation
For each question — right or wrong — read the full explanation. Understanding why an answer is correct is more valuable than knowing the answer itself.
3. Focus on exam traps
Database questions on the 1Z0-1072-26 frequently use trap wording. Look for subtle differences in answers that test your precision, not just general knowledge.
4. Reach 80% consistently
Do repeated sessions until you score 80%+ three times in a row. Then move to mixed-mode practice to test cross-topic recall under realistic conditions.
The exact number varies per candidate. Database is tested as part of the Oracle Cloud Infrastructure 2026 Architect Associate (1Z0-1072-26) (1Z0-1072-26) blueprint. Practicing with targeted Database questions ensures you can handle any format or difficulty that appears.
Yes. Courseiva provides free 1Z0-1072-26 practice questions across all exam topics and domains. The platform includes topic-based practice, mock exams, missed-question review, bookmarked questions, and readiness tracking — no account required.
Difficulty is subjective, but Database is a high-priority exam concept tested in multiple ways — direct recall, scenario analysis, and command-output interpretation. Consistent practice is the best way to build confidence.
Launch a full Database practice session with instant scoring and detailed explanations.
Start Database Practice →