A database link must be created to connect a source Autonomous Database to target on premises database. Examine this command: Which two options are true?

Question

Exhibit

Options

• AThe target database wallet can be uploaded to the data_pctmp_dtr directory.
• BThe db_link_cred parameter stores the password in a wallet.
• CThe db__link__cred references the credential for the username and password for the target
• DThe credential_nam?parameter automatically creates the credential object store.
• EThe database link port Is not correct because It must be restricted to 1521.
• FOnly data_pump_dir directory can be used to store credential wallets.

• A
  6% (1)
• B
  65% (11)
• C
  18% (3)
• F
  12% (2)

Explanation

Options B and D are correct because, in Oracle Autonomous Database, the db_link_cred (credential) parameter securely stores the target database password inside an Oracle Wallet rather than as plain text - and when you supply the credential_name parameter to DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK, it automatically provisions the underlying credential object store, so you don't need to create it manually beforehand.

Why the distractors are wrong:

• A - The directory name data_pctmp_dtr is not a valid or recognized directory for wallet uploads; only sanctioned directories (such as DATA_PUMP_DIR) are permitted.
• C - The parameter name db__link__cred (double underscores) is syntactically incorrect; the real parameter is credential_name or db_link_cred, so this option mixes up naming and is misleading.
• E - The port is not restricted to 1521; Oracle database links support other valid port numbers depending on the listener configuration of the target.
• F - Multiple directories can store credential wallets, so the "only DATA_PUMP_DIR" claim is too restrictive and false.

Memory tip: Think "B = Bevault (wallet security), D = Done-for-you credential store" - Autonomous DB handles wallet encryption (B) and auto-creates the credential object so you don't have to (D). Any option claiming a hard restriction (port must be 1521, only one directory allowed) is almost always a trap on Oracle exams.

No community discussion yet for this question.