Network Topology  «Prev  Next»

Oracle Cloud Network Topology - Exercise

Overview of Oracle Network Topology, Part 3

Design a Secure Database Link Strategy

Objective: Plan a modern Oracle Cloud database link, write a remote query, and explain how location transparency can be presented safely to application users.

Exercise scoring

This exercise is worth a total of 10 points. Read the scenario and respond to all three tasks.

Background

Your company runs its primary Oracle workload in Oracle Cloud Infrastructure (OCI) in the US Midwest region. A newly integrated business unit runs a second Oracle database in the Japan Central region. The architecture team wants analysts in the US environment to read selected customer data from the Japan database without copying all data into the local system.

The remote environment is managed under modern Oracle Cloud security standards. Instead of relying on legacy Oracle Net8 assumptions and hard-coded passwords in scripts, your solution should assume a secured Oracle networking model, least-privilege access, and encrypted connectivity between databases.

Your task is to describe how a DBA or cloud database engineer would approach this requirement using a database link in a current Oracle environment.

Instructions

  1. Write the SQL needed to create a database link named asia_link that connects to a remote Oracle database. Use placeholder values such as remote_user, remote_password, and japan_service rather than real credentials.
  2. Write a SQL query that returns all rows from the remote customer table by using the database link.
  3. Explain one modern way to make remote access simpler for application users, such as exposing a local synonym or view, while still keeping security and maintainability in mind.

What this exercise is testing

This exercise tests whether you understand:
  • how Oracle database links support distributed access across environments,
  • how remote objects are queried with the @dblink syntax,
  • why modern Oracle Cloud designs avoid embedding real credentials in training examples,
  • and how synonyms or views can provide location transparency for users and applications.

Submitting the exercise

Type or paste your answer into the text area below, then click Submit to view the exercise result page.

Instructor note

In production systems, database links should be designed with current Oracle security guidance in mind. Oracle documents that database links are created with the CREATE DATABASE LINK statement, and Oracle Autonomous Database documentation emphasizes secure connectivity patterns such as TCPS and credential-based link creation for cloud deployments. Oracle’s distributed database administration guidance also places database links within the broader context of location transparency and managed distributed access. :contentReference[oaicite:0]{index=0}