nerdexam
Oracle

1Z0-116 · Question #68

You are required to remove embedded passwords from scripts that connect to database instances. Which tool can be used to implement this requirement?

The correct answer is C. dbca. Important note: The provided correct answer of C (dbca) appears to be incorrect for this question. Based on Oracle documentation and exam objectives, the correct answer should be E (mkstore). --- mkstore is the Oracle command-line utility for creating and managing Oracle…

Implementing Basic Database Security

Question

You are required to remove embedded passwords from scripts that connect to database instances. Which tool can be used to implement this requirement?

Options

  • Aorapki
  • Bnetca
  • Cdbca
  • Dnetmgr
  • Emkstore
  • Fowm

How the community answered

(25 responses)
  • C
    96% (24)
  • E
    4% (1)

Explanation

Important note: The provided correct answer of C (dbca) appears to be incorrect for this question. Based on Oracle documentation and exam objectives, the correct answer should be E (mkstore).


mkstore is the Oracle command-line utility for creating and managing Oracle Wallets, which is precisely the mechanism used to eliminate embedded passwords from scripts. You use mkstore -wrl <wallet_path> -createCredential <alias> <user> <pass> to store credentials securely, then scripts connect via a wallet alias instead of a hardcoded password.

Why the others are wrong:

  • A (orapki) - manages Oracle PKI (certificates, keys, wallet structure), not credential storage for scripts
  • B (netca) - Net Configuration Assistant configures listeners and naming; unrelated to password removal
  • C (dbca) - Database Configuration Assistant creates/configures databases; it does not manage script credentials
  • D (netmgr) - Net Manager is a GUI for Oracle Net configuration, not credential management
  • F (owm) - Oracle Wallet Manager is the GUI counterpart to mkstore; if this were a valid option it would compete, but mkstore is the standard exam-tested CLI tool

Memory tip: Think "mkstore = make a secure store" - it's your tool for making a wallet that stores database passwords so scripts never need to embed them.


If this question came from a specific study guide, I'd recommend cross-checking against Oracle's official documentation - exam answer keys for wallet/credential management questions consistently point to mkstore.

Topics

#credential storage#password management#secure configuration#database tools

Community Discussion

No community discussion yet for this question.

Full 1Z0-116 Practice