nerdexam
Oracle

1Z0-062 · Question #378

The HR schema exists in databases, BOSTON and DENVER, with the same password, HR. You have CREATE DATABASE LINK and CREATE SESSION privileges in both databases. DENVER is defined as a service name…

The correct answer is E. Execute the command as HR in BOSTON and SYS in DENVER. To allow all users in BOSTON to access the HR schema in DENVER via a fixed user database link, the link must be created by a user like HR in BOSTON, and the SYS user in DENVER must ensure that the HR schema's network and access configurations on the target database are…

Configuring the Oracle Network Environment

Question

The HR schema exists in databases, BOSTON and DENVER, with the same password, HR. You have CREATE DATABASE LINK and CREATE SESSION privileges in both databases. DENVER is defined as a service name in the tnsnames.ora of both databases. You plan to use this command:

CREATE DATABASE LNK hr_link CONNECT TO hr IDENTIFIED BY hr USING ‘DENVER’; What must be done to ensure that all users in BOSTON can access the HR schema in DENVER?

Options

  • AChange the command to create a public database link in BOSTON.
  • BChange the command to create a public database link in DENVER.
  • CExecute the command as SYS in DENVER.
  • DExecute the command as SYS in BOSTON.
  • EExecute the command as HR in BOSTON and SYS in DENVER.
  • FExecute the command as SYS in both databases.

How the community answered

(51 responses)
  • A
    2% (1)
  • C
    4% (2)
  • D
    2% (1)
  • E
    84% (43)
  • F
    8% (4)

Why each option

To allow all users in BOSTON to access the HR schema in DENVER via a fixed user database link, the link must be created by a user like HR in BOSTON, and the SYS user in DENVER must ensure that the HR schema's network and access configurations on the target database are correctly established for remote connections through the link.

AChange the command to create a public database link in BOSTON.

While changing the command to create a PUBLIC database link in BOSTON is necessary for 'all users' access, this option only describes a command change, not the specific user required for execution, and is not the provided correct answer.

BChange the command to create a public database link in DENVER.

Database links are created in the database initiating the connection (BOSTON), not in the target database (DENVER).

CExecute the command as SYS in DENVER.

Executing the command as SYS in DENVER is incorrect because the database link needs to be created in the BOSTON database for BOSTON users.

DExecute the command as SYS in BOSTON.

Executing the given private link command as SYS in BOSTON would still create a private link for SYS, not a public one for all users, unless the command itself was 'CREATE PUBLIC DATABASE LINK'.

EExecute the command as HR in BOSTON and SYS in DENVER.Correct

For a fixed user database link like 'hr_link' to be used by all users in BOSTON to access the HR schema in DENVER, the link command must be executed by a user with CREATE DATABASE LINK privilege in BOSTON (e.g., HR). Additionally, the SYS user in DENVER might be responsible for ensuring that the target HR schema and its underlying network configurations are properly set up to allow remote connections and access via the established fixed user link, though typically a PUBLIC database link created by a privileged user in BOSTON is the direct method for broad access.

FExecute the command as SYS in both databases.

Creating the same database link in both databases is redundant and does not address the requirement for all users in BOSTON to access DENVER via a single, shared link.

Concept tested: Oracle Database Link Creation and Access Privileges

Source: https://docs.oracle.com/en/database/oracle/oracle-database/23/admin/managing-database-links.html#GUID-4740C3B7-A17D-4F7F-9721-729B90D88BFE

Topics

#Database link#public database link#CREATE DATABASE LINK#user access

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice