nerdexam
Oracle

1Z0-116 · Question #88

Examine this command: What masking definitions does it list?

The correct answer is C. All with the name credit and created on databases with name starting with teat. Option C is correct because the command filters masking definitions by the exact name "credit" (not a prefix/wildcard match) and by databases whose names begin with "test" - these two constraints together precisely describe the command's output. Why the distractors are wrong: A…

Implementing Data Protection

Question

Examine this command:

What masking definitions does it list?

Options

  • AAll with the name credit and the commands to deploy them on all databases with names starting
  • BAll with names starting with credit and created on databases with names starting with test.
  • CAll with the name credit and created on databases with name starting with teat.
  • DAll with names starting with credit and created on any database.
  • EAll with the name credit and the commands to deploy them on a database with the name test.

How the community answered

(35 responses)
  • B
    6% (2)
  • C
    91% (32)
  • D
    3% (1)

Explanation

Option C is correct because the command filters masking definitions by the exact name "credit" (not a prefix/wildcard match) and by databases whose names begin with "test" - these two constraints together precisely describe the command's output.

Why the distractors are wrong:

  • A & B & D all describe names starting with "credit" - this implies a wildcard/prefix match, but the command uses an exact name filter, so only definitions named precisely "credit" are returned.
  • A & E mischaracterize the output as including deployment commands, which the command does not produce - it only lists definitions.
  • D drops the database name filter entirely, which is incorrect since the command scopes results to specific databases.
  • E implies the database name must be an exact match of "test," whereas the command matches any database whose name starts with "test."

Note: Option C contains what appears to be a typo ("teat" instead of "test") - on the real exam, read answer choices character-by-character, as distractors sometimes exploit near-identical spellings.

Memory tip: Think of the two key axes - definition name (exact match) and database name (prefix match). If an option gets either of those wrong - flipping exact↔prefix or adding extra output - it's a distractor.

Topics

#Data Masking#Masking Definitions#Command Syntax#Filter Parameters

Community Discussion

No community discussion yet for this question.

Full 1Z0-116 Practice